It's all about the answers!

Ask a question

Moving Database to different server


Amit Girme (1131927) | asked Jul 28 '15, 4:36 a.m.
 Hi,

I am planning to move SQL database from one server to different new sql server. Once database is moved to new server, so at the application end what all changes do i need to do in JTS,RTC and RQM so that it points to new database server and access the data from new database server.

Thanks in Advance


 

3 answers



permanent link
Ralph Schoon (63.1k33646) | answered Jul 28 '15, 4:48 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Please see https://www.google.com/search?q=migrate+database+to+different+server+site:jazz.net
Basically you have to look into the teamserver.properties file of the application that uses the DB and change the connection settings.

permanent link
Rohit Balduwa (945511) | answered Jul 28 '15, 4:48 a.m.

Hi Amit,

Sharing the links and steps in the below articles:

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

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 

Related jazz.net articles:

https://jazz.net/library/article/686
https://jazz.net/forum/questions/71215/clm-move-data-from-one-server-to-another

https://jazz.net/forum/questions/165129/what-all-files-to-be-updated-while-moving-the-sql-clm-databases-from-one-server-to-another

Please go through above information and let me know if you have any questions.

If this answers your question please mark it as accepted.

Regards,

Rohit



Regards,


permanent link
Francesco Chiossi (5.7k11119) | answered Jul 28 '15, 4:47 a.m.
edited Jul 28 '15, 4:47 a.m.
Hello Amit,

you can see the following threads with answers to your question:

what all files to be updated while moving the SQL CLM databases from one server to another
https://jazz.net/forum/questions/165129/what-all-files-to-be-updated-while-moving-the-sql-clm-databases-from-one-server-to-another

Moving CLM Database to a different DB server
https://jazz.net/forum/questions/202554/moving-clm-database-to-a-different-db-server

Best Regards,

Francesco Chiossi

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.