Question Locked

Code Changes while migrating sql server 2000 to 2005

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by lalit.k.bhatia

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

by Member 22070467

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.

This discussion is closed to new replies.