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 22:01 Go to next message
No real name is currently offline No real nameFriend
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 13:41 Go to previous message
James Sutherland is currently offline James SutherlandFriend
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: Sat Dec 20 14:35:53 GMT 2014

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

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