NAME
sql2dbf - Generate xBase-style .dbf-files from SQL-tables
SYNOPSIS
msql2dbf [options] dbf-file
Options:
[-v[v]] [-u | -l] [-d database] [-t table] [-h host] [-d] [-q query] [-p precision]
DESCRIPTION
This manual page documents the program msql2dbf. This takes a table, and writes out an xBase-style .dbf-file with the contents of that table.
OPTIONS
- -v
-
Display some status-messages.
- -vv
-
Also display progress.
- -u
-
Convert the contents of all fields to uppercase.
- -l
-
Convert the contents of all fields to lowercase.
- -d database
-
Specify the database to use. An error is returned if this database does not exists. Default is "test".
- -t table
-
Specifies the table to select from. An error is returned if this database does not exists. Default is "test".
- -h host
-
Specify the host to which to connect. Default is "localhost".
- -q
-
Specify a custom query to use to fetch the data out of the table (or tables).
- -p precision
-
Specify the precision to use in the case of a REAL field. This is the part after the decimal point.
ENVIRONMENT
These programs are effected by the environment-variables as used by mSQL. See the documentation of mSQL for more information on this.
BUGS
At the moment none that I know, except for some lacking functionallity.
AVAILABILITY
You can get the latest version by anonymous FTP from ftp.nerosworld.com/pub/msql/contrib/dbf2msql