Fork me on GitHub
EasyMOD :: SQL Parser
EasyMOD :: SQL Parser
SQL Data Definition Language (DDL) Conversion to MySQL, PostgreSQL and MS-SQL
SQL Data Definition Language (DDL) Conversion to MySQL, PostgreSQL and MS-SQL
Welcome to the SQL Parser for EasyMOD online conversion tool!

These panels allow you to convert SQL/DDL statements to MySQL, PostgreSQL or MS-SQL. It is based on the SQL Parser for EasyMOD. The main goal of the SQL Parser is provide support for as much options as possible making sure all those options are portable between the different SQL servers supported by the phpBB Database Abstraction Layer (DBAL).

The SQL Parser understands almost all options present in the MySQL syntax for the supported DDL actions, however it will issue warnings (or errors) when unsupported or non-portable features are detected, it also performs several checks to verify the consistency of the DB design. When warnings (or errors) are issued, it is recommended to adapt the original DDL to make it as portable as possible.

Currently, CREATE TABLE, DROP TABLE and ALTER TABLE are converted to a set of equivalent statements compatible with the selected SQL server. INSERT, UPDATE and DELETE statements are also accepted since they can be required when installing MODs to make DB changes, however these statements are basically compatible between all SQL servers, therefore they are left as-is, any other SQL command such as SELECT is unrecognized here.

This online tool is implemented as a wizard. The following panel contains a form where you can select the target SQL server and enter your SQL/DDL statements. The next panel will show you a report of the conversion process. This report may contain an error message (if the conversion process failed), or a list of warnings followed by all SQL statements generated. Ideally, you shouldn't get any warning. If that happens, it is recommended to adapt your SQL statements and re-try.

Feel free to use the support forum to post your comments or report any issues you may find using this tool. Your experience converting SQL schemas and, specially using non-MySQL servers is more than welcome.

Thanks for your collaboration,
The phpBB MOD Team