| /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. |
| Drive:\Path\FileName.dbf | Source DBF file |
Drive:\Path\FileName.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. |
| /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="" |
