...
| 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> |
Extract parts of a DB
| 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)
| No Format |
|---|
--debug-startup |
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
...
See
- MySQL Tips
- MSSQL Tips
- JDBC Snippets with common JDBC URL examples