Toad World® Forums

Scripting an entire database


#1

There was a posting in the TOAD_SS group about scripting all of the tables,
indexes, foreign keys for a database that I think could be addressed in v5.

The issue is when Toad generates a script it does so in alphabetical order which
causes the foreign key creations to fail when a dependency exists on a table
coming later in the alphabet. It would be cool if Toad worked the same way as
SSMS in this case, i.e. generate all drops, triggers, foreign keys, then tables.
Then generate all table creates (including indexes), then generate all foreign
keys and triggers.

Is that something that can be looked at?