|
Re: migrating CDO data from old to new schema [message #31030 is a reply to message #30891] |
Wed, 12 April 2006 20:14 |
Eclipse User |
|
|
|
Originally posted by: stepper.sympedia.de
hi mark,
sorry, since i'm working in switzerland, my inet capabilities (and my
time) is quite limited ;-(
regarding data migration, i think you don't need one, do you?
did you try with your existing db?
in case there are issues, what happens?
cheers
/eike geib wrote:
> Eike,
>
> I have been able to get the code migrated from the old CDO to the new
> that is from emft. Now I am starting to look at migrating all of the
> existing data from the current database, old CDO, to the new CDO.
>
> It looks like a lot has changed in the database schema. I see a couple
> of new CDO_XX tables, and changes to some of the others.
>
> How do I proceed here.?
>
> Thanks,
> Mark.
>
|
|
|
|
Re: migrating CDO data from old to new schema [message #31305 is a reply to message #31100] |
Thu, 13 April 2006 13:49 |
Eclipse User |
|
|
|
Originally posted by: stepper.sympedia.com
Mark,
Gosh! I start to remember that the version you've been using is really
old. In fact there have been changes during the later introduction of the
PackageManagers. Clients and server now have different ones. Formerly
there was a shared implementation of a ModelManager which forced you to
deploy the generated models to the server. This is no longer possible.
Instead the model structure is transferred over the net and managed by a
server side PackageManager by writing it into the database.
Nevertheless I still can't remember any changes in the format of instance
data. Ok, I could be wrong... What about the CDO_RESOURCES table? Did you
already have that one?
I'd suggest that you try to commit some resources so that all your models
are affected and transferred to the server. Best case scenario is that you
can simply import your old instance data afterwards.
If that doesn't work w'll have to think again.
Cheers
/Eike
|
|
|
|
Re: migrating CDO data from old to new schema [message #31597 is a reply to message #31334] |
Thu, 13 April 2006 22:43 |
Eclipse User |
|
|
|
Originally posted by: stepper.sympedia.de
geib wrote:
> Eike,
>
> I was wondering if another approach would be simplier, and less error
> prone.
>
> What about creating a copy of the entire CDO resource to an XMI
> resource. Then using the new CDO do the opposite, load and copy the XMI
> resource into a new CDO resource.? This is sort of like an export/import
> with a two step process.
Hey, that sounds like a good idea, too!
I've never tried that before, but I can't imagine any reasons against it
at the moment. The effort seems low, so why not try it?!
Cheers
/Eike
|
|
|
|
|
Re: migrating CDO data from old to new schema [message #574333 is a reply to message #30891] |
Wed, 12 April 2006 20:14 |
|
hi mark,
sorry, since i'm working in switzerland, my inet capabilities (and my
time) is quite limited ;-(
regarding data migration, i think you don't need one, do you?
did you try with your existing db?
in case there are issues, what happens?
cheers
/eike geib wrote:
> Eike,
>
> I have been able to get the code migrated from the old CDO to the new
> that is from emft. Now I am starting to look at migrating all of the
> existing data from the current database, old CDO, to the new CDO.
>
> It looks like a lot has changed in the database schema. I see a couple
> of new CDO_XX tables, and changes to some of the others.
>
> How do I proceed here.?
>
> Thanks,
> Mark.
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
|
Re: migrating CDO data from old to new schema [message #574622 is a reply to message #31100] |
Thu, 13 April 2006 13:49 |
|
Mark,
Gosh! I start to remember that the version you've been using is really
old. In fact there have been changes during the later introduction of the
PackageManagers. Clients and server now have different ones. Formerly
there was a shared implementation of a ModelManager which forced you to
deploy the generated models to the server. This is no longer possible.
Instead the model structure is transferred over the net and managed by a
server side PackageManager by writing it into the database.
Nevertheless I still can't remember any changes in the format of instance
data. Ok, I could be wrong... What about the CDO_RESOURCES table? Did you
already have that one?
I'd suggest that you try to commit some resources so that all your models
are affected and transferred to the server. Best case scenario is that you
can simply import your old instance data afterwards.
If that doesn't work w'll have to think again.
Cheers
/Eike
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03961 seconds