sql server - Data Migration Reconcilliation and validation using T-SQL

Question

I am an intern where I was affected to working on a Database migration project.

Basically we need to create stored procedures to map between old and new tables. Also there is the next step of creating stored procedures for reconciliation and validation to check the correctness of the SP before the changes will be committed to the final database.

The concept of reconciliation and validation is very new to me. I would love it if someone could explain them to me. What is there role? Why do we need them? And how the SP of reconciliation and validation should be? Is there any website where I can find examples of SP used for reconciliation and validation for migration tests?

By the way, the project is using T-SQL, it would be preferable if the examples are provided in T-SQL (If there is none it will be okay for me, I will deduct the used logic from it).

Thank you in advance.

question from:https://stackoverflow.com/questions/65915594/data-migration-reconcilliation-and-validation-using-t-sql

Answer 1

Waitting for answers