It's all about the answers!

Ask a question

CLM 502 upgrade - New RM database question

Mahari Hill (4861102218) | asked Jan 28 '15, 1:30 p.m.
edited Jan 28 '15, 1:30 p.m.
CLM 405 -> 502
SQL Server 2012

Talking with IBM, they mentioned that we would need a new DB for RM. We created the DB. (RM). Now l found the instructions (interactive) below which states you need to do a copy of the JTS to RM. Is this true and the only way? Do we have to delete our DB and do a copy?

Copy the Jazz Team Server database Back to top

Starting in version 5.0, the Requirements Management (RM) application uses its own database for data storage. In earlier versions, the RM data is shared with the Jazz Team Server database. To use your RM data, you must copy your existing Jazz Team Server database.

Be sure to make a note of your new RM database connection URL. When you run the RM script, you are prompted to enter the database location when you enter the JDBC location.

You can use the Copy Database Wizard to copy your Jazz Team Server database. You can also use the Wizard to upgrade your SQL Server 2008 to SQL Server 2012. Because CLM version 5.0.2 does not support SQL Server 2008, you must first upgrade to SQL Server 2012 before upgrading CLM applications.

Before you begin

  • You must be a member of the sysadmin fixed server role.
  • You must have the SQL Server Authentication user name and password.
  • Ensure that SQL Server Agent is started.


  1. In SQL Server Management Studio, in Object Explorer, expand Databases, right-click the JTS database, point to Tasks, and then click Copy Database.
  2. From the Select a Source Server page, enter the server and login information for the server with the JTS database to copy. Click Next.
  3. From the Select a Destination Server page, specify the location where the database will be copied. Click Next.
  4. From the Select a Transfer Method page, select the desired transfer method.
  5. From the Select Database page, select the JTS database to copy. Click Next.
  6. From the Configure Destination Database page, change the database name to RM.
  7. From the Select Database Objects page, select the objects to include in the copy operation. This page is only available when the source and destination are different servers.
  8. From the Location of Source Database Files page, specify a file system share that contains the database files on the source server. This is required if the source and destination server instances are on different computers.
  9. The Copy Database Wizard creates a SSIS package to transfer the database from the Configure the Package page, customize the package if appropriate.
  10. From the Schedule the Package page, select Run immediately to start the copy operation after you click Next.
  11. From the Complete the Wizard page, review the summary of the selected options. Click Back to change an option. Click Finish to create the database. During the transfer, the Performing operation page monitors status information about the execution of the Copy Database Wizard.

Accepted answer

permanent link
Erica Tran (1.4k6) | answered Jan 28 '15, 1:58 p.m.
If the new RM database created is empty, this will not work.  The reason for the copy of the JTS database is the RM data is in the JTS database in 4.x.  The upgrade steps require a copy so that the RM data will be in the database and can be upgraded with the remaining steps.
I hope this helps.
Mahari Hill selected this answer as the correct answer

Your answer

Register or to post your answer.