Changing a database system for a Rational Connector 4.0 database

Use the repotools utility to change the Rational® Connector 4.0 database.

About this task

You can use the repotools utility to move your Rational Connector 4.0 database from one database system to another. Loading data from an XML file into a 1.0 database is not supported.

Procedure

The paths and commands in the procedure depend on the installation root directories and the operating systems.

  1. Follow the directions about setting up a database to prepare the new vendor database instance.
  2. Shut down Rational Connector 4.0.
  3. Go to the server directory under the Rational Connector 4.0 connector installation root directory.

    % cd /opt/IBM/SapConnector/server

  4. Set the SAPC_HOME environment variable to the Rational Connector 4.0 server/conf installation root directory.

    % setenv SAPC_HOME /opt/IBM/SapConnector/server/conf

  5. Put the Rational Connector 4.0 database to a temporary file.

    % ./repotools.sh dump -file /usr/tmp/conn4.0db.xml -fromSchema 4.0

  6. Open the sapconnector.properties file that is located in the Rational Connector 4.0 server/conf installation root directory and edit the entries that are related to the database system.
  7. Load the XML file that you created in step 5 to a Rational Connector 4.0 database.

    % ./repotools.sh load -file /usr/tmp/conn4.0db.xml -fromSchema 4.0


Feedback