Migrate portal database

You have the option of migrating your portal database. You can change the database type when doing so.

Migrating a database is essentially the same as creating a new database when creating a new portal. Refer also to the section Create database.

Step-by-step guide

Proceed as follows to perform a database migration:

  1. Click on Port database.

    The "Database server" dialog box is displayed.

  2. Select the desired SQL (database) server instance.

    For the Oracle database server, you must obtain the database drivers directly from the manufacturer.

    The subsequent dialogs where the connection to the database server is configured varies from database to database.
    In this guide, PostgreSQL will be used as an example.

  3. Click on "Next".

    The "Database server - PostgreSQL (1)" dialog box appears.

  4. Enter the PostgreSQL connection data.

  5. Click on "Next".

    The "Database server - PostgreSQL (2)" dialog box appears.

  6. Enter the PostgreSQL database details.

  7. Click on "Next".

    The "Advanced" dialog box appears.

  8. Enter the time zone in which the database is located here.

  9. Click on "Next".

    The "Porting" dialog box appears.

  10. Click on "Start".

    The database migration starts. The "Porting" dialog box appears.

  11. Click on "Finish" when all actions have been carried out.

    This takes you back to the "Portal properties".

After the migration, the portal is automatically connected to the newly created database. All entries will then be stored in this database with immediate effect.

You can change the database login in the "Integration" module under "Consume data / JDBC data source".

Perform database migration without the Portal Manager

You can also carry out a database migration via the command line. The file migratedb.bat file is available. It can be found at the following location:

<intrexx-installationsverzeichnis>\bin\windows

After you have started the .bat file, a dialog box is displayed for entering the portal directory in which the portal is located.

The next steps are carried out in the same way as the migration using the Port database button.