Red Gate forums :: View topic - Order of tables in compare script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Order of tables in compare script

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Johnnyrshep



Joined: 19 Jul 2012
Posts: 1

PostPosted: Thu Jul 19, 2012 4:31 pm    Post subject: Order of tables in compare script Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group