I need help in migrating data from legacy database to the new database using MapForce. (Both databases are in MSSQL)
I am a student and I have pretty good knowledge of databases but bad at other languages.
Scenario
I have a CUSTOMER table in legacy database (We are still using legacy system) and a CLIENT table the new database (Which we need to populate before going live with new system)
I have already mapped fields between these two tables in MapForce and I have generated C# script.
Question
What to do next ? to make it work and migrate data from Database-1 to Database-2 between those tables?
How to do it periodically or only few records at t time so it won't affect the performance?
Will it also pick up the changes once the records are copied across ?
What I want to Achieve
I want to copy records from the "CUSTOMER" table from legacy system to the "CLIENT" Table in new system.
I also want the MapForce to re-copy them again if there are any changes in legacy records.