Combining two databases

Question

I have two different mssql databases with identical schemas, but different data on the same system. I want to combine data between two databases by adding data from one to the other.

I tried using Redgate Data Compare, but could not find any instructions on how to do this.

Are there any tools (or databases with built-in tools) or instructions to make this work simple enough?

Answer 1

xSQL Software has developed a set of tools for this type of database operation. You can use xSQL Data Compare . To achieve the result, you need to specify the left and right database, perform a comparison, and then to add the data that is missing to the left of db to the right db, you need to remove the synchronization for the correct rows and generate and execute the script command.

Here you can see that the lines are not marked:


And, as you can see, the script does not generate any DELETE statements, only INSERTS for rows that are not in the right DB


Hope this helps!

Disclosure: I am associated with xSQL software