Upgrading 2000 to 2008 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Upgrading 2000 to 2008

Author

Topic

DBA007
Posting Yak Master

145 Posts

Posted - 2009-12-22 : 07:42:53

HI,
what are steps to consider after upgrading the sqlserver from 2000 to 2008.How can I reconnect my .NET application from sqlserver 2000 to 2008 after upgrading.As we know some functionalities depricated in sqlserver 2008 from 2000,all my StoredProcedures,Functions,Views are related to sqlserver 2000.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-22 : 10:51:30

You should be checking your code BEFORE you upgrade, not AFTER. Run the Upgrade Advisor tool against your database to check for things that might not work.

As part of the upgrade process, you should update stats and change your compatibility level (if you can support 90 or 100 that is).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources