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?

[dhkom]

Will SQL Anywhere continue to be available from the SAP online store?

[MikePaola]

Yes, SQL Anywhere continues to be available on the SAP Digital Store. Here's a link to the page: https://www.sap.com/products/technology-platform/sql-anywhere.html?

Regards, Mike Paola

[dhkom]

Thanks, Mike. Indeed I am aware SQL Anywhere is available on the SAP Digital Store. My questions was, is there an end date planned for this?

SQL Anywhere is incredible software that a lot of people have used for a long time and rely on. It's demise would have a big impact on them. Clearly SAP has bigger fish to fry, however I urge you to encourage the powers that be within SAP to find a way forward for SQL Anywhere, whether within SAP or elsewhere. SAP had no use for PowerBuilder, but found it a good home where it lives on and lives well. It does not create good will when you hurt companies outside of a competitive situation.

[dhkom]

It seems there is no comment on how long SQL Anywhere will be available in the SAP online store. There could be multiple reasons for this, and I won't jump to any conclusions.

Many companies have had their SQL Anywhere OEM partnership with SAP dropped, including ours. Either the OEM program is ending for everybody, or it is being preserved in some form for the highest volume partners. We are now getting by with sending our customers to buy SQL Anywhere from the SAP online store, and I'm sure we're not alone. It's more expensive for our customers, and less convenient, but it works and lets us continue moving forward.

SQL Anywhere is the rock our company’s product is built on. SQL Anywhere has never failed us or our customers. It always does what we need it to do, does it well and fast, and we never run into the artificial limitations I always encountered with other DBMS platforms. It works so well and administration-free for our customers that most probably forget they are running it.

We have built over a couple of decades now a mountain of tested and robust code using the incredible proprietary features that SQL Anywhere has to offer. Porting to another platform is a nightmarish thought, especially since the massive effort required will not improve our software one bit.

I understand SAP uses SQL Anywhere internally, which should keep it going. Please keep in mind companies like us, and PLEASE keep SQL Anywhere licenses for our customers available.

IF SAP needs to leave SQL Anywhere behind, please do similar as you did with PowerBuilder - another product that SAP acquired from Sybase which it did not have need for. PowerBuilder was passed on to Appeon, where it is alive and well, growing and thriving. They are doing a magnificent job with it, and the PowerBuilder community is delighted.

I am sure Appeon would be delighted to run with SQL Anywhere, too, if such becomes no longer in SAP's interest. SQL Anywhere and PowerBuilder have worked hand-in-hand for years. Everyone would win, if it comes down to this, including and especially the large and loyal SQL Anywhere community, which, of course, includes us.

Thank you.

[VolkerBarth]

Dan, have you read that FAQ about the SQL Anywhere 17 EOL date, particularly Jason's answer?

[dhkom]

Yes. Thanks, Volker. However my question on plans to keep SA available in the SAP store was not answered. Jason's answers to the other post are welcome, and certainly help in the short and medium term, but I think it's fair to say that long term uncertainty remains. I wanted to put my plug in as a huge SQL Anywhere fan, and part of a company that would really not like to port to anything else. I also wanted to put a plug in for Appeon to take over should SAP decide down the road that SQL Anywhere is not on their critical path. Clearly community members are still concerned about the long term, as am I.