sqlite3-dbf - converter of XBase / FoxPro tables to SQLite
Sources for MinGW build Note: MEMO files does not supported because I don't know how to emulate mmap interface for MinGW
AboutSQLiteDBF converts XBase databases, particularly FoxPro tables with memo files, into a SQL dump. It has no dependencies other than standard Unix libraries.
This use codebase of the PgDBF project (http://pgdbf.sourceforge.net/) which designed to be incredibly fast and as efficient as possible.
$ sqlite3-dbf Usage: sqlite3-dbf [-m memofilename] filename [indexcolumn ...] Convert the named XBase file into SQLite format -h print this message and exit -m the name of the associated memo file (if necessary) sqlite3-dbf is copyright 2010 Alexey Pechnikov Utility based on source code of PgDBF (c) 2009 Daycos License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Report bugs to <firstname.lastname@example.org>
When terminal encoding is same to dBase file encoding the usage is very simple:
sqlite3-dbf test.dbf | sqlite3 test.db
In other causes are needed read the dBase file in his original encoding and convert SQL dump from dBase file encoding into terminal encoding.
Example for Cyrillic dBase files and UTF-8 console encoding:
LANG="ru_RU.CP866" sqlite3-dbf test.dbf | iconv -f cp866 -t utf8 | sqlite3 test.db