Merge two databases

nickdollingsnickdollings Posts: 2
Hi,

I have two SQL databases that have the same structure but different data, i wish to move data from database 1 to database 2 without losing the existing data in database 2, can this be done using data compare?

Thanks very much

Nick

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Nick,

    You can do this -- but it takes a bit of effort. You would need to de-select all of the 'missing' records (the records that exist in db1 but not in db2) to prevent the synchronization wizard from scripting DELETE queries for db2.

    If you have the 'professional' licence and can use the command-line tools, you can perform this operation automatically and 'atomically' using the /ignoremissing switch in the command.
Sign In or Register to comment.