SQL Data Compare to move data between replicated tables

Compares and synchronizes SQL database content.

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

SQL Data Compare to move data between replicated tables

Postby CQuill » Tue Aug 06, 2013 3:06 pm

We have several tables that are replicated between two databases.

When it is necessary to make data changes, we update the data in our staging database.

Once that data has been verified, we use SQL Data Compare 10 to move the data to the production database.

Since tables in both databases are replicated, and the primary key is auto generated, SQL Data Compare drops the constraints before moving the data to keep the values the same.

Will this cause an issue with the replication jobs?

Thanks.
CQuill
 
Posts: 1
Joined: Tue Aug 06, 2013 2:24 pm

Postby eddie davis » Wed Aug 07, 2013 3:38 pm

Hi, thank you for your forum post.

I am unsure what will occur with your replication jobs when deploy the changes to the target database. From the limited experience with database replication, I suspect that something will go wrong.

SQL Data Compare will not drop the primary key constraint if it is the Comparison key used for the comparison of the data, even if you have the option to Drop primary keys, Indexes and unique constraints enabled.

I recommend if you have a test environment with replication configured, that you perform some tests to see what will occur with your replication jobs.

Also backup the target database before running the deployment wizard against the target database, so you can recover the database if something does go wrong with the deployment causing a loss of data.

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