Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » migrating CDO data from old to new schema
migrating CDO data from old to new schema [message #30891] Tue, 11 April 2006 20:49 Go to next message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
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 20:14 Go to previous messageGo to next message
Eclipse UserFriend
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 #31100 is a reply to message #31030] Wed, 12 April 2006 20:28 Go to previous messageGo to next message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
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 #31305 is a reply to message #31100] Thu, 13 April 2006 13:49 Go to previous messageGo to next message
Eclipse UserFriend
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 #31334 is a reply to message #31305] Thu, 13 April 2006 16:44 Go to previous messageGo to next message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
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 #31597 is a reply to message #31334] Thu, 13 April 2006 22:43 Go to previous messageGo to next message
Eclipse UserFriend
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 #32334 is a reply to message #31597] Thu, 20 April 2006 21:22 Go to previous messageGo to next message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
Eike,

This worked just great. With help from Ed I completed this step this
morning.

I now have all my data in the new CDO database ready for testing.

Mark.
Re: migrating CDO data from old to new schema [message #32716 is a reply to message #32334] Sat, 22 April 2006 12:55 Go to previous message
Eclipse UserFriend
Originally posted by: stepper.sympedia.com

Mark,

That sounds great!
Aside from your performance issues that you reported in the other thread,
does it work with the generic example UI (CDO Explorer View, CDO Editor)?

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 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
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 20:28 Go to previous message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
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 13:49 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
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 16:44 Go to previous message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
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 22:43 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
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 #575767 is a reply to message #31597] Thu, 20 April 2006 21:22 Go to previous message
Mark Geib is currently offline Mark GeibFriend
Messages: 432
Registered: July 2009
Senior Member
Eike,

This worked just great. With help from Ed I completed this step this
morning.

I now have all my data in the new CDO database ready for testing.

Mark.
Re: migrating CDO data from old to new schema [message #576114 is a reply to message #32334] Sat, 22 April 2006 12:55 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
Mark,

That sounds great!
Aside from your performance issues that you reported in the other thread,
does it work with the generic example UI (CDO Explorer View, CDO Editor)?

Cheers
/Eike


Previous Topic:best approach integrating emft ocl?
Next Topic:[Announce] EMFT OCL 1.0.0 I200604270931 is available
Goto Forum:
  


Current Time: Fri Apr 26 00:33:23 GMT 2024

Powered by FUDForum. Page generated in 0.03961 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top