hk_dbcopy(1)

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 <[email protected]>

SEE ALSO

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