It's all about the answers!

Ask a question

what all files to be updated while moving the SQL CLM databases from one server to another


anoop mc (75010149206) | asked Oct 08 '14, 11:06 a.m.
 Hi,
We are currently running CLM 4.0.6 (distributed topology) (jts+ccm+qm+rm) on separate servers
- Plan to migrate to CLM 5.0.1.
- Got to know that CLM 5.0.1 is not compatible with SQL 2008 R2 hence the DBA will be moving the databases to a different server running 2012 instance.
- Once the Databases are moved before running the upgrade scripts what all files need to updated with the new database server information (JDBC Location).  also the password details as well.

Note: Mostly the database server name will get changed.

Does this effect running the upgrade scripts ?   Based on the above scenario are there any best practices to be followed.

Accepted answer


permanent link
Erica Tran (1.4k6) | answered Oct 08 '14, 12:55 p.m.
JAZZ DEVELOPER
Hi Anoop,

The database connection string and password information is in the teamserver.properties file.   You will need to update this for all the applications.
<Install_directory>\JazzTeamServer\server\conf\<application>\teamserver.properties

Please note, in 4.x RM doesn't have it's own teamserver.properties file as it uses the JTS database.  Starting in 5.0, RM will require it's own database.  You will need to make a copy of the JTS database prior to running the upgrade scripts.  This is documented in the 5.0.1 interactive upgrade guide.

I hope this helps.


anoop mc selected this answer as the correct answer

Comments
anoop mc commented Oct 22 '14, 2:34 a.m.
cd RM_5.0.1_Install_Dir\server
repotools-rm.bat -migration_rm_updateConfigurationFiles oldApplicationHome=RM_4.0.6_install_dir\server\conf ignoreJTSVersionCheck

3 other answers



permanent link
Arun K Sriramaiah (3.2k12044) | answered Oct 08 '14, 1:41 p.m.

Hi Anoop,

Please find the link below for steps.

Migrating CLM to a New Environment
https://jazz.net/wiki/bin/view/Deployment/MigratingCLMToANewEnvironment

Regards,

Arun.


permanent link
anoop mc (75010149206) | answered Oct 09 '14, 10:59 p.m.
 One another clarification I would require is about the password information present in the teamserver.properties file.

com.ibm.team.datawarehouse.db.jdbc.password=[wXpx+K8Pp1WqhIZHiC9JRg\=\=]

com.ibm.team.repository.db.jdbc.password=[wXpx+K8Pp1WqhIZHiC9JRg\=\=]

If we keep the same password as we used in the previous should we be updating it again. Because the server name gets changed and we will have to update with the new details.

com.ibm.team.repository.db.jdbc.location=//<new Server Name>\\SQLA\:1433;databaseName\=RQM;user\=rqmDBuser;password\={password}

Comments
Erica Tran commented Oct 20 '14, 9:01 a.m. | edited Oct 20 '14, 9:02 a.m.
JAZZ DEVELOPER

If the password remains the same, the password in the teamserver.properties files does not need to change.  If you do need to change the password, you can type the password in plain text in the teamserver.properties file. 


permanent link
anoop mc (75010149206) | answered Oct 17 '14, 9:08 p.m.
 Hi,

Another question I have is - Here in our case the database server name changes (it will be different for CLM 501 when compared with the existing 406.

So what about copying the Table Space folder from the existing SQL Server instance (2008 R2) to SQL 2012.

Currently while configuring the JAZZ Application we have specified the table space folder location as 

Database Table Space Folder: W:\SQL01\MSSQL$SQLA\DATA\  

My question  here is do we need to copy all the data from the above location to the new table space location on SQL Server 2012 instance.

Comments
anoop mc commented Oct 22 '14, 2:32 a.m.

 Having tested this out from the SQL Server database side I can see the table space folder getting copied once we do a DB restore. 


It might change - How to find is to right click on the database folder and check the properties in the options you will find the tablespace folder path.

Your answer


Register or to post your answer.