Red Gate forums :: View topic - SQL Data Compare to move data between replicated tables
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

SQL Data Compare to move data between replicated tables

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
CQuill



Joined: 06 Aug 2013
Posts: 1

PostPosted: Tue Aug 06, 2013 3:06 pm    Post subject: SQL Data Compare to move data between replicated tables Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 938
Location: Red Gate Software

PostPosted: Wed Aug 07, 2013 3:38 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group