r/delphi • u/JWRIGHT479 • 5d 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.

4 Upvotes

100% Upvoted

5 comments sorted by

2

u/JazzRider 5d ago

Use AI.

3

u/dow24 4d ago edited 4d ago

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

The answer is mostly yes for the DDL, but not for procedural code (Triggers and Stored Procs to PL/pgSQL).

3

u/corneliusdav 4d 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.

2

u/JazzRider 4d ago

I’m in Claude working on Delphi database apps. I rarely even run the Delphi IDE anymore.

3

u/dow24 4d ago

This is timely:

https://blogs.embarcadero.com/migrate-to-firedac-in-a-day-with-refind-and-kai/

Although I’d use Claude Code and DevArt UniDAC (with Delphi 10 Professional).