...
Usually more options are needed, especially --user, --password, and (Linux only, see bottom) --jdbc-drivers.
See far below for a full list of options, as well as examples for JDBC URLs.
...
| 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
- MySQL Tips
- MSSQL Tips
- JDBC Snippets with common JDBC URL examples