DBF to SQL Converter 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. The program supports command line interface.
|
Downloads
| ZIP File | Description | Version | Size | |
| dbf2sql.zip | DBF to SQL Converter | 2.25 | 1170Kb | |
Ordering
| DBF to SQL Converter | Price |
| Personal license Allows you to use the program by one person only (at work or at home or both). |
$29.95 |
| Business license Allows you to use the program in business environment. |
$99 |
| Site license Allows you to use the program in business environment and besides it includes a DLL which you can use from your own application. |
$199 |
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 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. |
SQL specific parameters
| Drive:\Path\FileName.dbf | Source DBF file |
| Drive:\Path\FileName.sql | Target SQL file |
| /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. |
|
/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. |
| /ADDGO=value | Add the command GO between commands INSERT If value is equal to zero then GO is not used. |
| /LOGICAL=1 | Use TRUE and FALSE in logical fields |
| /LOGICAL=0 | Use 1 and 0 in logical fields |
| /BRACKETS=1 | Enclose fields names in square brackets. |
| /BRACKETS=0 | Do not enclose fields names in square brackets. |
