One of the main reasons I purchased TOAD for SQL Server was for its script generation capability. I need to generate SQL scripts that can rebuild the database in its entirety for our installation program.
However, I have discovered that when generating a DDL script that includes everything, including foreign keys, the tables are created in alphabetical order, which makes the script unusable since tables that the keys are dependent on may not have been created yet.
I had hoped to work around this by generating a DDL script that created everything except the foreign keys, and then another DDL script with just the foreign keys. However, I cannot find an option to generate the keys only – it always wants to create the tables!
Does anyone know if TOAD offers a way to create usable DDL scripts that includes being able to rebuild everything correctly, including foreign keys?