This topic shows the steps to change the Jazz™ Team Server database
from Derby to SQL Server.
About this task
This assumes you are migrating the database and not changing
the version of your server at the same time. If you plan to migrate
and change the server version make sure you use the repotools version
that matches your target server.
Procedure
Stop the Jazz Team Server.
Backup the database using the database commands. This is
a precautionary measure in case something goes wrong.
In the directory JazzInstallDir/server/conf/jazz,
edit the file teamserver.sqlserver.properties to
ensure that the target properties accurately describe the SQL Server
database to which you are migrating. Review the contents of the file teamserver.properties and
copy over any necessary changes to teamserver.sqlserver.properties.
Run repotools to copy the contents of the Jazz repository
from the Derby database described by teamserver.properties to the
SQL Server database described by teamserver.sqlserver.properties.
The scripts, repotools.sh for Linux®,
and repotools.bat for Windows® are
packaged in the directory JazzInstallDir/server. The following is an example command using repotools. See the
repotools documentation for more information.