| migrating CDO data from old to new schema [message #30891] |
Tue, 11 April 2006 16:49  |
Eclipse User |
|
|
|
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 #31030 is a reply to message #30891] |
Wed, 12 April 2006 16: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 #574333 is a reply to message #30891] |
Wed, 12 April 2006 16:14 |
| Eclipse User |
|
|
|
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 #574401 is a reply to message #31030] |
Wed, 12 April 2006 16:28 |
| Eclipse User |
|
|
|
Eike,
I have tried it, I don't have the errors to give you now.
But I quickly looked at the two schemas and there are changes.
Specifically the CDO_CLASS table has new columns, and there is a
completely new table CDO_ATTRIBUTES I think.
Mark.
|
|
|
| Re: migrating CDO data from old to new schema [message #574622 is a reply to message #31100] |
Thu, 13 April 2006 09:49 |
| Eclipse User |
|
|
|
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 #574650 is a reply to message #31305] |
Thu, 13 April 2006 12:44 |
| Eclipse User |
|
|
|
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.
What do you think.?
Mark.
|
|
|
| Re: migrating CDO data from old to new schema [message #574939 is a reply to message #31334] |
Thu, 13 April 2006 18:43 |
| Eclipse User |
|
|
|
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
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03706 seconds
Home