How to import differential values from tables


 I have two databases with the same DB strucuture and names and I need to import only the values that are different from one server without deleting the other values from my original tables, databases are in different servers.

How can I accomplish this?

Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
If you want to sync DDL changes( Structural Changes), then you can use

* Red Gate SQL Compare(

If you want Data level changes, then

* Red Gate SQL Data Compare (
you can use "SQL Server Import and Export Wizard"
select "Source", "Destination" and tables for copy data
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.