Home » Developer & Programmer » Designer » merging Databases on Oracle Design Editor
merging Databases on Oracle Design Editor [message #327171] Sat, 14 June 2008 08:21
Messages: 70
Registered: October 2007
Location: lebanon

hello guys,

i want to merge two big databaese in one massive one.
my issue is that i use Oracle Design Editor to generate scripts about everything. the problem isnt physically merging the DBs on the new server, its merging the Oracle Design Editor of both DBs.
the Oracle Design Editor has no tool to copy data from one DB to another.

i researched and did some thinking i reached two possible solutions:
1)either merge them by hand on the Oracle Design Editor then run scripts on the new server, which is easy but takes alot of time to add one DB to another on the Oracle Design Editor.
2)to generate scripts for each DB from the Oracle Design Editor and run them on the new server, then if its possible to reverse engineer to the Oracle Design Editor.

but i dont know how to do choice two, and i want to ask if someone knows, incase it will reverse engineer the users created as well.

Thank you for your help guys.
Previous Topic: Reverse Engineering using Oracle Designer
Next Topic: one to one relatioship
Goto Forum:

Current Time: Wed Dec 08 20:00:11 CST 2021