BusinessObjects Enterprise Administrator's Guide

Importing data from a Crystal Enterprise 10 or BusinessObjects Enterprise XI CMS

You may want to import repository objects from a Crystal Enterprise 10 installation, or you may want to import repository objects from one BusinessObjects Enterprise XI installation to another. For example, you may have repository data on a test system that you want to move onto a production server.

Use the Import Wizard to copy repository data from the source CMS. You can choose to merge the contents of the source repository into the destination repository, or you can update the destination with the contents of the source CMS.

Merging repositories

When you merge the contents of the source repository with the destination repository, you add all repository objects from the source CMS into the destination CMS without overwriting objects in the destination.

This is the safest import option. All of the objects in the destination repository are preserved. Also, at a minimum, all repository objects from the source system with a unique title are copied to the destination repository.

If an object from the source has the same title as an object in the destination, the object is imported to the destination repository if:

• The object is not a Business View.
• You have selected "Automatically rename top-level folders that match top-level folders on the destination system."

The end result is a destination repository that contains all objects from the source repository that have unique titles, copies of all non-Business View objects from the source repository that have titles that match titles of objects in the destination, and all objects originally in the destination repository.

When an object is copied from the source CMS to the destination CMS, the folder or folders that contain the object are also copied, replicating the folder hierarchy of the source system on the destination. However, the names of top-level folders must be unique. Selecting "Automatically rename top-level folders that match top-level folders on the destination system" allows these folders to be renamed on the destination repository, and the objects in such folders to be copied to these renamed folders.

Note:    Top-level folders containing Business Views are not renamed, regardless of the options set. Renaming these folders would change the unique identifier associated with the Business View, causing the Business View functionality to fail.

Updating the destination repository

When you update the contents of the destination repository using the source repository as a reference, you add all objects in the source CMS to the destination CMS. If an object in the source repository has the same unique identifier as an object in the destination, the object in the destination is overwritten.

All object titles in a folder must be unique. By default, if copying an object from the source CMS to the destination CMS would result in more than one object in a folder with the same title, the copy fails.

If you want these objects to be copied, select the check box "Automatically rename objects if an object with that title already exists in the destination folder."

Note:    System Objects (users, user groups, servers, server groups, events, and calendars), are not renamed when you import them from one CMS to another, regardless of the options set. Changing the names of these objects would cause user management, server management, and event management for these objects to fail.

See "Using the Import Wizard" on page 411 for full instructions on using the Import Wizard to copy objects from one BusinessObjects Enterprise XI repository to another.

Copying data from a Crystal Enterprise 9 repository database

In Crystal Enterprise 9, the Crystal Repository database was hosted on a separate database server that you could connect to through ODBC.

In a BusinessObjects Enterprise environment, begin by making a backup copy of the source repository database. Then replace the repository by importing its contents into the CMS database using the Repository Migration Wizard.

When you use the Repository Migration Wizard, neither the source nor the destination database is overwritten. Objects from the source repository will be added to the destination repository database. If the Wizard finds identical objects (that is, objects with the same unique identifier) in the source and destination repositories, the source objects will not be copied.

When you copy repository objects into BusinessObjects Enterprise XI, only the most recent version of each object is copied.

Note:    Reports configured to use the source repository will now refer to the destination data source.

To copy repository data from Crystal Enterprise 9

1. From the BusinessObjects Enterprise program group, click Repository Migration Wizard. You must run the wizard on the machine containing your source repository.
2. From the Source list in the Select Source Repository dialog, click the name of the repository that you want to import.
3. Type the UserID and Password of a user with administrative rights to the repository database. Click Next.
4. The Select Destination Data Source dialog appears. In the CMS field, type the name of the destination data source's Central Management Server.
5. Type the User Name and Password of an Enterprise account that provides you with administrative rights to the CMS; then click Next.
6. From the "Source Repository Objects" list, select the items that you want to copy to your BusinessObjects Enterprise repository database. Click Next.

 

BusinessObjects Enterprise exports the selected repository objects from your BusinessObjects Enterprise Repository, reporting success or failure for each object.

7. Select the folder in your destination repository where objects from your source directory will be placed.

 To add objects to a new folder, select "Insert a new folder", and then type the name of the folder.

 

8. To delete an existing folder from your repository, select it, and then click "Delete the item/folder".
9. Click Next, and then Finish to complete the transfer and close the Repository Migration Wizard.

Related topics:    

• Refreshing repository objects in published reports

When you use the Repository Migration Wizard, neither the source nor the destination database is overwritten. Objects from the source repository will be added to the destination repository database. If the Wizard finds identical objects in the source and destination repositories, the source objects will not be copied.

When you copy repository objects into BusinessObjects Enterprise XI, only the most recent version of each object is copied.

Note:    Reports configured to use the source repository will now refer to the destination data source.