hk_dbcopy

Langue: en

Version: 264984 (debian - 07/07/09)

Section: 1 (Commandes utilisateur)

NAME

hk_dbcopy - copies database elements between different database backends. hk_dbcopy is part of the hk_classes package

SYNOPSIS

hk_dbcopy -d driver -b database --todriver driver --todatabase database [OPTIONS]

DESCRIPTION

hk_dbcopy copies database elements between different database backends.

Example

hk_dbcopy -d sqlite3 -b exampledb --todriver mysql --touser MyUsername --topassword Secret --whole-database
This example will copy all elements of the SQLite database "exampledb" to Mysql

OPTIONS

-b, --database=DATABASE
database name
-d, --driver=DRIVERNAME
set the SQL-driver (e.g. mysql). You can get a list of all existing SQL-drivers with -l or --list
-h, --host=HOST
name or IP-number of the host
-l, --list
List available database drivers
-p, --password=PASSWORD
user password at the SQL server
-r, --port=PORT
TCP-port on host
--touser=USERNAME
user name at the target SQL server
--topassword=PASSWORD
user password name at the target SQL server
--todriver=DRIVERNAME
driver of the target SQL server
--tohost=HOST
name or IP-number of the target host
--toport=port
TCP-port on target host
--all-forms
copy all forms
--all-queries
copy all queries
--all-reports
copy all reports
--all-tables
copy all tables
--all-views
copy all views
--whole-database
copy all database objects
--form=FORM NAME
the name of a single form that should be copied
--query=QUERY NAME
the name of a single query that should be copied
--report=REPORT NAME
the name of a single report that should be copied
--table=TABLE NAME
the name of a single table that should be copied
--view=VIEW NAME
the name of a single view that should be copied
-u, --user=USERNAME
user name at the sql-server
--version
version and author of hk_classes

DIAGNOSTICS

hk_dbcopy returns 0 if everything was ok, or 1 if an error occured. A clear text error message will be written to stderr.

AUTHOR

Horst Knorr <hk_classes@knoda.org>

SEE ALSO

hk_actionquery(1), hk_exportxml(1), hk_importcsv(1), hk_report(1)