Copying data from a Crystal Reports 9 repository database

The Crystal Repository shipped with Crystal Reports 9 was an Access database (Repository.mdb). By default, it was located in the following directory of your Crystal Reports installation:

C:\Program Files\Common Files\Crystal Decisions\2.0\bin\

Begin by making a backup copy of this default database. Then replace the default 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 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 Reports 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.

   If you created security for your repository database, type a User id and Password valid for the repository database.

3. Click Next.
4. Log on to the CMS using a user name with administrative rights to Crystal Enterprise.
5. From the "Source Repository Objects" list, select the items that you want to copy to your Crystal Enterprise repository database. Click Next.

   

6. 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.
   • To delete an existing folder from your repository, select it, and then click "Delete the item/folder".
7. Click Next.

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

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

Related topics

• Refreshing repository objects in published reports