Order of tables in compare script

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Order of tables in compare script

Postby Johnnyrshep » Thu Jul 19, 2012 4:31 pm

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?
Johnnyrshep
 
Posts: 1
Joined: Thu Jul 19, 2012 4:26 pm

Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests