July 28, 2010 at 10:49 am
We are currently preparing to upgrade our SQL Server 2000 databases to SQL Server 2008. I know there are the following two items which need to be changed on the programming side as part of the upgrade
1. Remove ORDER BY clause in Views.
2. Remove query hints from stored procedures.
But is there anything else? We want to do a backup/restore upgrade, but also want to ensure that all queries worked as they had before.
Thanks!
Michael
July 28, 2010 at 11:09 am
Download and run this against your 2000 server:
There really is no better way to get a quick summary of potential problems in the upgrade.
July 28, 2010 at 11:19 am
As Jeff has said the upgrade advisor will assist you in identifying what changes you need to make before and after an upgrade.
Gethyn Elliswww.gethynellis.com
July 28, 2010 at 2:01 pm
Are you planning on running in 80 compatibility mode? Or upgrading to 10?
July 28, 2010 at 2:11 pm
Also watch out for the *= shorthand for LEFT OUTER JOIN. That has also been depricated.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply