DBF Viewer 2000
DBF Viewer 2000 Online Help Prev Page Prev Page
Introduction
Hotkeys
Command line options
Working with dbf files
Opening DBF files
Creating New DBF file
Modifying dbf file structure
Viewing statistics
Import/Append records
Save As/Export
Working with records
Adding records
Editing records
Deleting records
Replacing records
Filling records
Sorting records
Searching and Filtering
Searching by criteria
Filtering records
How To
Export DBF to CSV
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Download DBF Viewer and Editor Top  Previous  Next

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.

 

dbf-to-sql

 

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

 

Free Download DBF Viewer and Editor

Updated Wed, 22 Nov 2017

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

Back to DBF Viewer 2000 Home

Copyright © HiBase Group, 2002-2017