Yes DB size is around 1TB , in which probably more then 1k tables and same indices persist. others objects such as SP,SF and Triggers are also good in numbers . It's not HA solution .
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.
