Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 92ED2200C16 for ; Thu, 9 Feb 2017 16:15:54 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 918D4160B50; Thu, 9 Feb 2017 15:15:54 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id D378C160B4C for ; Thu, 9 Feb 2017 16:15:53 +0100 (CET) Received: (qmail 7358 invoked by uid 500); 9 Feb 2017 15:15:53 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 7346 invoked by uid 99); 9 Feb 2017 15:15:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Feb 2017 15:15:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 49B4DC03A2 for ; Thu, 9 Feb 2017 15:15:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.481 X-Spam-Level: ** X-Spam-Status: No, score=2.481 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=masslight-net.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 8JblSAd1Cjqv for ; Thu, 9 Feb 2017 15:15:51 +0000 (UTC) Received: from mail-wm0-f48.google.com (mail-wm0-f48.google.com [74.125.82.48]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id C24E65F1F4 for ; Thu, 9 Feb 2017 15:15:50 +0000 (UTC) Received: by mail-wm0-f48.google.com with SMTP id c85so233988085wmi.1 for ; Thu, 09 Feb 2017 07:15:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=masslight-net.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=e8stPBTTDW5seT/h9ULpiFtctIBM/083P9fCBY8U4PA=; b=azYu/MI05Ms3pU7zvCoDipoSoNWRwpguZkuzHDKIHBf18T7m9fTzen/p30vrVKP3tI byndTPCUk/vPXcu3W85hnaRmrD5nVZUXzvD9w0hSOGDsK84eeL5xzbUfb81nNGW/S4vE QGZiDcpLv6EpGQtDRljUDSa0HHbAh+u8TlpFPEY30NnMD08tBcH4HRmpe+W1WZMMHiAa 3Fa1RX06sBGDrOx5FPNa4nYMtOuKtk9BSgylAQ6c/vmxZtGvjdKCGWgTSmeueN/V4jQs ypILf4oUqiajNlQvCptV0wMhRYdlgPQGUjhOGHbOO9pihHpLr6klhs6Y7QMnoh3eEtzw MWcw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=e8stPBTTDW5seT/h9ULpiFtctIBM/083P9fCBY8U4PA=; b=JWd2Hweqa/0g+M7uhkSM7jRSnxgVw3ZxxkWdjhIzUiie+coeR9icRIdsKN9srgzqk0 BWJljfcfASWdsYmM/DnkIqllMk9KsFyCvtOSEtDeSXO8o9dn7FYubi305wylte1dT2tb w0hGsRaEVJl6AjeGSfeBQpYK3f822SVygD9tiw9eE3wLm3uGBhUeP/EzCHrQ8UP2SxP4 F99HC7TT/Hmfu4tZ95czGOHazVMSArrgEQ4FG/dvL280iOBqHV55aVoruj7VB+1zIOwK uvt/wgZHpsfenfgDMtXwTK3n2/+XhPkHB0YIiW2IaIK2OI+KVrDn/IZftEtXGZuZHo+E D7+A== X-Gm-Message-State: AMke39lcJfvNzrZHkEEP9X2vsLj4Lod5u4kJT5ABET3n6T1VtnWxBOREq/C4W6zRp19yBa8oToK80iFQKkBhSQ== X-Received: by 10.28.68.10 with SMTP id r10mr3536389wma.68.1486653343715; Thu, 09 Feb 2017 07:15:43 -0800 (PST) MIME-Version: 1.0 Received: by 10.80.185.68 with HTTP; Thu, 9 Feb 2017 07:15:23 -0800 (PST) In-Reply-To: References: From: Michael Gentry Date: Thu, 9 Feb 2017 10:15:23 -0500 Message-ID: Subject: Re: Cayenne and migrations To: Cayenne Users Content-Type: multipart/alternative; boundary=001a1148e73274eba605481a74c6 archived-at: Thu, 09 Feb 2017 15:15:54 -0000 --001a1148e73274eba605481a74c6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Hugi, We manage schema changes outside of Cayenne using Flyway (could also use Liquibase). Any schema changes we make are updated by hand in Cayenne Modeler. This works fairly well for us and fits in with our automated builds/etc. Perhaps not the answer you were looking for, though! mrg On Thu, Feb 9, 2017 at 9:21 AM, Hugi Thordarson wrote: > Hi all. > In EOF/WOnder we have the most swesome ERXMigrations to manage changes in > the data model between versions, i.e. upgrades of the schema (and > downgrades, if applicable). > > I see that some years ago there was discussion of an API to handle this i= n > Cayenne ( http://svn.apache.org/repos/asf/cayenne/sandbox/cayenne- > migrations/ ). but how=E2=80=99s the situation today? Is there something = in/for > Cayenne to do this, and if not, what tools are people using to manage > versioning of their DB schemas? > > Cheers, > - hugi --001a1148e73274eba605481a74c6--