Ben
Ben

Reputation: 6907

Get extract of Sybase data as INSERT statements, with order considering table dependencies

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

Answers (1)

David Atkinson
David Atkinson

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

Related Questions