Modify Your CA Business Intelligence r3.2 Installation to CA Business Intelligence Release 03.3.00 › Migration from MySQL to SQL Anywhere Database › SQL Anywhere Database Preparation Using the Automation Script

SQL Anywhere Database Preparation Using the Automation Script

The database preparation automation script (ssawdbcreate.bat) automates the manual steps involved in preparing the SQL Anywhere CMS Repository and Audit databases. The ssawdbcreate.bat script performs the following functions:

• Creates the CMS Repository and Audit databases.
• Sets up the Administrative and BusinessObjects Enterprise Account users.
• Creates and registers the service to start and stop the database.
• Creates the DSN for the CMS Repository and Audit databases.

Note: If you do not have the database migration script in your CA Business Intelligence release, follow the manual procedures for migrating from MySQL to SQL Anywhere.