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
NOTE: You can contact your support engineer if you are not able to locate the tool.
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
NOTE: For any error message, reinitiate the migration from step 2 or contact your support engineer.