Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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.
- Posts: 1
- Joined: Mon Mar 25, 2013 5:37 pm
- Location: Tulsa, Oklahoma
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
- 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