Use CDC to migrate bothersome tables. Tom Bascom created an excellent presentation on a Change Data Capture (CDC) based dump and load. Have a look. Have a look at the presentation on the PUG site: CDC Based Dump & Load