vaibhavst

 Profile Answers by vaibhavst Questions by vaibhavst

• Mar 23rd, 2010

 

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

nicel007

 Profile Answers by nicel007 

• 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.



Rgds,
Nic