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?