When creating a data script, if the Disable Contraints option is set to True, the only constraints that are dropped and recreated are primary key constraints and indexes. Missing are foreign key constraints and data check constraints. This can cause the following error to occur when running the script.
"The INSERT statement conflicted with the FOREIGN KEY constraint..."
WORKAROUND:
Edit the data script manually to drop or disable the foreign key before inserts statements are run and then re-create or enable it after the insert statements are run.
STATUS:
Waiting for a fix to be released in a future version of Toad for SQL Server.
