On Premise MSSQL / Oracle database move to PostgreSQL?

Products

• Clarity PPM On Premise

Issue/Introduction

We are an On Premise customer on Oracle or MSSQL, looking to migrate to Clarity with PostgreSQL.

How to connect a PostgreSQL database to Clarity? Is it possible to restore an MSSQL Server image / Oracle database dump into PostgreSQL?

Environment

Release :Any

Resolution

• To connect to a PostgreSQL database you have to do the same as for any other database vendor - after the database has been restored, open CSA - go to Database and enter the connection details, Save, ensure it states Available, then restart the services
• Regarding restoring an MSSQL or an Oracle database to PostgreSQL - this is not possible.
• To switch your database to PostgreSQL a complex migration conversion should be performed
• As a possible approach, you can start with an empty PG database and import / migrate your projects and other objects with XOG and REST API
• We recommend engaging a partner to do this as it is not something that can be done without expert assistance.
• We at Broadcom Support do not provide such assistance.
• The effort and cost of the conversion from MSSQL / Oracle to PostgreSQL is going to be customer responsibility.