swwg69 (9/5/2013)
The hardest part for a non-trivial database is making sure the tables are built in the correct order to maintain RI. You can script out the table structures etc and build the new database, OK.You can set the flag to allow index insertion, but if a record references a a table that is still empty... 🙁
Actually when doing any kind of bulk load, you should drop the fk constraints, then load and finally add the constraints. You won't need to worry about parent/child relationships and the load will happen faster.