JDBC2XML Usage

= {{id name="JDBC2XMLUsage-JDBC2XMLUsage"/}}JDBC2XML Usage =

This section refers to the command-line tool. For information on the uses of the java library, please refer to our [[java documentation>>doc:JDBC2XML.Java Library Documentation.WebHome]].

4

5

=== {{id name="JDBC2XMLUsage-Aliases"/}}Aliases ===

6

7

JDBC2XML registers under several aliases on the command line, to cover the most common usecases. They are presented here with minimal options, see a full list of options below.

8

9

==== {{id name="JDBC2XMLUsage-DumpingaDBtoXML:"/}}Dumping a DB to XML: ====

10

11

12

jdbc2xml --url <jdbc-url> --file <path-to-file>

13

14

15

==== {{id name="JDBC2XMLUsage-RestoringaDBfromXML:"/}}Restoring a DB from XML: ====

16

17

18

xml2jdbc --file <path-to-file> --url <jdbc-url>

19

20

21

==== {{id name="JDBC2XMLUsage-CopyingfromoneDBtoanother"/}}Copying from one DB to another ====

22

23

24

jdbc2jdbc --from-url <jdbc-url> --to-url <jdbc-url>

25

26

27

==== {{id name="JDBC2XMLUsage-ParseandcopyanXMLfile"/}}Parse and copy an XML file ====

28

29

This can be useful for extracting a schema from a database (see options below)

30

31

32

xml2xml --from-file <path-to-file> --to-file <path-to-file>

33

34

35

==== {{id name="JDBC2XMLUsage-TestDBconnectionandserverstatus"/}}Test DB connection and server status ====

36

37

38

jdbcping --url <jdbc-url>

39

40

41

==== {{id name="JDBC2XMLUsage-ExtractpartsofaDB"/}}Extract parts of a DB ====

42

43

44

jdbcextr --url <jdbc-url> --file <path-to-file>

45

46

47

=== {{id name="JDBC2XMLUsage-Fulllistofoptions"/}}Full list of options ===

48

49

==== {{id name="JDBC2XMLUsage-Databaseaccess"/}}Database access ====

50

51

JDBC URL to access the DB (like jdbc:servertype:~/~/host[:port]/db[?options]):

--from-url "jdbcurl"

--to-url "jdbcurl"

--url "jdbcurl"

User to access the DB (some drivers can parse that from the URL):

--from-user user

--to-user user

--user user

Password to access the DB (some drivers can parse that from the URL):

69

70

71

--from-password password

72

--to-password password

--password password

==== {{id name="JDBC2XMLUsage-Fileaccess"/}}File access ====

77

78

Win32 wrapper needs absolut paths. The given filenames may contain compressed input. The implementation instantiates an appropriate inflating/deflating stream if the filename ends with .gz or .bz2

--from-file file

--to-file file

--file file

==== {{id name="JDBC2XMLUsage-Restrictprocessingtotables"/}}Restrict processing to tables ====

87

88

Whitelist tables (comma seperated, without whitespace)

89

90

91

--tables table1,table2,...

Blacklist tables

--exclude-tables table1,table2,...

98

99

100

Do not include table data in dump (creates a full schema from a populated database):

--no-data

Ignore constraints

--no-constraints

Combined{{code language="none"}}--no-data{{/code}} and {{code language="none"}}--no-constraints{{/code}}

--schema-only

==== {{id name="JDBC2XMLUsage-Expertoptions"/}}Expert options ====

119

120

Drop the affected tables before actually importing a dump. If {{code language="none"}}--tables{{/code}} or {{code language="none"}}--exclude-tables{{/code}} is given, only tables affected by the specified filter are dropped.

--drop-tables

Overrides the default bzip2 output compression, if {{code language="none"}}--to-file{{/code}} ends with .bz2

--compression <n>

Force a timezone

--timezone timezoneid

136

137

138

allows to select a JDBC driver, overriding autoselection

139

140

141

--from-driver drivername

142

--to-driver drivername

--driver drivername

linux only: add given drivers to the classpath

147

148

149

--jdbc-drivers jarfilename[;jarfilename...]

150

151

152

==== {{id name="JDBC2XMLUsage-Optionsfortranslationtojdbc"/}}Options for translation to jdbc ====

153

154

Change the batch size for inserts (def.: 1000)

--batch-size n

Fetch the contents of the database using a read-only transaction

--transactional

==== {{id name="JDBC2XMLUsage-Optionsfortranslationfromxml"/}}Options for translation from xml ====

167

168

Enable schema checking on the xml file

--check-xml-schema

Create an extra index on each foreign key

--create-fk-indices

==== {{id name="JDBC2XMLUsage-Optionsfortranslationtoxml"/}}Options for translation to xml ====

181

182

Force or supress pretty printing of xml data

183

184

185

--pretty, --no-pretty

186

187

188

Forces the transformation of SQL identifiers to lower case

--to-lower

Force the transformation of SQL identifiers to upper case

--to-upper

Write internal indices, which are generated by the RDBMS

201

202

203

--keep-internal-indices

204

205

206

==== {{id name="JDBC2XMLUsage-OutputVerbosity"/}}Output Verbosity ====

207

208

The default log level prints {{code language="none"}}Fatal{{/code}}, {{code language="none"}}Error{{/code}} and {{code language="none"}}Warning{{/code}} logs

209

210

Suppresses any output except for the return code

--quiet

Increase log-level to {{code language="none"}}Info{{/code}}

217