Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

CLM 4.0.6 Database Migration from SQL server 2008 to 2012 change of server

Questions
Tags
Users
Badges
Marinept Villalobos
(47●21●31) Jun 10 '15, 4:10 p.m.
Hello,
We plan to do an upgrade of the CLM database server from Microsoft Sql Server 2008 R2 to Microsoft Sql Server 2012.
The version of CLM is 4.0.6 (RTC,RQM) is installed in a single application server and the database is located in another server.
We want to move the current database to the new server. Is there anything else needed besides the repotools scripts and reindexing the database?
We are concerned about the IP address and the database name change.

0 votes

1 answer
3,550 views
0 votes

Accepted answer

Permanent link
Rafael Rodriguez Montes
(230●13●130●258) Jun 10 '15, 7:42 p.m.
Hello Villalobos, 

 Export your DB thro full back-ups and re-store them in 2012, should be transparent for RTC, and change the configuration files where you are pointing the databases located on JTS home folder in: 

jtsinstalled\server\conf\app(ccm,jts,qm,rm)\teamserver.properties  

and Ensure that the config files are pointing to the new database server(2012) before start the server.
Marinept Villalobos selected this answer as the correct answer

0 votes

Comments
Marinept Villalobos
Jul 06 '15, 10:40 a.m.

 Thanks for the feedback, it was easier than I thought.

Your answer

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

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,498
× 2,357
× 82

Question asked: Jun 10 '15, 4:10 p.m.

Question was seen: 3,550 times

Last updated: Jul 06 '15, 10:40 a.m.

Confirmation Cancel Confirm