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
Top  Previous  Next

Export DBF to MySQL

Download

Conventional DBF to MySQL converters often lack accuracy and backward compatibility. Slow, resource-hungry and providing inconsistent quality they can cause a lot of trouble. For instance: broken DBF structure, truncated fields, incomplete export of larger files and many other issues. Not to mention time wasted on such erroneous conversion.

Now look. There is a simpler option to transfer data from DBF databases to MySQL. You need DBF Viewer 2000, a tool that encompasses virtually everything you need to work with the DBF format. And that includes DBF-to-MySQL conversion too.

First, you open the DBF file the data from which you want to transfer

Second, you specify the output .sql file.

Then, DBF Viewer 2000 reads the source DBF, displays a preview and allows you to adjust exporting.

DBF to MySQL exporting

In this window, you can:

  • select fields in DBF to export to MySQL;
  • specify a range of records;
  • generate the command line;
  • export the database structure only;

Now, what about automation? Even better, you can run conversion using the command line executions and specify all the required options using the below command line parameters.

DBF to MySQL exporting via command line

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" /EXPORT:file1.dbf,file2.sql /mysql [/FILTER | /COLUMNS]

Examples:

Simple exporting

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe /EXPORT:file1.dbf,file2.sql /mysql

Exporting with selected columns

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" /EXPORT:file1.dbf,script.sql /mysql /columns:ID,NANE,SUM

 

Free Download DBF Viewer and Editor

Updated Wed, 22 Nov 2017

See also: DBF to CSV, DBF to XML, DBF to SQL, command line options, Filtering records in dbf file

Back to DBF Viewer 2000 Home

Copyright © HiBase Group, 2002-2017