EDB2MySQL converts an ElevateDB (EDB) database to MySQL or MariaDB. It performs two distinct operations:
Schema conversion — reads the structure of an EDB database (tables, columns, indexes, views, constraints, triggers, stored procedures and functions) and generates a SQL script ready to run on a MySQL or MariaDB server.
Data migration — transfers row data from EDB tables to the corresponding MySQL/MariaDB tables on a remote server.
The converter also includes a built-in SQL Console tab for running ad-hoc SQL queries on the remote MySQL/MariaDB server and inspecting the results. Its purpose is to verify the migration — checking that data arrived correctly, comparing row counts, and validating the converted schema — without leaving the application.
After conversion — once the database is running on MySQL/MariaDB, the included EDBApiClient library allows any Delphi application that already uses ElevateDB to execute SQL on the converted database via the same PHP backend. It can query the server and receive results into a local EDB table, and it can write data to the server in batch — inserting, updating, or upserting rows directly from local EDB temporary tables. This makes it possible to keep the MySQL/MariaDB database accessible and up to date from an existing Delphi application without replacing its ElevateDB data layer. The converter application is not required for this — only the library and the PHP backend.
Both operations require a small PHP component
(edbapi.php) deployed on the target web server, which acts
as a bridge between the application and the MySQL/MariaDB database.
EDB2MySQL is distributed as two components:
EDB2MySQL Converter — the Windows application described in this manual, including the SQL Console. It has no external dependencies beyond the PHP backend.
EDBApiClient Library — a standalone Delphi library
(EDBMMClient) intended for use after the migration is
complete. It provides three cooperating classes —
TMMConnection, TMMScript, and
TMMUpdater — that allow any Delphi application already
using ElevateDB to execute SQL on the MySQL/MariaDB server and receive
results into a local EDB table, and to write data to the server in batch
(INSERT, UPDATE, UPSERT) from local EDB temporary tables. It is
distributed as compiled units (DCUs) and requires ElevateDB 2 and Delphi
12 or 13.