Step 1: Plan your migration

Before migrating to SQL Server 2005, have a plan in place as detailed in this Step-by-Step Guide.

Step 1: Plan your migration First and foremost, build a plan that outlines the logistics for the project. It should include items like dates, times, systems, team members and so on. Make sure the plan outlines all of the major steps in the project from the requirements to the deployment. Incorporate a rollback plan into the overall plan to ensure the SQL Server 2000 environment can be used if a problem occurs in the migration proce...

ss.

For more SQL Server 2005 migration planning resources, check out:

  • Step-by-Step Guide: Planning your migration to SQL Server 2005
  • Checklist: Getting ready for SQL Server 2005
  • Webcast: Weighing your SQL Server 2005 migration options


  • Upgrading to SQL Server 2005 using Copy Database Wizard
     Home: Introduction
     Step 1: Plan your migration
     Step 2: Choose your hardware and software
     Step 3: Test your migration process
     Step 4: Be sure you have a corruption-free environment
     Step 5: Migrate using the Copy Database Wizard
     Step 6: Perform post-upgrade tasks
     Step 7: Conclusion


    ABOUT THE AUTHOR:   
    Jeremy Kadlec
    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. Kadlec is the SearchSQLServer.com Performance Tuning expert. Ask him a question here.
    Copyright 2006 TechTarget
    This was first published in June 2006

    Dig deeper on SQL Server Migration Strategies and Planning

    Pro+

    Features

    Enjoy the benefits of Pro+ membership, learn more and join.

    0 comments

    Oldest 

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to:

    -ADS BY GOOGLE

    SearchBusinessAnalytics

    SearchDataCenter

    SearchDataManagement

    SearchAWS

    SearchOracle

    SearchContentManagement

    SearchWindowsServer

    Close