Exporting database connection information to an XML file with a wizard

You can use a wizard to export information from multiple database connections to an XML file, which can be used to repopulate the Data Source Explorer in a new workspace.
Prerequisite: Before you can export database connection information to an XML file, you must create a connection to a database in the Data Source Explorer.

Using this method, you can export multiple database connections at the same time, and you can include user ID and password information in the XML file. After you generate the XML file, you can populate the Data Source Explorer in a new workspace by specifying the path to this XML file on the Administrative Options page in the Preferences window.

To export database connection information to an XML file by using a wizard:

  1. Click File > Export.
  2. In the Export wizard, expand Data and select Database Descriptors, then click Next.
  3. On the Choose Connections page, select which connections you want to export and select options for the export. You can choose whether to include user ID and password information, and where to store the XML file.
  4. Click Finish.
  5. In the window that opens, browse to the folder on the local file system in which you want to save the XML file, specify a name for the file, and click OK.
The XML file that you specified is saved in the folder that you specified. One XML file is created for each database connection. An XML schema file called DBDescriptor.xsd is saved to the same folder. The following example shows the type of information that is saved in the XML file:
<database xmlns:tns="DBDescriptor" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" conName="SAMPLE" dbName="SAMPLE" defProduct="DB2 UDB" defVersion="V8.2" driverClass="com.ibm.db2.jcc.DB2Driver" driverPath="C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.datatools.db2_1.0.100.v200703190751\driver\db2jcc.jar;C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.datatools.db2_1.0.100.v200703190751\driver\db2jcc_license_cisuz.jar" identifierDelimiter=""" prodVersion="SQL08025" url="jdbc:db2://localhost:50000/SAMPLE" xsi:schemaLocation="DBDescriptor.xsd">
<property key="user" value="user" />
<property key="retrieveMessagesFromServerOnGetMessage" value="true" />
<variable key="jdklocation" value="" />
<variable key="jdklevel" value="" />
<variable key="wlmEnvironment" value="" />
<variable key="runTimeOptions" value="" />
</database>
Related information
Overview of database connections

Feedback