How to test data base of a appliacation Migrated from SQL SERVER 2000 to SQL SERVER 2008
Hi Frnds, Development team had migrated my application database from SQL SERVER 2000 to SQL SERVER 2008. Can any1 suggest me what are the basic and imp points to be tested and how this to be tested. Kindly suggest as this 1st time for me to come across this situation.
From the database side of things, there's not much you need to do. After the upgrade make sure you change the [compatibility level]. Make sure you run a consistency check (DBCC CHECKDB). I would also suggest updating the statistics on all the tables. It'll happen automatically anyway, but not reason not to take care of it right away. That's about it. But, the application also will need to be tested because the drivers are all different for 2008. Depending on how the app was built you could see errors. :