Monday, December 01, 2008 11:09 AM
Chris Koenig
Upgrading from SQL 2000/2005 to 2008
_thumb.gif "cc936623_image001(en-us)")
Still running SQL Server 2000 or 2005? Interested in upgrading to 2008, but not sure how to go about it? Here are a couple of recently released resources from your friends at Microsoft to help you get through the upgrade with a clean bill of heath:
SQL Server 2008 Upgrade Technical Reference Guide – this 490-page whitepaper covers the essential phases and steps involved in upgrading existing SQL Server 2000 and 2005 databases to SQL Server 2008 by using best practices including preparation tasks, upgrade tasks, and post-upgrade tasks. Here’s a snip from the ToC:
- Chapter 1 gives an overview of the technical issues and decisions that are involved in an upgrade to SQL Server 2008, as well as recommendations for planning and deploying an upgrade.
- Chapter 2 addresses issues related to upgrading to SQL Server 2008 Management Tools.
- Chapters 3 through 8 focus on upgrade issues for SQL Server relational databases.
- Chapter 9 addresses upgrading to SQL Server 2008 Express.
- Chapters 10 through 14 focus on upgrading to SQL Server 2008 Business Intelligence components: Analysis Services, Data Mining, Integration Services, and Reporting Services.
- Chapter 15 addresses the implications of upgrading to SQL Server 2008 for other Microsoft applications and platforms.
- Appendix 1 contains a table of allowed SQL Server 2008 version and edition upgrade paths.
- Appendix 2 contains an upgrade planning checklist.
Resources for Upgrading to SQL Server 2008 – these are the additional resources mentioned in the Upgrade TR located on MSDN.
UE Team blog – the SQL Server User Education team blog. Good resource for getting info on the latest developments in the SQL Server world.
Anonymous comments are disabled
About Chris Koenig
Chris Koenig is a Developer Evangelist with Microsoft, based in Dallas, TX. Prior to joining Microsoft, Chris worked as a Senior Architect on the Architecture Strategy Team for The Capital Group in San Antonio, and as an Architect, Developer and Development Team Lead for the global solution provider Avanade. As a consultant, Chris worked with a variety of clients from many vertical markets, ISVs and other solution providers on enterprise-class Windows and web-based applications. Today, Chris focuses on building, growing, and enhancing the developer communities in Texas, Oklahoma, Louisiana amd Arkansas. Chris is a devoted husband and father of four awesome children who keep him very busy. In his spare time, Chris serves as Scoutmaster for his oldest son's Troop, and Committee Chair for his youngest sons' Pack. Chris also enjoys travelling, cooking, camping and playing guitar. You can contact Chris through his blog at http://blogs.msdn.com/chkoenig, via email at chris.koenig@microsoft.com, or via Windows Live Messenger at chris@koenigweb.com.
