SQL DUMP AND INSERT

4D v12 introduces new SQL-related commands for exporting and importing data.

The SQL EXPORT DATABASE command exports all the records and tables of a database in SQL format.

 

The SQL EXPORT SELECTION command exports the records of the current selection of a 4D table in SQL format.

 

Previously, 4D export formats were binary. SQL dump is in highly readable text format.

 

And although text data is not standard/normalized between various platforms, 4D can accept data from multiple SQL engines using the SQL EXECUTE SCRIPT command, which supports multiple inserts, joins and more.