It's all about the answers!

Ask a question

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


Brad Middleton (691910) | asked Feb 06 '13, 7:00 a.m.
JAZZ DEVELOPER
retagged Feb 08 '13, 5:55 p.m. by Amy Laird (16514)

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?

Accepted answer


permanent link
Ralph Schoon (55.1k23642) | answered Feb 06 '13, 7:12 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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

Comments
Ralph Schoon commented Feb 06 '13, 7:17 a.m. | edited Feb 06 '13, 7:17 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.


Amy Laird commented Feb 07 '13, 3:01 p.m.
JAZZ DEVELOPER

Your answer


Register or to post your answer.