Migrate portal database

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

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

Step-by-step guide

To perform a database migration, proceed as follows:

1. Click on Port database.

   The "Database server" dialog box is displayed.

   

2. Select the desired database server.

   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 "PostgreSQL - Connection data" dialog box appears.

   

4. Enter the PostgreSQL connection data.

5. Click on "Next".

   The "PostgreSQL - Database details" dialog box appears

   

6. Enter the PostgreSQL database details.

7. Click on "Next".

   The "Start" dialog box appears.

   

8. Click on "Start".

   The database migration is started. The "Create portal" dialog box appears.

   

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

   The "Success" dialog box is displayed.

   

10. Click on "Finish".

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.

Perform database migration without Portal Manager

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

<intrexx installation directory>\bin\windows

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

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