I would like to know, if there is a SQL database for the existing system.
Here I'm going to build a new one by changing the database structure of the old one. I need help building a script to migrate data.
Here is the Old Database Country Table Structure
Old database Country Table
Old database Province Table
New database Country Table
New database Province Table
I have already migrated Country data from the old one to the new one.
The issue is now I want to migrate the province details from the old table to the new table. Here IDs for the country consist of two different Id Ranges. And need to check the ID with the province and with the new table check the Country Id with the country name and get the new Id and save it to the province new table with the province data.
As far as I got this Idea and no idea of how to write this script. Any different ideas for doing this with scripts?