Migrating data between dev database and live database

shat

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.

Eddie D

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