Export DBF to MySQL
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.
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]
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
Updated Wed, 30 May 2018
also: DBF to CSV, DBF to XML, DBF to SQL, command line options,
Filtering records in dbf
Back to DBF Viewer 2000 Home
Copyright © HiBase Group, 2002-2018