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?
0 · Share on Twitter