5.6 Using the Data Migration Utility

After you restore the databases, you can run the Data Migration Utility to update the server configuration.

You need to run the Data Migration utility twice - once in Migration mode and again in Post Migration mode. Post-migration allows you to configure SQL Server Reporting Services and to retain the aggregate values of the previous version of the Analysis Center data sources.

To migrate data:

  1. Start the Data Migration Utility in the program folder where you installed it, typically ..\Program Files\NetIQ\Analysis Center\Data Migration Utility.

  2. In the Welcome dialog box, click Migration, and then click Next.

  3. Provide information in the following fields to specify the account to use to log on to the new Data Warehouse instance, and then click Next.

    Field

    Action

    New Data Warehouse Server Name

    Enter a valid name for the new Data Warehouse instance where you want to migrate data from a previous installation. Use the format ServerName[/Instance].

    Login Using Windows or SQL Server Authentication

    Choose whether the account used to connect to the new Data Warehouse instance will use Windows Authentication or SQL Server Authentication.

    Login Name and Password

    If you selected Login Using SQL Server Authentication, enter 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

    Enter a valid name for the Analysis Services instance where Analysis Center 2.9 is installed. Use the format ServerName[/Instance].

  4. In the Data Source dialog box, review the list of Data Sources in the Data Source Name column and specify the names for the new Data Mart instance and Data Mart database in the following fields, and then click Next.

    Field

    Action

    New Data Mart Server Name

    Enter the name for the new Data Mart instance where you restored the Data Mart database backups. Use the format ServerName[/Instance].

    New Data Mart Database Name

    Enter the name for the new Data Mart database that you restored.

    Login Name and Password

    Enter the login name and password for the Data Source if you are using SQL Server Authentication.

  5. In the Input Summary dialog box, review the details of the Data Warehouse, Data Sources, and Analysis Services instances to migrate. To start migrating data, click Migrate.

  6. Review the Results Summary and click Finish to exit the Data Migration Utility.

  7. On the instance where you installed the Analysis Center 2.9 Data Warehouse, run the Analysis Center 2.9 setup program in Repair mode.

  8. Start the Data Migration Utility. In the Welcome dialog box, click Post Migration and click Next.

  9. Specify the account to use to log on to the new Data Warehouse instance by providing information in the fields, as you did in Step 3. Enter a valid name for the Reporting Services instance, using the format ServerName[/Instance], and click Next.

  10. In the Results Summary dialog box, click Finish to exit the Data Migration Utility.

  11. Start the Analysis Center 2.9 Console and enable all the Data Sources.

  12. 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.