hk_dbcopy1
Copies database elements between different database backends. hk_dbcopy is part of the hk_classes package
Usage
hk_dbcopy -d
driver
-b
database
--todriver
driver
--todatabase
database
[OPTIONS]
Overview
hk_dbcopy copies database elements between different database backends.
Examples
- 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
-lor--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.
Releases
Unchanged in 2 releases since Debian 4.0 (Etch).