PostgreSQL is supported as the default database platform for ZENworks Service Desk, and we have seen in the recent past, many of our customers want to migrate their external non-PGSQL database to PostgreSQL when they decide to adopt or expand ZENworks Service Desk as their ITSM solution. The reasons for this may include that many of our customers already use PostgreSQL in their IT environments and there is no added licensing cost when they use it for Service Desk. Being one of the most popular database platforms, PostgreSQL’s vast community and large adoption may be the key reason for this surging interest.

As we were receiving requests from our customers, we thought of bringing an easier mechanism to facilitate the DB migration. In order to do that, we have created a new migration utility tool that will help you to MIGRATE your Service Desk data form MySQL or MS SQL to PostgreSQL almost seamlessly. Shortly, we are planning to extend this utility to provide support for migration from Oracle DB as well.

You have to follow just a few steps to perform your migration. Here are the steps:

Steps to Migrate

1. Copy the migration tool from the download site to a location in the Service Desk Server VM.

NOTE: You can contact your support engineer if you are not able to locate the tool.

2. Run the following commands:
   1. Login to the appliance terminal
   2. Run migrate sh script
   3. When prompted, enter the root credential
   4. Enter the source database type to migrate.
   5. Enter source database details such as database name, database user, database password, database host IP, database port.

NOTE: While migrating from MS SQL, the "Max connections reached, increase value of TDS_MAX_CONN" warning message can be ignored.

IMPORTANT: If database user credentials contain any character such as colon (:) or at-sign (@), then the characters should be doubled (:: or @@).

Example: If the password is Hel@0, then the password should be specified as Hel@@0

3. On a successful run of the command, the migration tool will do the following:

• Delete and recreate the existing embedded service desk database and keep a backup of the schema.
• Connect to the external DB, copy the data from the external DB to the embedded database, generate required Schema.

4. After completing the migration, the "Database migration successful" message will be displayed on the terminal.

NOTE: For any error message, reinitiate the migration from step 2 or contact your support engineer.