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

Order of tables in compare script

We have been running into a number of problems with the scripts created for the data comparison. What we have found is that a few of the insert record scripts are being run before the relevant tables with the referenced primary keys and foreign keys are run.

This then generates an error below.

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_table_2". The conflict occurred in database "Database", table "dbo.tbl_table_1", column 'column_name'.

Is there any what is which this can be solved easily?
Sign In or Register to comment.