Convert SQL to DBF
Turn SQL files into DBF files. The tables the script creates are loaded first, with a dump from MySQL, MariaDB or PostgreSQL rewritten into SQLite's dialect.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop SQL files on the dialor turn it to pick what to do
One DBF table for each table in your script.The tables the script creates become dBASE III files, named after the tables.
What you get
The script's tables are loaded first, then each one is written as its own DBF file. The file carries the name of its table, and the column names become the field names.
A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before it is loaded. Numbers and dates become typed fields. Other cells become text.
What changes
Field names are cut to 10 Latin letters, digits and underscores. When none are left in a name, the field is called FIELD1 and so on.
Text cells hold up to 254 bytes. They are stored in the Windows code page that fits the text, or in UTF-8 when none does.
Dates that are not real dates, such as MySQL's 0000-00-00, are left empty. PostgreSQL true and false become 1 and 0.
What is left out
Views, functions and triggers are not carried over. The conversion warns you about each one it leaves out.
A script with several tables gives you several files. For other routes from SQL, see every SQL conversion.
SQL and DBF.What each format is.
The formats
SQL Script
SQL statements as text. A database dump that any SQL tool can read or replay.
- Extensions
- .sql
- MIME type
- application
/sql - Kind
- Text and data
dBase Table
dBase tables, the attribute tables of shapefiles and many legacy databases.
- Extensions
- .dbf
- MIME type
- application
/x -dbf - Kind
- Documents
In your code.The same SQL to DBF conversion through the API, for your app or your agent.
$ cv convert report.sql report/ --to dbf$ cv convert report.sql report/ --to dbfQuestions.What people ask about SQL to DBF.
One dBASE III table for each table the script creates, so a script with several tables gives several files.
Yes. A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before the tables are loaded.
Field names are cut to 10 Latin letters, digits and underscores. If none are left, the field is named FIELD1 and so on.
They are left out, and the conversion warns you about them. Functions are left out the same way.