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:
<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>