Upgrade from BusinessObjects Enterprise XI or XI Release 2 to BusinessObjects Enterprise XI 3.1 SP3 › Perform a Complex Upgrade on UNIX › Copy Data to your BusinessObjects Enterprise XI 3.1 Deployment › Copy Data from your Existing CMS System Database › Copy Data from a CMS Installed on UNIX

Copy Data from a CMS Installed on UNIX

Use this procedure if your CMS is installed on UNIX and you are copying data from BusinessObjects Enterprise XI or XI Release 2. Before to copy the contents of the CMS database, ensure that you can log in to the destination database with an account that has permissions to add or drop tables, and to add, drop, or modify data in those tables.

Note: On UNIX you cannot migrate directly from a source environment that uses an ODBC connection to the CMS database. If your source CMS database uses ODBC, you must first upgrade that system to a supported native driver.

To copy data from a CMS installed on UNIX

1. Stop the BusinessObjects Enterprise XI 3.1 CMS by typing the following command:

   ./ccm.sh -stop sia
   

2. Run cmsdbsetup.sh (located in <INSTALLDIR>/bobje/, by default).
3. Select the copy option (option 4), then confirm your choice.
4. Select the version information for the source CMS database.
5. Select the database type for the source CMS database, then specify its database information (including host name, user name, and password).
6. Select the database type for the destination CMS database, and then specify its database information (including host name, user name, and password).

   The CMS database is copied to the destination computer. A message displays when the copy is complete.

7. If you are upgrading from an earlier version than BusinessObjects Enterprise XI 3.1, you will be prompted to build a SIA. Specify the administrator password.

   A message displays when the SIA is built.

8. Proceed to Copy File Repository Server Data.