How can we help you today? How can we help you today?

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?
Maci
0

Comments

1 comment

Sort by
  • Tianjiao_Li
    Can you take a backup of db1 from server S1 and then set the backup as source?
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.