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

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

permanent link

Ralph Schoon (62.3k●3●36●43) | 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

It's all about the answers!

Related questions

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

Accepted answer

Your answer