Reputation: 6907
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 am using Sybase ASE
Any advice would be appreciated.
Upvotes: 0
Views: 957
Reputation: 5909
Here at Redgate we don't often get Sybase requests and there are few vendors who produce tools for this market. You could try DBBest, who specialize in breadth of RDBMS support.
Upvotes: 1