Solved

How to import differential values from tables

Posted on 2010-08-24
2
347 Views
Last Modified: 2012-08-13
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
Comment
Question by:negreteo
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 33511645
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
 
LVL 9

Expert Comment

by:sas13
ID: 33511679
you can use "SQL Server Import and Export Wizard"
select "Source", "Destination" and tables for copy data
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question