Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is there an impact on changing the default database names for clm?

Can I change the database names to have a prefix of ‘Rational_ on SQL Server. So they would be the following:

  • Rational_RICM
  • Rational_CCM  
  • Rational_QM
  • Rational_RM
  • Rational_JTS
Is there an impact of doing this on future upgrades?

0 votes


Accepted answer

Permanent link
Hi Brad,

as far as I can tell, no. From a Jazz perspective, you can name the DB as you like, as long as the user permissions don't change. If you rename them afterwards, make sure to adjust the connection strings in the teamserver.properties for the DB's you renamed.
Brad Middleton selected this answer as the correct answer

0 votes

Comments

With respect to upgrade:

I was assuming you may be able to rename the DB in the DBMS tools. In this case you could do the rename independent of any upgrade. In general use the tools that come along the DBMS.

If you are forced to do a repotools -export/-import during an upgrade that would be a chance to create new databases and change the connection string before doing the rename. This case is similar to the scenario of changing the DB vendor that is described in the documentation.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,495
× 2,357
× 1,381

Question asked: Feb 06 '13, 7:00 a.m.

Question was seen: 4,955 times

Last updated: Feb 08 '13, 5:55 p.m.

Confirmation Cancel Confirm