You are viewing a plain text version of this content. The canonical link for it is here.

Posted to server-user@james.apache.org by Thomas UNG <th...@gmail.com> on 2011/10/23 13:59:48 UTC

james3 migration from m2 to m3

Hi,

I am trying to match db tables and fields between james2m2 and james3m3
schema to do the migration.

there is a new field in table "JAMES_MAILBOX"

  `MAILBOX_HIGHEST_MODSEQ` bigint(20) NOT NULL

what should I put for the existing records ?

Many thanks in advance !
Thomas

Re: james3 migration from m2 to m3

Posted by Thomas UNG <th...@gmail.com>.

Thank you Patrick for these precious information !

Thomas

2011/10/24 Patrick Pyette <pp...@perimind.com>

> Hi Thomas,
>
> You might want to look at [1].   I used this process successfully to
> migrate from one beta to another where the schema had changed and JPA
> couldn't automagically update it.
>
> Cheers,
> Pat
>
> [1]
> https://svn.apache.org/repos/asf/james/server/trunk/src/site/xdoc/upgrade-database.xml
>
> On 2011-10-23, at 7:59 AM, Thomas UNG wrote:
>
> > Hi,
> >
> > I am trying to match db tables and fields between james2m2 and james3m3
> > schema to do the migration.
> >
> > there is a new field in table "JAMES_MAILBOX"
> >
> >  `MAILBOX_HIGHEST_MODSEQ` bigint(20) NOT NULL
> >
> > what should I put for the existing records ?
> >
> > Many thanks in advance !
> > Thomas
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>

Re: james3 migration from m2 to m3

Posted by Patrick Pyette <pp...@perimind.com>.

Hi Thomas,

You might want to look at [1].   I used this process successfully to migrate from one beta to another where the schema had changed and JPA couldn't automagically update it.

Cheers,
Pat 

[1] https://svn.apache.org/repos/asf/james/server/trunk/src/site/xdoc/upgrade-database.xml

On 2011-10-23, at 7:59 AM, Thomas UNG wrote:

> Hi,
> 
> I am trying to match db tables and fields between james2m2 and james3m3
> schema to do the migration.
> 
> there is a new field in table "JAMES_MAILBOX"
> 
>  `MAILBOX_HIGHEST_MODSEQ` bigint(20) NOT NULL
> 
> what should I put for the existing records ?
> 
> Many thanks in advance !
> Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org