The first thing tester should do when migration happens is, to be aware of all the changes done in the new SQL server followed by creating a test case suite by considering the below points-

  • Which data type is used?
  • What is the length of the fields?
  • If in the new SQL server, database objects created are as expected.
  • On the new SQL server, stress testing should be performed to identify the risks related to the migrated environment.
BY Best Interview Question ON 10 Jan 2022