• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

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?

0
negreteo
Asked:
negreteo
1 Solution
 
Raja Jegan RSQL 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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now