About SQL Server 7.0 upgrade to 2005

There is a system running in win NT with DB SQL server 7.0, and now want to upgrade DB SQL server 7.0 to 2005 and run at window server 2003.

I want to konw that is there any impact to the system at DB part ? all the original script can be run normal when DB upgraded to 2005?

Moved to more appropriate forum.|||

Leopardxp wrote:

There is a system running in win NT with DB SQL server 7.0, and now want to upgrade DB SQL server 7.0 to 2005 and run at window server 2003.

I want to konw that is there any impact to the system at DB part ? all the original script can be run normal when DB upgraded to 2005?

No they will not run, there is so much difference between the two, I think you need to create an integration services package to move the database so you can deal with issues before moving to 2005. Another option is to restore a backup with 80 compatibility but that leaves the database in a state that SQL Server 2005 will complain about certain operations not suported because your database is in 2000 compatibility level. It is not complicated just more work. Hope this helps.

|||

Before upgrading your production system from SQL 7 to SQL 2005 (or from SQL 2000 to SQL 2005) you will want to do a massive amount of testing to ensure that everything that you are doing is still supported in SQL 2005, and that everything that you expect to exist still exists. Some system objects (such as sysobjects) have been changed or removed.

Also with the upgrade to SQL 2005 there may be many places where your T/SQL code can be optomized for SQL 2005 using new commands, or functions.