[PaulHoule]

It is an old debate. You can get into awkward situations when you save and restore tables, everything has to happen in the right order and there's always the fear of some circular situation.

I'm remembering the time I was working at a place that had a huge number of Microsoft Access, Microsoft SQL Server and mysql databases and I was the first person they'd hired who knew how to do joins and they thought it was pretty scary.

[sergiosgc]

That's not how you migrate. You disable the foreign keys, load the data, then enable them (which checks everything is ok).