Export DBF to SQL

To export a dbf file to sql script, open File | Save as/Export menu, and select file type: SQL.

Export to dialog box opens. Select the fields to be exported and specify their order using up and down arrows.

Select the SQL format from the list (Oracle, MySQL, MS SQL, PostgreSQL)

DBF to SQL exporting via Command Line

"c:\Program Files\DBF Viewer 2000 (x86)\dbview.exe" dbffile /EXPORT:sqlfile [/MYSQL | /ORACLE | /MSSQL | /POSTGRESQL ] [/NOCREATESTATEMENT] [/INSERTWITHCOLUMNS] [/COLUMNS] [/FILTER] [/WFILTER]

examples:

Export DBF to MySQL

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /mysql /COLUMNS:ZIP,NAME,ADDR

Export DBF to MS SQL

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /mssql

Export DBF to Oracle with wide filter option

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /oracle /wfilter:alaska

Export DBF to PostgreSQL

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /postgresql

Inserting Columns Names

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:myscript.sql /mysql /INSERTWITHCOLUMNS

Export to MySQL with Wide filter

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /mysql /wfilter:smith

See also: dbf to xls, command line options, Filtering records in dbf file

Page top | Contacts | Copyright © HiBase Group, 2002-2021