Automate and integrate using the SQL comparison API
Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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?
- 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