Can you just disable/defer foreign key constraints and insert everything in a single pass? It seems to me that if you just blat the contents of each table straight from source to destination you'll be good to go. The only reason I can think that this won't work is if you're changing entity IDs during the data migration.