Main problem I can think of is not migrating all the data accurately (e.g. not migrating data to the right place in the new database, or losing data in the migration process).
Other possible problems I can think of: eliminating redundant data (e.g. identifying and resolving duplicates); that there is no use of the database while the migration takes place, and data glitches.
I would be very grateful if anyone could add to this