September 10, 2008 at 8:05 am
I have a situation where I need to combine two companies' dbs. They both started out from the manufacturer as vanilla - 2 identical instances, except for different company data. As time moved on, company A performed customizations to the application, which made changes to the db tables. Company B made their own customizations, resulting in db changes as well. Aside from actual data, I would say that both dbs are 90% vanilla today. But the 10% is a different 10% for each db. In other words, the 10% change in Company A does not look like the 10% change in Company B.
Because of application licensing fees, management wants the 2 companies merged, which means merging the dbs. My question to this forum: is there a script, procedure or even a 3rd party application that will merge these two dbs without losing any data or schema differences?
Thanks in advance.
September 10, 2008 at 8:16 am
ApexSQL Diff - http://www.apexsql.com/sql_tools_diff.asp
I would assume that merging data will still get you a certain amount of efforts though...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply