The “Disable constraints” option, for Generate SQL | Data Script, should be broken up into two options: “Disable foreign key constraints” and “Disable indexes”. Check constraints are irrelevant.
“Disable foreign key constraints” should drop all foreign key constraints. This would speed up the import for large databases, but it is also necessary for some situations where there is a circular foreign key constraint (two tables that reference each other) or where there is a self-referencing constraint (e.g. a “parent” field) and the order of the data export is not guaranteed.
“Disable indexes” should drop all primary key constraints and all indexes. This would speed up the import for large databases. Enabling this option should enable “Disable foreign key constraints” because if you try to drop a primary key that is referenced by a foreign key constraint the drop will fail.
Waiting for enhancement to be implemented in a future version of Toad for SQL Server.
