How to: Migrate Analysis Services Databases

You can migrate existing Analysis Services databases either during Setup, by upgrading an existing instance of Analysis Services, or after Setup, by running the Migration Wizard.

This topic describes the process of migrating existing SQL Server 2000 Analysis Services databases by using the Migration Wizard. When you upgrade an instance of SQL Server 2000 Analysis Services during Setup by using the SQL Server Installation Wizard, you do not have to specify any additional options related to database migration.

Important

This topic and the accompanying Analysis Services upgrade and migration how-to topics focus only on upgrade and migration options that are specific to Analysis Services. However, these topics provide links to other topics for more information about the installation of SQL Server.

To migrate existing Analysis Services databases by using the Migration Wizard

  1. Start the Migration Wizard from an Analysis Services server node in the Object Browser in SQL Server Management Studio. You can also start the wizard at the command prompt, by running the program MigrationWizard.exe.

  2. The wizard starts and displays the Welcome to the Analysis Services Migration Wizard page. Read the introductory message and then click Next to continue.

  3. On the Specify Source and Destination page, identify the source SQL Server 2000 Analysis Services server and instance name, and then identify the destination SQL Server 2008 R2 Analysis Services server and instance name. Instead of designating a destination server, you can also decide to save the database schema to a script file and complete the migration later. You can do this by using an Analysis Services Execute DDL task in a Integration Services package. For more information about the Analysis Services Execute DDL task, see Analysis Services Execute DDL Task.

  4. On the Select Databases to Migrate page, select the check boxes next to the databases that you want to migrate. You can specify different names for the destination databases if you want.

  5. On the Validating Databases page, the wizard analyzes the databases to be migrated and reports any issues that it discovers.

  6. On the Migrating Databases page, the wizard reports its progress as it performs the database migration.

  7. On the Completing the Wizard page, the wizard reports the results of migration. Click Finish to complete the wizard.

  8. After you migrate a database, you must process the database from the original data source before you can query the database. For more information, see Processing Analysis Services Objects.

  9. After migration, you might want to review Migration Considerations (Analysis Services) to understand the differences between Analysis Services database versions.