Hi All - I have a requirement to move our Oracle database(11G) from ( premises to AWS cloud environment as well ) to Postgresql 11.5 environment. Do we have any proven mechanism OR tool to migrate the entire Oracle DB? I guess in postgresql we have separate procedural language pl/pgsql with slight changes from sql syntax.
what kind of manual intervention needed for this? Could you suggest me a better approach for this?
Thanks in advance!