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 › Migrate Content from MySQL to SQL Anywhere Audit Database

Migrate Content from MySQL to SQL Anywhere Audit Database

After you install the latest MySQL ODBC drivers and the Sybase Central client tool, migrate the content from the MySQL Audit database to the SQL Anywhere Audit database. Perform content migration only after the SQL Anywhere Audit database is ready.

Note: The following procedure applies to the Windows environment.

Follow these steps:

1. From the Sybase Central client tool, select Connections, Connect with SQL Anywhere 12.
2. Complete the connection information, including entries for the following fields, and click Connect.

   User ID

   Specifies the SQL Anywhere database administrator User Account (for the Audit database).

   Example: root (or dba)

   Password

   Specifies the password for the SQL Anywhere database administrator User Account.

   Server Name

   Indicates the SQL Anywhere Service Name.

   Example: BOE120SQLAW

   Database Name

   Identifies the database name for the Audit database.

   Example: BOE120_AUDIT

   A connection with the SQL Anywhere database is established.

3. Select Tools, SQL Anywhere 12, Migrate Database and click Next.
4. Select the destination database BOE120_AUDIT and click Next.
5. Enter the name of the remote database that you want to migrate (boe120_audit) and click Create Remote Server Now.

   Important! The remote database name is required. The migration fails if you do not specify this name.

6. Assign a name to the new remote server and click Next.
7. Select MySQL from the remote server type list and click Next.
8. Select Open database connectivity (ODBC) for the connection type.
9. Enter the name of the ODBC connection that was created with the latest MySQL5.1 ODBC drivers and click Next.
10. Select the option "Make this remote server a read-only data source" and click Next.
11. (Optional) Select the check box for "Create an external login for the current user" and provide the Login Name and Password information.

    Note: An external login is required if the SQLAnywhere 12 administrative user has a different user ID and password than the remote MySQL5 server.

12. Select Test Connection, verify that the connection works, and click Next.

    A summary displays the changes that you want to make to the database.

13. Select Finish.
14. Select the remote server that you created and click Next.

    Important! The remote server selection is required. If you do not specify this server, the migration can fail.

15. Select the tables to migrate from the Available tables list, click Add to move them to the Selected tables list, and click Next.
16. Select the BusinessObjects Enterprise user that you created during the database creation and click Next.

    Note: You can also create a user for this step by clicking Create User Now.

17. Select the migration options that you want and click Next.

    A summary displays with the generated SQL.

18. Select Finish.

    A completion message displays when the migration is finished.

19. From the Universe Designer, update the Activity Universe connection settings to point to the SQL Anywhere connection.