Migration Tool SQL Anywhere to Postgres

[former_SQLA_member1694968]

Hi all,

we develop and distribute a ERP Software, developed with Appeon Powerbuilder using SQL Anywhere 17 as database. An SAP representative told us "You are not allowed to sell/ distribute (SQL Anywhere) licenses after 31.12.25". At the moment we are planning to switch to postgres. Can anyone recommend a migration tool that also supports triggers and procedures? How do you deal with this problem?

[MCMartin]

Not a migration tool, but at least a very good starting point:

Use the jOOQ Parser to translate any SQL statement(s) to a different dialect.

[former_SQLA_member1694968]

Very nice Tool, ty.

[awitter43]

Tried it, but to limited for us (eg. no mutex, functions nor procedures. It even doesn't recognise remarks)