I have a database in 3rd normalized form and want to export data and import it in a copy of that database. Is there a way for the import/export wizard to unload and reload the data in the right order, so that parent tables are loaded before child tables? If the import export wizard can't do that, what other options are available?
Drop constraints and then do what you want, then when you're done, re-enable the constraints. Probably better script the constraints to file, then after you drop, you can just run the script you just created.