Upgrade from BusinessObjects Enterprise XI Release 2 to BusinessObjects Enterprise XI 3.1 SP5 › Perform a Complex Upgrade on Windows › Copy Data to your BusinessObjects Enterprise XI 3.1 Deployment › Copy Data from your Existing CMS System Database

Copy Data from your Existing CMS System Database

If you install a new BusinessObjects Enterprise system with your original installation, whether on the same computer or on another computer, you can use the CCM to copy system data from the existing BusinessObjects Enterprise XI Release 2 CMS database to your BusinessObjects Enterprise XI 3.1 CMS database.

The destination database is initialized before the new data is copied in, so any existing contents of the destination database are permanently deleted (all BusinessObjects Enterprise tables are destroyed permanently and then recreated). Once the data has been copied, the destination database is established as the current database for the CMS.

Note: If you want to import users, groups, folders, and reports from one system database to another, without deleting the contents of the current CMS database, use the Import Wizard. For more information, click the online help in the Import Wizard.

Notes:

• If you performed a simple upgrade, the installation program performs this step automatically.
• If you are using the Import Wizard to import content from your existing deployment, it is not necessary to perform these steps.

Copy Data from a CMS Installed on Windows

Before you 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: If you are copying a CMS database from a BusinessObjects Enterprise XI 3.1 source destination to a BusinessObjects Enterprise XI 3.1 target destination, you can change the CMS location, name, and database type. However, you cannot change the BusinessObjects Enterprise installation path, operating system, and computer name.

To copy a CMS system database on Windows

1. Open the CCM and stop the SIA.
2. Right-click the SIA and choose Properties.
3. Click the Configuration tab, and then click Specify.
4. Choose Copy, then click OK.
5. Choose the version information for the source CMS database.
6. Select the database type for the source CMS database, and then specify its database information (including host name, user name, and password).
7. Select the database type for the destination CMS database.
8. Specify its database information (including host name, user name, and password).
9. When the CMS database has finished copying, click OK.
10. If you are upgrading from an earlier version than BusinessObjects Enterprise XI 3.1, you will be prompted to build an SIA.
    1. Click OK.
    2. Specify the administrator password, and then click OK.
    3. When the SIA is built, click OK.
11. Proceed to Copy File Repository Server Data.