How to import differential values from tables

Hi,

 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?

negreteoAsked:
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(http://www.red-gate.com/products/SQL_Compare/)

If you want Data level changes, then

* Red Gate SQL Data Compare (http://www.red-gate.com/products/SQL_Data_Compare/index.htm)
0
 
sas13Commented:
you can use "SQL Server Import and Export Wizard"
select "Source", "Destination" and tables for copy data
0
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.