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 UNIX

Migrate Content from MySQL to SQL Anywhere CMS Repository Using UNIX

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

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

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 4 for the "copy" option and press Enter.

   You are prompted for confirmation that you want to proceed with the copy operation.

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

   You are asked to identify the version of SAP BusinessObjects Enterprise from which you are migrating.

6. Enter 2 for the "autodetect" option and press Enter.

   The current CMS Repository database details display and you are asked if this database is the destination database.

7. Enter 2 for the "no" option and press Enter.

   You are asked to select the database type.

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

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

9. 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 CMS Repository database.

10. 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 CMS Repository database.

11. 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 to specify the source database type.

12. Enter 3 for the "MySQL" option and press Enter.

    You are asked to enter the host name for the MySQL database.

13. Enter the host name to connect to the MySQL database and press Enter.

    Note: This host name is the name that is specified in the cabiresponse.ini file.

    You are asked to enter the port number for the MySQL database. The default port number (3306) displays.

14. Enter the MySQL port number or accept the default and press Enter.

    You are asked to enter the MySQL database name. The default name (BOE120) displays.

15. Enter the MySQL database name or accept the default and press Enter.

    You are asked to enter the user name to connect to the MySQL database.

16. Enter the user name and press Enter.

    You are asked to enter the user password to connect to the MySQL database.

17. Enter the user password and press Enter.

    The copy (content migration) operation begins. When the operation is finished, you receive successful completion messages.