Switching from the Embedded Database to an External RDBMS

Integration Server 10.11 | Integration Server Administrator's Guide | Configuring the Server | Switching from the Embedded Database to an External RDBMS

If you installed your Integration Server with an embedded database, you can later switch to an external RDBMS.

To switch from an embedded database to an external RDBMS

1. Open the Integration Server Administrator.

2. Click Security > Certificates > Configure Client Certificates and note certificate mappings.

3. Create the IS Internal and Cross Reference database components and connect them to JDBC connection pools. For instructions, see Connecting Integration Server to Database Components in an External RDBMS.

Note:
After you connect the database components to the JDBC connection pools, Integration Server will begin writing to the external RDBMS. You do not have to set any properties.

4. Run the migration utility pub.scheduler:migrateTasksToJDBC to migrate your scheduled tasks from the embedded database to the external RDBMS. See the webMethods Integration Server Built-In Services Reference for more instructions.

Note:
This service migrates scheduled tasks only; certificate mappings and run-time data stored in the embedded database will not be migrated.

5. Go to the Security > Certificates > Configure client certificates page on the Integration Server Administrator and re-specify your certificate mappings. See Importing a Client Certificate and Mapping It to a User for instructions.