motorscript.com

dbf2sql – dbf to sql converter

Published:
dbf2sql converts dBase files to sql scriptsfor importing into MySQL Database.

Usage:

Extract files from the dbf2sql package. dbf2sql.php and dbf_class.php are the required files.
php dbf2sql.php input.dbf tablename output.sql
where input.dbf is the dbf file to be converted; tablename is the name of the table that the generated SQL script should insert rows into; output.sql is the output SQL script to be generated.

Only the input file argument is mandatory. The script is able to predict the table name and the output filename.

Examples:

php dbf2sql.php input.dbf myData
Since output file name isn’t given, myData.sql will be generated.
php dbf2sql.php data.dbf
This will create data.sql script that would create a table named data
php dbf2sql.php --bulk` OR `php dbf2sql.php --all
Converts all dbf files on current directory to sql scripts.