Porting a Repository from One DBMS to Another

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.

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).
  1. Create a database on the DBMS server to which you want to port the repository.
    Warning!   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 Repository > Connect to connect to it and install the repository tables (see Installing the Repository to the Server).
  3. Select Repository > Administration > Import Repository, 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:

    Importing a Repository
  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 correctedly.
Parent topic: Installing the Repository