continuum-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Porter <br...@apache.org>
Subject Re: DB schema migration
Date Tue, 24 Apr 2007 00:21:10 GMT
The problems Stephane has is because of the JPOX upgrade, not the  
schema changes we've made.

I'm not saying it won't be possible to migrate from 1.0.3, it just  
won't come out of the box (or necessarily be ready by the time the  
release goes out).

- Brett

On 23/04/2007, at 9:00 PM, Jesse McConnell wrote:

> any remaining changes in 1.1 will at _most_ be additive in the form of
> a boolean value here or there for some improvement, there should be no
> more changing of column names or anything of that ilk...Those were
> taken care of in one fel swoop when we fixed things up to remove
> potential DB keyword conflicts
>
> jesse
>
> On 4/23/07, Stephane Nicoll <stephane.nicoll@gmail.com> wrote:
>> Can I be sure at least that the DB model won't change as from  
>> alpha-1?
>> If so I can maybe drop completely my database and recreate my
>> projects.
>>
>> Thanks,
>> St├ęphane
>>
>> On 4/23/07, Brett Porter <brett@apache.org> wrote:
>> > This was one of the things I was going to try and have done before
>> > alpha-1 - I just forgot.
>> >
>> > Erik - the problem in upgrading is the changes in private tables
>> > between versions of jpox that we hadn't given explicit names to.  
>> We'd
>> > probably appreciate most help in future proofing our jpox use a bit
>> > more in case it's internal schema changes again.
>> >
>> > I already have the tools to do an xml export of the old tables, it
>> > just needs to somehow be set to run in dump mode using the old  
>> jpox,
>> > and import using the new one. I'll look at that during ApacheCon, I
>> > think. If anyone else wants to take the task while I'm on holidays,
>> > let me know... we should also make the tool work with 1.0.3  
>> databases
>> > if possible.
>> >
>> > This is definitely one for the release notes, btw. alpha-1 will not
>> > work with 1.0.3 (or earlier 1.1 snapshot) databases.
>> >
>> > - Brett
>> >
>> > On 22/04/2007, at 2:10 PM, Erik Bengtson wrote:
>> >
>> > > If you guys need some tooling from JPOX, let me know and I could
>> > > plan to
>> > > implement some kind of "export" to XML, and "import" from XML. In
>> > > between
>> > > export/import you could apply Xqueries to transform data to match
>> > > the new
>> > > schema
>> > >
>> > > Quoting Stephane Nicoll <stephane.nicoll@gmail.com>:
>> > >
>> > >> Hi,
>> > >>
>> > >> I'm currently running a 1.1-SNAPSHOT from February which runs ok
>> > >> except a few minor issues. I'd like to upgrade to 1.1 alpha 1  
>> as soon
>> > >> as it's out to provide feedback & co.
>> > >>
>> > >> Last time I tried to upgrade, I had to revert because the model
>> > >> schema
>> > >> has changed and it was really difficult to update my existing
>> > >> data. Is
>> > >> there something scheduled for alpha1 regarding this (at least a
>> > >> manual
>> > >> procedure to upgrade my schema if necessary).
>> > >>
>> > >> Thanks,
>> > >> St├ęphane
>> > >>
>> > >
>> > >
>> >
>>
>
>
> -- 
> jesse mcconnell
> jesse.mcconnell@gmail.com

Mime
View raw message