Show TOC

Porting a Repository from One DBMS to AnotherLocate this document in the navigation structure

You can port a repository from one DBMS to another retaining all your repository folder and branch structure and version histories by creating a new repository and using the Import Repository command to copy an existing repository into it. Importing a repository deletes any existing data in the database into which the repository is being imported.

Context

Note The repository to be imported must have been updated to the latest version before beginning the import. To update a repository, connect to it with an administrator account and follow the instructions (see Upgrading the Repository).

Procedure

  1. Create a database on the DBMS server to which you want to port the repository.
    Caution If the target repository database does not use the same character encoding as the repository database to be imported, then the import may fail if it encounters long strings that would need to be truncated to fit into the reserved size in the new database.
  2. Create a repository definition targeting your new database and then select Start of the navigation path Repository Next navigation step Connect End of the navigation path to connect to it and install the repository tables (see Installing the Repository to the Server).
  3. Select Start of the navigation path Repository Next navigation step Administration Next navigation step Import Repository End of the navigation path, and confirm that you want to proceed.
  4. Select the data source for the repository you want to import and specify the database user and password to connect with:
  5. Click Connect to begin the import.
    PowerDesigner begins to copy tables to the new repository. The process may take a considerable time. A progress bar gives an indication of the data copied, but the Browser Repository tab will not be updated during the import. When the import completes, PowerDesigner disconnects from the new repository.
  6. Reconnect to the new repository and review its contents to confirm that the import has completed correctly.
  7. If you have deployed PowerDesigner Web, reconfigure it to access the new database (see Changing the Repository DBMS for PowerDesigner Web).