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?