Re: Merging two database together
AssetID -- are there duplicate values between the two sources? If so, you will have to write a program to deal with it.
MyISAM ignores FOREIGN KEY CONSTRAINTs; you have no explicit constraints anyway.
I have never heard of SQLDUMP; can you explain how it works? Does it produce INSERT statements, like mysqldump does? Or does it work some other way?
In the best of worlds, your dump is a collection of INSERT statements, and none of the values of AssetID are the same between the two sources. Then simply feeding the dump to mysql will work fine. Otherwise, it could be problematic.
Subject
Views
Written By
Posted
12221
May 05, 2011 10:20AM
4203
May 07, 2011 11:46PM
3192
May 09, 2011 02:47AM
Re: Merging two database together
2966
May 09, 2011 07:32AM
2589
May 10, 2011 02:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.