Migrating stored procedures from SQL Server 2000 to 2005
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures
after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 3, 2011 4:06 PM
UPDATED:
January 3, 2011 6:36 PM
RELATED QUESTIONS
- Migrating stored procedures from SQL Server 2000 compatibility mode to a SQL Server 2005 database
- How do I move all stored procedures to a new SQL server?
- Changes in stored procedures from SQL Server 2000 to SQL Server 2005
- How to migrate a database from SQL Server 2000 to SQL Server 2005
- Migrating SQL Server 2005 back to SQL Server 2000
Answer Wiki:
How did you migrate them? Did you upgrade the database by restoring it from the old server to the server? Did you upgrade the old server to SQL 2005? Did you attach the database to a new machine running SQL 2005?
In all these cases the stored procedures are written exactly how they were when they were in the old system. The only task that must be performed after upgrading is that the statistics must be updated manually on the server as the SQL Server 2005 database engine can't use the SQL Server 2000 statistics.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
