How to compare tables that are having data inserted during comparison

Maci125

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?

Tianjiao_Li

Can you take a backup of db1 from server S1 and then set the backup as source?