Home News Download Order Contacts Service CDBF for Windows CDBF for Windows (console) CDBF for DOS CDBF for Linux CDBFlite CDBFapi CDBFinfo CDBFShell CDBFview WhiteTown Wizards DBF to CSV DBF to MDB (Access) DBF to XLS (Excel) DBF to HTML DBF to SQL DBF to XML DBF to PDB (Palm DataBase) DBF to DBF MDB (Access) to DBF XLS (Excel) to DBF PDB (Palm DataBase) to DBF Subscribe to our mailing list: Reseller oportunities Affiliates Publications Other stuff WhiteTown.com WWW

DBF to SQL Converter DBF to CSV Converter Try also DBF to CSV (Comma-separated values) Converter. Download now! 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. There are several different SQL servers, but this program allows you to customize the output file. Currently it support MS SQL, MySql, PostgreSQL, etc. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats. The program supports command line interface. Besides, the Site license includes a DLL which you can use from your own application. Downloads ZIP File Description Version Size dbf2sql.zip DBF to SQL Converter 2.01 670Kb 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 ScreenShot 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 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. DBF to SQL Converter DLL ////////////////////// sample1.cpp //////////////////////////// //parameters in the command line // //sample1.exe source.dbf target.sql ... // #include int __declspec(dllexport) __stdcall DBFtoSQL_Converter(HWND hwnd, int argc, char *argv[]); int main(int argc, char *argv[]) { return DBFtoSQL_Converter(NULL, argc, argv); } // ////////////////////// sample1.cpp ////////////////////////////   ////////////////////// sample2.cpp //////////////////////////// //parameters in the source code // //sample2.exe // #include int __declspec(dllexport) __stdcall DBFtoSQL_Converter(HWND hwnd, int argc, char *argv[]); int main() { int n=0; char *params[10]; params[n++]=strdup(__argv[0]); params[n++]=strdup("source.dbf"); params[n++]=strdup("target.sql"); params[n++]=strdup("/ansi"); params[n++]=strdup("/overwrite=0"); return DBFtoSQL_Converter(NULL, n, params); } // ////////////////////// sample2.cpp ////////////////////////////

0.116790056229 ,	| Privacy policy | Copyright © 1996-2008, WhiteTown Software