5
Vote

INSERT ordering for in table FK

description

Hello,
 
First of all, thanks for the tool!!! Great help, especially for the Generate Data option!
 
Wanted to tell you about something I found while working with the Generate Data functionality. I have a table with a reference to itself (think Employees table with a ManagerEmployeeID column that has a FK reference to another row in the same table). When it generated the INSERT scripts for my data, I found there were several items that were out of place and resulted in FK constraint errors.
 
I worked around it. Just used Query Analyzer to located the problem lines, and moved them to the bottom of the INSERT section for that table.
 
Would be nice to get this resolved if possible, but not critical.

comments

hfrmobile wrote Jul 15, 2008 at 9:51 AM

Same problem and same workaround too ;-)
Would be really nice to get this solved.

ttajic wrote Jul 29, 2009 at 11:17 AM

Same problem....and it would be REALLY NICE to get this solved...but I imagine this is not trivial....figuring out all the relationships and stuff....

wrote Jan 20, 2010 at 8:49 PM

wrote Feb 14, 2013 at 8:30 PM