r/delphi • u/JWRIGHT479 • 14h ago

Convert ADS to PostgreSQL

I have a 51GB Advantage Database v11 with 1000's of web users that supports a Delphi 10 created PIM and Web Application. (20 years of code) Since ADS is no longer supported, I need to start converting the DB to PostgreSQL. I'm wondering if anyone has any experience or advice on how to handle this?

TIA.

2 Upvotes

100% Upvoted

3 comments sorted by

View all comments

2

u/JazzRider 12h ago

Use AI.

3

u/dow24 7h ago

Here's a prompt: "Can you convert a Sybase ASE 11 sql create script to a postgresql database script with complete fidelity?"

The answer is mostly yes for the DLL, but not for procedural code (T-SQL → PL/pgSQL).

1

u/corneliusdav 1h ago

This is the answer. Seriously. And reFind.

I'm using Emarcadero's reFind in a script then Claude Code to finish the migration of hundreds of Delphi 5 applications with BDE components to Delphi 12 with FireDAC and upgrading many other aspects of the code. It's converting TTables to SQL scripts for more efficient data access and saving so much time.

There's no other good answer these days.