Step 4: Key SQL Server 2005 migration considerations

The migration to SQL Server 2005 is certainly an undertaking that requires a holistic view of the environment as well as a detailed plan to achieve the goal. As such, here are additional technical considerations that are key to the migration:

Download this free guide

Download: 60-Page Expert RDBMS Guide

Trends come and go, but your DB strategy shouldn’t be a flavor of the month. Learn why you shouldn’t get distracted by new DB technology, how Facebook is using a RDBMS to do the data slicing and dicing they can’t in Hadoop, and more.

Start Download

• Corporate E-mail Address:

  You forgot to provide an Email Address.

  This email address doesn’t appear to be valid.

  This email address is already registered. Please login.

  You have exceeded the maximum character limit.

  Please provide a Corporate E-mail Address.

By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.

By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

• Execute DBCC CHECKDB to validate that the previous environment (SQL Server 7.0 or 2000) is free of corruption prior to the upgrade.
• Issue final backups and ensure a rollback plan is in place to continue business operations in case an unforeseen problem is encountered.
• Develop enterprise standards for SQL Server 2005 configurations, operations (security, maintenance, etc.) and development.
• Archive unneeded data and perform data cleansing for the migrated data.
• Ensure all code is operating accurately prior to migration so that migration is the blame for broken code.
• Perform database maintenance such as UPDATE STATISTICS, DBCC CHECKDB and index rebuilds post upgrade.
• Validate that the SQL Server 2005 configurations and database compatibility modes are accurate post upgrade.

Notes from the field

At Edgewood Solutions, we conducted a SQL Server 2005 Adoption Rate Survey and one of the major findings was that organizations of all sizes were split 50/50 between migrating in less than one year and migrating in more than one year. The race is on, but make sure you do not have any false starts -- instead complete your race with the checkered flag flying!

Migrating to SQL Server 2005

 Home: Introduction
 Step 1: What to upgrade
 Step 2: Upgrade prerequisites
 Step 3: Migration options
 Step 4: Additional considerations

ABOUT THE AUTHOR:
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also SearchSQLServer.com's Performance Tuning expert.

More information from SearchSQLServer.com

• Tip: Reduce upgrade unknowns with SQL Server 2005 Upgrade Advisor
• Learning Guide: SQL Server 2005 Learning Guide
• Book Excerpts: SQL Server 2005 Management Studio

•