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 Crystal 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 Crystal Repository Migration Wizard.

When you use the Crystal 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 Crystal Enterprise 10, 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 Crystal Enterprise program group, click Crystal 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 Crystal 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 Crystal Enterprise repository database. Click Next.

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

7. Click Next, and then Finish to complete the transfer and close the Crystal Repository Migration Wizard.

Related topics

• Refreshing repository objects in published reports