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)
hk_classes package hk_dbcopy(1)