I get lots of questions all the time about upgrading from SQL 7 or 2000 to 2005. I can tell everyone that so far most of my customers have gone through the process without incident. The product group really focussed on the upgrade scenerios with SQL Server 2005, and honestly, it shows; the whole process can usually be described as 'mostly harmless'. ;-)

For those of you who want to read some best practices of others that have migrated, we just released the SQL Server 2005 Upgrade Technical Reference Guide. It's a great reference that covers:-

  • Section 1.0, “Upgrade Planning and Deployment,” provides a comprehensive overview of the key planning and deployment considerations for upgrading to SQL Server 2005.
  • Sections 2.01-2.05 cover special upgrade considerations for high availability and very large databases (VLDB).
  • Sections 3.01-3.08 cover upgrading relational databases to SQL Server 2005, including specific discussions on security, Transact-SQL queries, full-text catalogs, maintenance plans and SQL Server Agent jobs, Notification Services, Management Tools, and MSDE.
  • Sections 4.01-4.03 then cover moving to the SQL Server 2005 business intelligence components: Reporting Services, Integration Services, and Analysis Services.

It's around 350 pages, and well worth a read if you're feeling a bit jittery about the upgrade and need a technical security blanket to pull you through. Download it here.