DBF to SQL 2.01 is a File Converter product from whitetown.com, get 4 Stars SoftSea Rating, The DBF to SQL software allows you to convert your dbf files to SQL script. You can apply this script on any SQL server, so you can easily transfer your data to a new system. There are several different SQL servers, but this software allows you to customize the output file. The software supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats. You can run the software in a batch mode using command line interface. Besides, it includes a DLL which you can use from your own application.

DBF to SQL. Command line description

Common parameters

/OVERWRITE=1 Overwrite existing file.
/OVERWRITE=0 Do not overwrite existing file. (Append to existing file).
/ASIS Codepage as is.
/ANSI Convert to ANSI codepage.
/OEM Convert to OEM codepage.
/OPEN=1 Open the output file after conversion.
/OPEN=0 Do not open the output file after conversion.
/BATCH Batch mode. Do not ask any questions (if possible).
/WAIT Do not close the software at the end. (Wait on the finish page).
/LOG Create a log file in a common repository for application-specific data.
A typical path is C:Documents and SettingsusernameApplication Data.

SQL specific parameters

Drive:PathFileName.dbf Source DBF file
Drive:PathFileName.sql
Drive:Path Target SQL file
Targer folder
/REMTRAIL=1 Remove trailing spaces in Character and Memo fields.
/REMTRAIL=0 Do not remove trailing spaces in Character and Memo fields.
/REMCRLF=1 Remove CR+LF in Memo fields.
/REMCRLF=0 Do not remove CR+LF in Memo fields.
/SINGLE Conclude character fields in single quotes.
/DOUBLE Conclude character fields in double quotes.
/ESCAPE=????? Escape character before a single or a double quote.
Examples:
/ESCAPE=#
"/ESCAPE=""
/FIELDNAMES=1 Use field names in the INSERT command.
/FIELDNAMES=0 Do not use field names in the INSERT command.
/SQL2000=0 Do not use SQL 2000 syntax in CREATE TABLE command.
/SQL2000=1 Use SQL 2000 syntax in CREATE TABLE command.
/SQL2000=2 Use MySQL syntax in CREATE TABLE command.
/SQL2000=3 Use PostgreSQL syntax in CREATE TABLE command.
/ADDGO=value Add the command GO between commands INSERT
If value is equal to zero then GO is not used.
/YYYYMMDD
/YYYY.MM.DD
/MM.DD.YYYY
/MM-DD-YYYY
/DD.MM.YYYY
/DD-MM-YYYY
/YYYY-MM-DD
Use this format for date fields.
/LOGICAL=0 Use 1 and 0 in logical fields
/LOGICAL=1 Use TRUE and FALSE in logical fields
/BRACKETS=0 Do not enclose fields names in square brackets.
/BRACKETS=1 Enclose fields names in square brackets. The license of this file & disk software is Free Trial Software, the price is $29.95, you can free download and get a free trial before you buy. If you want to get a full or nolimited version of DBF to SQL, you can buy this file & disk software.