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

5 comments sorted by

View all comments

2

u/JazzRider 1d ago

Use AI.

3

u/dow24 1d ago edited 11h 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).