what all files to be updated while moving the SQL CLM databases from one server to another
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
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.
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.
4 other answers
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.
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}
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.
Hello
{Bump}
The same question for Version: 6.0.5
| Build Information | Version | Build ID |
|---|---|---|
| Jazz Foundation - Core Libraries | 6.0.5 |
RJF-SERVER-I20171103-1833
|
Anything else to be taken care of ?
- Changes in the Advance Properties
- Changes in the files <Install_directory>\JazzTeamServer\server\conf\<application>\teamserver.properties
Comments
This question is answered and accepted EIGHT years ago.
In this forum:
- Ask your own question
- Do not answer with a question in a question of another user, ever
You can look into the product documentation where server rename and backup are documented.
Sure. Ralph.
To avoid Duplicate, wanted to make use of the same / existing question.
Thanks