Mailing-List: contact dev-help@continuum.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@continuum.apache.org
Received-SPF: pass (athena.apache.org: domain of wsmoak@gmail.com designates
 209.85.217.16 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=CQ20ZuKylGxjrFV2pwWSFCFMg6V/mRJjb65muqKi4sRZAWpzP7A6Ub1hFsWO4Twtef
         dGxTOqSElzpgOxwNujK4e61WpLko8FKbjLD0+0psEIa+1ttxFkNkMmFQrizU1u1TWKVU
         5eYenqn/jhHllCUmfuPViygdqew9ppS5/UnuA=
Message-ID: <adba96190809191117y43c09cc9w51b331ebb4536590@mail.gmail.com>
Date: Fri, 19 Sep 2008 11:17:45 -0700
From: "Wendy Smoak" <wsmoak@gmail.com>
To: dev@continuum.apache.org
Subject: Re: svn commit: r695183 - in /continuum/trunk:
 continuum-api/src/main/java/org/apache/continuum/dao/
 continuum-api/src/main/java/org/apache/maven/continuum/
 continuum-core/src/main/java/org/apache/maven/continuum/
 continuum-model/src/main/mdo/ contin
In-Reply-To: <748e286f0809191058s6adfde0dgfd25ea28aa215dd6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <9948cb690809140940l18ead957u650fdb0946c5eb7@mail.gmail.com>
	 <10c62ca80809141629o5b848b95je500f07e9809f411@mail.gmail.com>
	 <CDEBDE8A-CB5C-4620-B7AA-3299726A88EF@apache.org>
	 <748e286f0809191044i56e56956n471e392c872bbdb5@mail.gmail.com>
	 <adba96190809191050k4878d60bp81a9269bb783db44@mail.gmail.com>
	 <748e286f0809191058s6adfde0dgfd25ea28aa215dd6@mail.gmail.com>

On Fri, Sep 19, 2008 at 10:58 AM, Ken Liu <ken.liu@gmail.com> wrote:

> IMHO, even if some database fields are not mandatory, it is generally bad
> practice not to migrate databases. You really don't want some people having
> one schema and other users having a different schema - it just makes for
> more consistency in deployment and less support issues, especially when
> dealing with ORM tools.

I'm guessing you haven't tried to migrate a Continuum database. :)
The data management tools Need Work.  You can't just export and
import, even from the *same* version.  After importing, you have to
connect to the database and execute some SQL statements to fix things
up before it will work.  (The table that stores the next key values
apparently doesn't get updated properly.)

For the moment, it's preferable to be able to point a new Continuum
instance at an old database, and let JPOX do whatever it does.  (I
think it does add the new fields, btw.)

-- 
Wendy