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 UNIX

Move from MySQL to SQL Anywhere Audit Database on UNIX

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

Note: The following procedure applies to the UNIX environment.

Follow these steps:

1. On the UNIX system computer, navigate to the bobje directory under the CA Business Intelligence installation directory.

   Example: /opt/CompanyA/SharedComponents/CommonReporting3/bobje
   

2. Execute the following command:

   ./cmsdbsetup.sh
   

   You are prompted to enter the Server Intelligence Agent (SIA) name.

3. Enter the SIA name and press Enter.

   Note: This name corresponds to the SIANodeName property value in the biek.properties file. You can find the biek.properties file in the CA Business Intelligence installation directory.

   Details about the current CMS Repository and Audit databases display. In addition, Data Source setting configuration options appear.

4. Enter 2 for the "selectaudit" option and press Enter.

   You are asked to select the database type.

5. Enter 2 for the "SQL Anywhere" option and press Enter.

   You are asked to specify the ODBC Data Source Name for the Audit database.

6. Enter the ODBC Data Source Name and press Enter.

   Note: This Data Source Name is the name that you specified when you created the SQL Anywhere CMS Repository and Audit databases.

   You are asked to enter the user name to connect to the SQL Anywhere Audit database.

7. Enter the user name and press Enter.

   Note: This user name is the name that you specified when you created the SQL Anywhere CMS Repository and Audit databases.

   You are asked to enter the user password to connect to the SQL Anywhere Audit database.

8. Enter the user password and press Enter.

   Note: This user password is the password that you specified when you created the SQL Anywhere CMS Repository and Audit databases.

   You are asked if you want to enable auditing.

9. Enter 3 for the "yes" option and press Enter.

   The Audit data source settings are updated to the SQL Anywhere Audit database, and successful completion messages display.

10. Navigate to the bobje directory under the CA Business Intelligence installation directory.
11. Execute the following command to start the servers:

    ./startservers