Modify Your CA Business Intelligence r3.2 Installation to CA Business Intelligence Release 03.3.00 › Migration from MySQL to SQL Anywhere Database › Content Migration from MySQL to SQL Anywhere CMS Repository › Migrate Content from MySQL to SQL Anywhere CMS Repository Using Windows

Migrate Content from MySQL to SQL Anywhere CMS Repository Using Windows

After your databases are ready, migrate the content from the MySQL database to the SQL Anywhere database.

Note: The following procedure applies to the Windows environment only.

Follow these steps:

1. From the Central Configuration Manager window, stop the Server Intelligence Agent (SIA) by performing the following actions:
   1. Select the Server Intelligence Agent from the Display Name list.
   2. Click the Stop button in the toolbar.
2. Open the Server Intelligence Agent Properties dialog by selecting the Server Intelligence Agent service and clicking the Properties button in the toolbar.
3. Navigate to the Configuration tab and, in the CMS System Database Configuration area, click the Specify button to open the CMS Database Setup dialog.
4. Select the option Copy data from another Data Source and click OK.

   Note: You select this option because you want to migrate the content from the MySQL CMS Repository to the SQL Anywhere CMS Repository.

   The Specify Data Source dialog opens.

5. Verify that Autodetect is selected in the drop-down that is labeled Source contains data from version.
6. Click the Specify button to specify the source of the CMS Repository content.

   The Select Database Driver dialog opens.

7. Select the option MySQL driver (because the source CMS Repository database is MySQL) and click OK.

   The MySQL Database dialog opens. This dialog captures the information that pertains to the source CMS Repository database.

8. Verify the information in the dialog, specify the password, and click OK.

   You return to the Specify Data Source dialog. The next step is to specify the destination CMS Repository database details.

9. Click the Browse button to open the Select Database Driver dialog.
10. Select the option SQL Anywhere (ODBC) because the target database is SQL Anywhere and click OK.

    The Select Data Source dialog opens.

11. Navigate to the Machine Data Source tab, select the SQL Anywhere CMS Repository database, and click OK.

    The Connect to SQL Anywhere dialog opens.

12. Specify the password for the BusinessObjects Enterprise Account User (that you created in previous procedures) and click OK.

    You return to the Specify Data Source dialog.

13. Click OK.

    You are prompted for confirmation.

14. Click Yes.

    The migration process starts.

    Upon successful completion, CCM displays the message "CMS database setup completed!”.