patwarimk
SSC Journeyman
Points: 76
More actions
February 23, 2010 at 10:23 am
#219434
Hello,
Iam new to database testing and We are migrating database from SQL 2000 to SQL 2008 . Please any one can give me the information what we need to test while migrating SQL 2000 to SQL 2008 in testing aspect.
Thanks!
Vinay Thankur
SSCarpal Tunnel
Points: 4178
February 23, 2010 at 11:33 am
#1123784
Please check.
http://blogs.msdn.com/chkoenig/archive/2008/12/01/upgrading-from-sql-2000-2005-to-2008.aspx
also video:
HTH
Vinay
Thanx.Vinay
http://rdbmsexperts.com/Blogs/http://vinay-thakur.spaces.live.com/http://twitter.com/ThakurVinay
Steve Jones - SSC Editor
SSC Guru
Points: 736468
February 23, 2010 at 4:05 pm
#1123955
Run the upgrade advisor to see what pops up.
I would also run a profiler trace of a test upgrade and look for deprecated code. There's an event for that. (http://www.mssqltips.com/tip.asp?tip=1370)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply