Chapter overview: Deploy a new farm, then migrate databases (Office SharePoint Server)

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.


Topic Last Modified: 2016-11-14

If you are either moving to new hardware or redesigning and restructuring your deployment, you can choose to migrate your databases from the old version to the new version rather than directly upgrading them. When you perform a database migration, you perform an in-place upgrade on the databases, but you do not upgrade your server farm configuration data. Although this upgrade path has more manual steps than either an in-place or a gradual upgrade, it can be the best option if you have highly customized sites or custom Web services or applications.

You can migrate databases from either Microsoft Office SharePoint Portal Server 2003 or Microsoft Windows SharePoint Services 2.0 to your new Microsoft Office SharePoint Server 2007 environment. For both sources, the steps to set up and attach databases to your new environment are the same. The only difference is that for Windows SharePoint Services 2.0, you have only content databases that need to be migrated, and no other database types.


Before you begin the process, be sure you have performed the planning and pre-upgrade steps. For more information, see Chapter overview: Plan and prepare for upgrade (Office SharePoint Server) and Chapter overview: Perform pre-upgrade steps (Office SharePoint Server).

Perform a database migration by using the following steps:

  1. Create the environment for the new version. See Prepare the new Microsoft Office SharePoint Server 2007 environment.

  2. Back up or copy the databases, and then migrate the data. See Migrate databases.

After you have completed these steps, you can go on to the Perform post-upgrade steps (Office SharePoint Server) chapter and perform the following steps:

  1. Review the sites to be sure they upgraded properly. See Review upgraded sites (Office SharePoint Server).

  2. Troubleshoot and resume upgrade (Office SharePoint Server)

  3. Perform post-upgrade steps. See Perform post-upgrade steps for an in-place upgrade (Office SharePoint Server). Because database migration is essentially an in-place upgrade for your content, you can use the same post-upgrade steps.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Office SharePoint Server 2007.