Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Transfer entities between entitymanagers
Transfer entities between entitymanagers [message #666327] Tue, 19 April 2011 18:01 Go to next message
No real name is currently offline No real name
Messages: 1
Registered: April 2011
Junior Member
Hi,

in a currently running project we want to change your database product.

How could we transfer all data from database A to database B?

What problems could we meet?

Report message to a moderator

Re: Transfer entities between entitymanagers [message #666664 is a reply to message #666327] Thu, 21 April 2011 09:41 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1834
Registered: July 2009
Senior Member
If it is a small database, you could just read everything from one persistence unit mapped to the one db, and write to the other.

One issue would be Id generation, if you are generating the Ids, you must ensure the Id generators are updated to the last used Id.

If your database is very big, then you may wish to use more direct means, such as import/export tools, or direct migration scripts.

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:IndirectSet triggers raiseAddChangeEvent even when no element was added
Next Topic:JPA query with hierarchy
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 16:22:07 EDT 2013

Powered by FUDForum. Page generated in 0.01481 seconds