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.

  1. 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.

  2. 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.

  3. 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

From · SQL

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
To · DBF

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.

terminal
$ cv convert report.sql report/ --to dbf
$ cv convert report.sql report/ --to dbf

Questions.What people ask about SQL to DBF.

01OF 04

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.

More conversions.Other ways in and out of SQL and DBF.