Convert DBF to SQL

DBF Converter allows you convert a single dbf file or folder with dbf files to SQL script (MySQL, SQL Server, Oracle) from GUI or command line.

1. Select the dbf file (or select folder for batch conversion).

2. Select the output SQL file.

dbf to sql conversion

3. Preview, select options for sorting, filtering data (if necessary)

You can also select/unselect columns, set order for columns.

common options

4. Select options for sql format: SQL Syntax (MS SQL, Oracle, MySQL, PostgreSQL), rows delimiter (if necessary), and click "Finish"

SQL file format options

DBF to SQL Command Line

"c:\Program Files\DBF Converter\dbfcnv.exe" file.dbf myscript.sql [/MYSQL | /ORACLE | /MSSQL | /FILTER | /COLUMNS | /COLUMNSLIST | /REVERSE | /SORTBY | /LOG]

Simple DBF to SQL conversion

"c:\Program Files\DBF Converter\dbfcnv.exe" mybase.dbf myscript.sql /MYSQL /COLUMNS:Name,Addr

Convert folder with dbf files to MySQL script

"c:\Program Files\DBF Converter\dbfcnv.exe" c:/base/*.dbf c:/script/ /TOSQL /MYSQL

Convert multiple dbf files to Oracle

"c:\Program Files\DBF Converter\dbfcnv.exe" c:/base/*.dbf c:/script/ /TOSQL /ORACLE

Convert DBF to MySQL with selected columns

"c:\Program Files\DBF Converter\dbfcnv.exe" file.dbf mybase.sql /MYSQL

DBF to MS SQL (SQL SERVER)

"c:\Program Files\DBF Converter\dbfcnv.exe" file.dbf mybase.sql /MSSQL

DOWNLOAD
for FREE

Updated Thu, 14 Mar 2024

Back to DBF Converter Home