...
| No Format |
|---|
jdbc2xml --url <jdbc-url> --user <jdbc-user> --password <jdbc-password> --file <path-to-file> |
See below for details and example for JDBC URLs.
...
| No Format |
|---|
xml2jdbc --file <path-to-file> --url <jdbc-url> --user <jdbc-user> --password <jdbc-password> |
Copying from one DB to another
| No Format |
|---|
jdbc2jdbc --from-url <jdbc-url> --to-url <jdbc-url> --user <jdbc-user> --password <jdbc-password> |
Parse and copy an XML file
...
| No Format |
|---|
jdbcping --url <jdbc-url> --user <jdbc-user> --password <jdbc-password> |
| No Format |
|---|
jdbcextr --url <jdbc-url> --user <jdbc-user> --password <jdbc-password> --file <path-to-file> |
JDBC URLs
...
Activate loggers in wrapper scripts (only useful if you know what you're doing)
Driver packages and paths, and other Backend specific tips
MySQL-Driver
| No Format |
|---|
apt-get install libmysql-java
jdbc2xml ... --jdbc-drivers /usr/share/java/mysql-connector-java.jar |
MSSQL-Driver
| No Format |
|---|
apt-get install apache-karaf-mssql
jdbc2xml ... --jdbc-drivers /usr/share/apache-karaf/lib/sqljdbc4.jar |
Typical special options
MSSQL
| No Format |
|---|
# MSSQL likes to create system tables which should not be exported or imported
jdbc2xml ... --exclude-tables sysdiagrams,trace_xe_event_map,trace_xe_action_map |
See