After you restore the databases, run the Data Migration Utility to update the server configuration. You must run the Data Migration utility in the following two modes:
Migration Mode: To migrate data.
Post Migration Mode: To configure SQL Server Reporting Services (SSRS) and to retain the aggregate values of the previous version of the Analysis Center data sources.
To migrate data and configure SSRS:
Launch the Data Migration Utility.
In the Welcome dialog box, click Migration > Next.
Specify the account to use for logging on to the new Data Warehouse instance and click Next.
The following table lists the information you need to provide:
|
Option |
Required Information |
|---|---|
|
New Data Warehouse Server Name |
Specify a valid name, in format ServerName/Instance, for the new Data Warehouse instance where you want to migrate data from a previous installation. |
|
Login Using Windows or SQL Server Authentication |
Select the authentication method for the account to connect to the new Data Warehouse instance. |
|
Login Name and Password |
If you select Login Using SQL Server Authentication, specify the login name and password for the account. The login name must have write permissions for the AC_Configuration and AC_Warehouse databases. |
|
Test Connection |
Click Test Connection to verify that the Data Warehouse instance is accessible. |
|
Analysis Server Name |
Specify a valid name, in format ServerName/Instance, for the Analysis Services instance where Analysis Center 3.0 or later is installed. |
In the Data Source dialog box, review the list of Data Sources in the Data Source Name column, specify the names for the new Data Mart instance and Data Mart database, and then click Next.
The following table lists the information you need to provide:
|
Option |
Required Information |
|---|---|
|
New Data Mart Server Name |
Specify the name, in format ServerName/Instance, for the new Data Mart instance where you restored the Data Mart database backups. |
|
New Data Mart Database Name |
Specify the name for the new Data Mart database that you restored. |
|
Login Name and Password |
Specify the login name and password for the Data Source if you are using SQL Server Authentication. |
In the Input Summary dialog box, review the details of the Data Warehouse, Data Sources, and Analysis Services instances to migrate. Click Migrate to start migrating data.
Review the Results Summary and click Finish to exit the Data Migration Utility.
On the instance where you installed the Analysis Center 3.0 or later Data Warehouse, run the Analysis Center 3.0 or later setup program in Repair mode.
Launch the Data Migration Utility again. In the Welcome dialog box, click Post Migration and click Next.
Specify the account to use for logging on to the new Data Warehouse instance by providing the information as you specified in Step 3. Specify a valid name, in format ServerName/Instance, for the Reporting Services instance and click Next.
In the Results Summary dialog box, click Finish to exit the Data Migration Utility.
Launch the Analysis Center 3.0 or later Admin Console and enable all the Data Sources.
After the first successful completion of the ETL processing jobs for all Data Sources, enable the OLAP processing job. After the first successful completion of the OLAP processing job, you can begin generating reports.