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 Audit Database › Move from MySQL to SQL Anywhere Audit Database on Windows

Move from MySQL to SQL Anywhere Audit Database on Windows

You complete the following steps to move from a MySQL database to a SQL Anywhere database.

Note: The following procedure applies to the Windows environment.

Follow these steps:

1. From the Central Configuration Manager window, stop the SIA, and open the SIA Properties dialog.
2. Navigate to the Configuration tab.
3. In the Audit Database Configuration area, verify that the check box labeled "Write server audit information to specified data source" is selected.
4. Click the Specify button to open the Select Database Driver dialog.
5. Select the option SQL Anywhere (ODBC) because you want to point to the SQL Anywhere Audit database that you created previously.
6. Click OK.

   The Select Data Source dialog opens.

7. Navigate to the Machine Data Source tab and select the SQL Anywhere Audit database that you want to use as the source for writing the BusinessObjects Enterprise server audit information.
8. Click OK.

   The Connect to SQL Anywhere dialog opens.

9. Specify the password for the BusinessObjects Enterprise Account User (that you created in previous procedures).
10. Click OK.

    The BusinessObjects Enterprise environment is updated to point to the new Audit database.

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

11. Click OK.

    You return to the Server Intelligence Agent Properties dialog.

12. Click OK.

    You return to the Central Configuration Manager window.

13. Start the SIA by clicking the Start button in the toolbar.