Recommendations for transition/ migration from MSSQL to PostgreSQL

Products

• Clarity PPM On Premise

Issue/Introduction

We are considering moving from SQL Server to PostgreSQL database. 

Is there any limitation in the amount of users or database size on PostgreSQL? Are there any recommended steps on transitioning data from SQL server to PostgreSQL in Clarity?

Environment

Release : All Supported Clarity releases

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

We do not currently have any limitations for number of users or database size on PostgreSQL.

We also do not have any recommended steps on transition from MSSQL to PostgreSQL. We strongly recommend engaging a partner to perform this transition as it can be a complicated matter.