I want to create a SQL script to populate a DEV database using INSERT statements. (Preferably using INSERT statements, rather than binary form, so that I can safely check-in the script to version control).
I can easily extract the INSERT statements using various tools. But I haven't found a way to extract the INSERT statements in an order so that when run, FK constraints will not be violated.
I've used SQL Server tools which accomplish this. e.g. RedGate. But cannot seem to find a Sybase compatible method. I'd like a way to write the code to extract the T-SQL statements in the correct order to properly support relational integrity.
