BusinessObjects Enterprise XI 3.1 SP5 uses SQL Anywhere 12 for the default CMS Repository and Audit databases (previous SP versions of BusinessObjects Enterprise XI 3.1 used the MySQL 5.0 database). A new installation of CA Business Intelligence 3.3 (on a computer that does not already have CA Business Intelligence) creates the CMS Repository and Audit databases using SQL Anywhere 12 automatically. An upgrade installation (for example, installing CA Business Intelligence 3.3 in an environment with CA Business Intelligence 2.x) also creates the SQL Anywhere database automatically (if you decide to migrate). However, update installations (for example, using the patch installer to update from SP3 to SP5) do not automatically create the SQL Anywhere database. For an explanation of update and upgrade installations, see Upgrade and Migration Scenarios.
The upgrade installations include the following scenarios:
|
Current Environment |
To Upgrade to CA Business Intelligence 3.3 |
|---|---|
|
CA Business Intelligence 3.2 or CA Business Intelligence 3.2 SP4 |
Install CA Business Intelligence 3.3. CA Business Intelligence installs the SP5 patch, but does not create a SQL Anywhere database. |
|
CA Business Intelligence 3.0/3.1 |
Upgrade to CA Business Intelligence 3.2 or the SP3 patch level using the CA Business Intelligence 3.2 installer or SP3 patch installer. Then upgrade to CA Business Intelligence 3.3. CA Business Intelligence installs the SP5 patch, but does not create a SQL Anywhere database. |
If you use the patch installer and you perform an update installation, you update the SP patch level of your BusinessObjects Enterprise (for example, from SP3 to SP5). The update installations do not automatically create the SQL Anywhere database. Therefore, you can decide to create and migrate from the MySQL database to the SQL Anywhere database after your update installation is completed. You can perform this database migration by manually completing the individual migration steps or by executing a migration script.
Note: This release of CA Business Intelligence is delivered as a full product (which includes the database migration automation script) and also as an SP5 patch installer (which does not include the database migration script). If you do not have the database migration script in your release, follow the manual procedures for migrating from MySQL to SQL Anywhere.
|
Copyright © 2012 CA.
All rights reserved.
|
|