...
| 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
...
| No Format |
|---|
# MySQL
jdbc:mysql://localhost:3306/MYDATABASE?useCursorFetch=true
# MSSQL
jdbc:sqlserver://localhost:1433;databaseName=MYDATABASE; |
The use of cursor fetching in mysql is highly recommended in order to circumvent java heap space exceptions while dumping the content of large tables.
Full list of options
Database access
...
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
See
...
...
apt-get install libmysql-java
jdbc2xml ... --jdbc-drivers /usr/share/java/mysql-connector-java.jar- MSSQL Tips
- JDBC Snippets with common JDBC URL examples