Migrating databases

Edit online

You can change the databases for Jazz® Team Server and all Engineering Lifecycle Management applications from one vendor to another.

Before you begin

You must have administrative privileges on the database server.
A supported version of a database that you are moving to must be installed. For a complete list of supported databases, see Hardware and software requirements for IBM Engineering Lifecycle Management.
If you plan to change your database and change the server version at the same time, you must first migrate the source database to the current version. To do so, use the repotools -addTables command.

About this task

Important: Use the repotools -export and -import commands only to change database vendors; for example, by changing from Oracle to Db2® . Do not use those commands to back up databases.

Procedure

Stop the servers that are running, which might include Jazz Team Server and the Engineering Lifecycle Management applications servers.
Back up the database by using the database commands.
Backing up the database is a precautionary measure in case something goes wrong. For instructions to back up, see your database documentation.
Rebuild and reindex the index files for all installed applications:
For Jazz Team Server:
1. Delete the JTS_install_dir/server/conf/jts/indices directory.
2. Open a command window and run the following commands to rebuild and reindex the index files:
```
cd JTS_install_dir/server
repotools-jts -rebuildIndices
repotools-jts -reindex all
```
For Change and Configuration Management application:
1. Delete the CCM_install_dir/server/conf/ccm/indices directory.
2. Open a command window and run the following commands to rebuild and reindex the index files:
```
cd CCM_install_dir/server
repotools-ccm -rebuildIndices
repotools-ccm -reindex all
```
For Quality Management application:
1. Delete the QM_install_dir/server/conf/qm/indices directory.
2. Open a command window and run the following commands to rebuild and reindex the index files:
```
cd QM_install_dir/server
repotools-qm -rebuildIndices
repotools-qm -reindex all
```
For Requirements Management application:
1. Delete the RM_install_dir/server/conf/rm/indices directory.
2. Open a command window and run the following commands to rebuild and reindex the index files:
```
cd RM_install_dir/server
repotools-rm -rebuildIndices
repotools-rm -reindex all
```
For Data Collection Component application:
1. Delete the DCC_install_dir/server/conf/dcc/indices directory.
2. Open a command window and run the following commands to rebuild and reindex the index files:
```
cd DCC_install_dir/server
repotools-dcc -rebuildIndices
repotools-dcc -reindex all
```
For Global Configuration Management application:
1. Delete the GC_install_dir/server/conf/gc/indices directory.
2. Open a command window and run the following commands to rebuild and reindex the index files:
```
cd GC_install_dir/server
repotools-gc -rebuildIndices
repotools-gc -reindex all
```
For IBM® Engineering Lifecycle Optimization Engineering Insights application:
1. Delete the ENI_install_dir/server/conf/relm/indices directory.
2. Open a command window and run the following commands to rebuild and reindex the index files:
```
cd ENI_install_dir/server
repotools-relm -rebuildIndices
repotools-relm -reindex all
```

Export your data to .tar file for each application:

JTS_install_dir/server repotools-jts -export toFile=JTSData.tar
CCM_install_dir/server repotools-ccm -export toFile=CCMData.tar
QM_install_dir/server repotools-qm -export toFile=QMData.tar
RM_install_dir/server repotools-rm -export toFile=RMData.tar
DCC_install_dir/server repotools-dcc -export toFile=DCCData.tar
GC_install_dir/server repotools-gc -export toFile=GCData.tar
ENI_install_dir/server repotools-relm -export toFile=ENIData.tar

Create separate databases for Jazz Team Server and the Engineering Lifecycle Management applications.
For information about creating databases, see these resources:
- Setting up a Db2 database
- Setting up an Oracle database

In each of the teamserver.properties files, find the sections that are in the following table. Reference the new database by commenting out your existing database and removing the comments (#).

Note: If you already set up your server, the original content of the teamserver.properties file is saved in a new file; for example, teamserver-1340753205409backup.properties.

Table 1. Database configuration property
Database	Section to remove comments from	More information
Db2	Db2 configuration	Manually configuring a Db2 database
Oracle	Oracle configuration	Manually configuring an Oracle database

Import the data from the .tar files by entering the repotools command.

JTS_install_dir/server repotools-jts -import fromFile=JTSData.tar
CCM_install_dir/server repotools-ccm -import fromFile=CCMData.tar
QM_install_dir/server repotools-qm -import fromFile=QMData.tar
RM_install_dir/server repotools-rm -import fromFile=RMData.tar
DCC_install_dir/server repotools-dcc -import fromFile=DCCData.tar
GC_install_dir/server repotools-gc -import fromFile=GCData.tar
ENI_install_dir/server repotools-relm -import fromFile=ENIData.tar

Start the servers.