What are the challenges you face when working across database platforms? Take the survey
Options

Migrating data between dev database and live database

shatshat Posts: 2
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.

Comments

Sign In or Register to comment.