It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,858
×10,951
×7,450
×4,309
×3,954
×2,348
×1,381

question asked: Feb 06 '13, 7:00 a.m.
question was seen: 4,806 times
last updated: Feb 08 '13, 5:55 p.m.

Related questions

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

0
Brad Middleton (69●1●10●10) | asked Feb 06 '13, 7:00 a.m.
JAZZ DEVELOPER
retagged Feb 08 '13, 5:55 p.m. by Amy Laird (165●1●4)

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

0
permanent link
Ralph Schoon (63.3k●3●36●46) | 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

Here is a link to the help topic that Ralph refers to:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/topic/com.ibm.jazz.install.doc/topics/t_server_rename_change_dbvendor.html

Your answer

Register or 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.