How to merge two Sybase databases into one in a case where a business has acquired another
Posted on 2008-11-02
I am stuck with a difficult task. I work for a company that uses an IP Management program with a back end database called Sybase 12.2 ASE.
Both companies use this program but both contain information of their own.
My task is to somehow get Company A's data into company B's database.
Are there any tools or a way to achieve this?
I assume I will have an issue with duplicate primary keys. If that is the case, will this be a show stopper?
Also, is there a sql command that I can run to compare all the data from Company A to Company B to identify if there will be any record conflicts? If so, how?
Mind you, I am not a DBA expert at all, I was just given this task and I want to prove myself and secure my position better.
Any help would be grateful