SUGGESTION: Order inserts on self referencing tables

paulo_morgadopaulo_morgado Posts: 97 Silver 2
edited February 25, 2010 1:00PM in SQL Data Compare Previous Versions
If the project definition doesn't have disable foreign keys checked (probably because the user executing the script doesn't have permission), SQL Data Compare should order the inserts in order to have referenced rows inserted before referencing rows.

If a circular reference is detected, an warning should be issued and the normal script should be generated.
Paulo Morgado
Portugal
Web Site
Weblog
Twitter
· Share on Twitter

Comments

Sign In or Register to comment.