Can you please let me know what all key changes required in stored procedure / functions while migrating project from 2000 to 2005 instance.
Thanks
Sujay
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Code Changes while migrating sql server 2000 to 2005
Updated - 18th Jun 2007
Answers (2)
0
Votes
Use SQL Server 2005 Upgrade Advisor
Use Microsoft SQL Server 2005 Upgrade Advisor tool to check compatibility of your database with 2005.
It will show areas that need to be changed as part of upgrade
It will show areas that need to be changed as part of upgrade
19th Jun 2007
0
Votes
Changes
You shouldn't have to incur any procedure changes to allow the upgrade to 2005. The only changes you will incur is when you try to take advantage of the new features.
19th Jun 2007
