Database Migration Test Scenario

What are the test scenarios to test a database migrated from SQL Server 2005 to SQL Server 2008

Questions by bharathi.peddibhotla

Showing Answers 1 - 2 of 2 Answers

We need to check out what was all the enhancement the SQL Server 2008 has in it.  We need to design our testcase considering the following points.

1.      Data type used
2.      Length of the data field it should be same as it was in SQL 2005
3.      All the jobs should be scheduled properly


  • Mar 4th, 2011

1. No of tables in both old and new should be same
2. Table structures in both old and new should be same.
3. If it's a Data nmigration to , then ned to compare the no of records in all the tables in both old and target
4. Query perfomance 
    For eg :-
                Take 10 time taking queries from old Db and fire the same in New, and check it's perfomance in New
5. All the jobs ned to be completed within the defined SLA

Other than the above
    Connectivity, Firewal part also be included if those are comming under the scope.


Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions