id="info"

Question

Locked

Code Changes while migrating sql server 2000 to 2005

By skurulkar ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Use SQL Server 2005 Upgrade Advisor

by lalit.k.bhatia In reply to Code Changes while migrat ...

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

Collapse -

Changes

by chapman.tim In reply to Code Changes while migrat ...

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.

Back to Networks Forum
3 total posts (Page 1 of 1)  

Hardware Forums