@enter64 i don’t think it matters how ACF does it – you don’t need to copy the database structure over.
1. Set up the new fields for the custom post types
2. Loop through the old data you have stored
3. Create a new Post and remap that data
If you’re trying to just do a database migration, I think you’re over thinking the problem. Just remap, then delete the old data.
If you’re wanting to do this all via SQL, then I’ll have to defer to someone who has more expertise in that area.
