Command line interface DBF to SQL Converter
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). |
| /SILENT | Batch mode. The program does not display any windows. |
| /WAIT | Do not close the program 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 Settings\username\Application Data. |
| /STATUS /STATUS=filename.ext | Create a text file with a current status (Conversion In Progress, Successful, Failed, Cancelled etc). By default: %Program dir%\status.log |
| /FILTER=condition | It allows you to convert records which satisfy the condition. |
SQL specific parameters
| Drive:\Path\FileName.dbf | Source DBF file |
| Drive:\Path\FileName.sql Drive:\Path\ | Target SQL file Targer folder |
| /STRUCTURE=1 | Export structure of the table. |
| /STRUCTURE=0 | Do not export structure of the table. |
| /INFORMATION=1 | Export information from the table. |
| /INFORMATION=0 | Do not export information from the table. |
| /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. |
| /REMCRLF=2 | Replace CR+LF to \r\n |
| /DOUBLE | Conclude character fields in double quotes. |
| /SINGLE | Conclude character fields in single quotes. |
| /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 /MM/DD/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. |
| /ESCAPE=????? | Escape character before a single or a double quote. Examples: /ESCAPE=# "/ESCAPE="" |
