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

How to compare tables that are having data inserted during comparison

Hello. I have the following problem. To synchronize data from server S1 to server S2. I need to synchronize tables A and B both at the same time.

Table B has foreign key to table A. (table A contains the primary key value). After SQL Data Compare finishes reading one table and while it reads the second table, there are already some new data inserted to the first table. And the synchronization fails on foreign key constraint. How can I solve this?


Sign In or Register to comment.