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?
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: 1939
Registered: July 2009
Location: Ottawa, Canada
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 : Twitter
Previous Topic:IndirectSet triggers raiseAddChangeEvent even when no element was added
Next Topic:JPA query with hierarchy
Goto Forum:
  


Current Time: Wed Aug 20 08:51:06 EDT 2014

Powered by FUDForum. Page generated in 0.01559 seconds