Migrating data between dev database and live database

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Migrating data between dev database and live database

Postby shat » Mon Mar 25, 2013 5:39 pm

I currently have two database servers, production and development.

The development database server has a specific database that I modify both schema design (for tables) as well as some data.

I would like to compare the data between the two tables, between the two servers as well as any design differences.

Is it possible to do so with SQL Data Compare or SQL Compare? I have the developers bundle and license.

There are only a few new rows that I know I need to copy from development -> production.
shat
 
Posts: 1
Joined: Mon Mar 25, 2013 5:37 pm
Location: Tulsa, Oklahoma

Postby eddie davis » Tue Mar 26, 2013 11:42 am

Hi shat,
thank you for your forum post.

In the scenario you have described in your post, you will need to use SQL Compare and SQL Data Compare. Unfortunately there is not a single tool that does both.

Using SQL Compare will you be able to compare and deploy any design differences. Followed by SQL Data Compare to compare, select the required rows of data and deploy the selected data between the development and production databases.

Further help on using SQL Compare and SQL Data Compare can be found in the help articles on following web pages:

SQL Compare - http://www.red-gate.com/supportcenter/P ... %20Compare

SQL Data Compare - http://www.red-gate.com/supportcenter/P ... %20Compare

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests