question

imran27 avatar image
imran27 asked

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.
test-data
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This site runs off of votes. Please mark all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
From the database side of things, there's not much you need to do. After the upgrade make sure you change the [compatibility level][1]. 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. [1]: http://technet.microsoft.com/en-us/library/bb510680(v=sql.105).aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wilfred van Dijk avatar image
Wilfred van Dijk answered
Always run a DBCC UPDATEUSAGE('{databasename}') if you upgrade a SQL 2000 database. This fixes some inconsistency (inaccuracy) in SQL 2000. This issue if fixed in later releases What's changed in SQL 2008? see: http://msdn.microsoft.com/en-us/library/ms143532.aspx and dig your code... You can also run a trace to discover deprecated code: http://www.mssqltips.com/sqlservertip/2334/identify-deprecated-sql-server-code-with-a-server-side-trace/
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hopefully they checked for deprecated code prior to the upgrade, but I should have mentioned that.
0 Likes 0 ·
Venkataraman avatar image
Venkataraman answered
You can run upgrade advisor against SQL Server 2000 database to see whether any issues will be coming after migration. Refer to http://technet.microsoft.com/en-us/library/ms144256(v=sql.100).aspx on leveraging upgrade advisor for SQL Server 2008
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.