Command line usage DBF to SQL Converter

This topic describes how to use DBF to SQL Converter command line parameters
You can use them to specify actions, which must be performed by the program at launch.
Command line parameters allows you to launch DBF to SQL Converter from your own applications, command files, and so on.
Using command line can save you a lot of time, you can automatize everyday tasks and run them with a single click or by scheduler.

The basic syntax is:

dbf2sql.exe c:\tmp\source.dbf -output=c:\tmp\ -batch  [other parameters]
dbf2sql.exe c:\tmp\source.dbf -output=c:\tmp\ -silent [other parameters]
Source file, Output file or folder, and -batch or -silent parameters are mandatory.

-batch runs the app and displays a main window
-silent runs the app and does not display any windows.

We recommend to use -batch during tuning and testing and then replace it to -silent

The long command line does not look pretty.
Therefore the good solution is to put command line parameters to another file - one parameter per line and run converter as:

dbf2sql.exe @c:\tmp\params.ini
c:\tmp\source.dbf
-output=c:\tmp\ 
-files=overwrite
-sqltype=mysql
-batch
You can combine parameters in the file and in the command line.
You can use comments, just add ; in the beginning of a line

dbf2sql.exe c:\tmp\source.dbf @c:\tmp\params.ini
-output=c:\tmp\ 
-separate=1
;overwrite existing files
-files=overwrite
-outcharset=65001
-sqltype=postgresql
-silent
It is hard to remember all parameters, so we created a really great helper for you: Expert mode!

Just launch DBF to SQL Converter, select source file(s), the output file/folder, select necessary parameters, such as a field delimiter, code page, quotes etc.
Then click the button "Expert mode" and you will see how all your settings become command line parameters!

Moreover, this dialog allows you to save them as command .bat file, and a shortcut, and as .ini

If you did everything correct, you can run the converter by clicking on .bat or shortcut.

DBF to SQL Converter