SQLite2DBF

convert an sqlite database-table to FoxBase (dBase)

SYNOPSIS

sqlite2dbf -s [SQLite-file] [options]

or

sqlite2dbf [Common options]

DESCRIPTION

You can use a variety of graphical user interfaces, notably those which support the SQL language, to create and maintain SQLite databases. The same is no longer true for dBase, a database format which is considered outdated, nowadays. However, the file-format is still in use in some contexts.

With sqlite2dbf you can convert one table at a time from an SQLite database into a dbf-file (in FoxBase format) and so benefit from the available GUI-interfaces, without risking incompatibilities, where a dBase-file is needed.

OPTIONS

-s, --source [PATH] SQLite-file to read.

-c, --config [PATH] Configuration file for this transformation

-n, --name [TABLE] The name of the table from the SQLite-database to convert

-t, --target [PATH] Path to the dBase-file to be written.

-l, --list Show the list of available tables and exit

-o, --out [PATH] Use the table-name as file-name for the DBF-result, store output in PATH

--time [list] Fields (table-columns) which shall be handled as timestamp values.

--date [list] Fields (table-columns) which shall be handled as date-time values.

Common Options

-d, --debug Show debug-messages

-h, --help Show this message

-v, --version Show version and program information

EXAMPLES

List available tables in a SQLite database:

sqlite2dbf --list -s database.sqlite

Transform a table from the database to dBase, the resulting file will be named after the table:

sqlite2dbf -s database.sqlite --name table

Transform a table from the database to dBase, write the result to the target-file:

sqlite2dbf -s database.sqlite --name table -t /directory/file.dbf

Transform a table from the database to dBase, put the result in a named directory:

sqlite2dbf -s database.sqlite --name table -o /directory

Transform a table from the database to dBase, handle the named fields as dates:

sqlite2dbf -s database.sqlite --name table --date "expired last_accessed"

As before but be verbose:

sqlite2dbf -s database.sqlite --name table --date "expired last_accessed" -d

Use a user-defined configuration from config.txt for this transformation:

sqlite2dbf -c /home/user/sqlite2dbf_config.txt

As before but overwrite the path to the source-file:

sqlite2dbf -c /home/user/sqlite2dbf_config.txt --source base.sqlite

ERRORS and WARNINGS

sqlite2dbf does not return error-codes but writes errors and warnings to STDOUT. This mainly concerns cases, where a data-type from the SQLite-database cannot be converted for use in the dBase-file, probably when date- and/or time-fields are listed on the command-line. Please contact the author, if these issues seriously obstruct your work with sqlite2dbf. The converter should in any way create a useable dBase-file.

SOURCE CODE and DEVELOPMENT

sqlite2dbf is developed in Ruby and can be installed as a Ruby-Gem. As Ruby is an interpreter-language, the source-code of the installed version is always accessible. You can also decompress the gem-file to take a look at the code.

AUTHOR:Michael Uplawski <michael[dot]uplawski[at]uplawski[dot]eu>