ScottMattes
Member³
I had reason to use this today and while it worked quite good (99+% no problems when I ran the output in a new DB)...
If all statements that reference a table other than the one just created (like Foreign Keys for instance) were done after all create tables, then the four cases that I ran into where the referenced table didn't exist wouldn't have been a problem.
I just reviewed the log and for each error just reran that command and all was good.
Maybe it would speed up the process of making the Export, since the code wouldn't have to try analyzing for dependencies.
If all statements that reference a table other than the one just created (like Foreign Keys for instance) were done after all create tables, then the four cases that I ran into where the referenced table didn't exist wouldn't have been a problem.
I just reviewed the log and for each error just reran that command and all was good.
Maybe it would speed up the process of making the Export, since the code wouldn't have to try analyzing for dependencies.