Jim,
Maybe you should be a little more specific :)
In general looks like you have a migration, but also looks like you have some constraints that are in place in addition to a standard migration.
In general you need to create a mapping table for every id you migrate and then if you have to assign a new id after the migration, you need to then go into the mapping table and update every referece to the old id with the new id.
In addition you might have write a redirect to map old urls ot new urls if the ids were part of a url, and you need to preserve them.
