I have been assigned to migrate the ingress database to PostgreSQL database. Can anyone help me with the tools or the strategy we should follow to do so?
You've not mentioned how big the source database is, nor how many tables, indices, triggers, stored procedures, stored functions, etc, nor whether the Ingres instance uses any High Availability features.