CLM 606 Liberty change database from SQL 2014 to Oracle 12c
Hello Team,
we are planning to migrate SQL database to Oracle for CLM 606 (dev) distributed topology.
i understand from below link , how to do changes in termserver.propertes and create database and table into Oracle, but how find exact steps for how we can migrate CCM,JTS,QM ,RM database from SQL to oracle database.
Please guide on same.
Thanks
SD
|
Accepted answer
Hi Sunil,
Ralph Schoon selected this answer as the correct answer
Comments
Sunil Deshpande
commented Apr 09 '21, 7:01 a.m.
Thanks Adam..!
Sunil Deshpande
commented Apr 09 '21, 7:46 a.m.
Hi Adam,
Please review below steps as per our understand we have noted down them for Database migration from SQL to Oracle.
1.Stop Application(CLM 6.0.6) and Database server(SQL 2014).
2.Backup Application and Database server.
Oracle Database related
1. Install Oracle 12c
2. Need to create Database for each application ex:CCM,QM,JTS,RM(Same name As in SQL currently).
3. DB Password must be same as Current SQL.
# Do we need to create the DB Tables for each application?? or will take from Import export activity.
3.Run the repotools -addTables command.
4.Rebuild and reindex the index files for all installed applications: For Jazz Team Server:
5.Export your data to .tar file for each application:
6.Changes in Teamserver.properties and points to new Oracle DB for each application
7.Import the data from the .tar files by entering the repotools command.
8.Start Server
Thanks in advance.
Hi Sunil,
Sunil Deshpande
commented Apr 09 '21, 8:56 a.m.
Thanks Adam!! |
2 other answers
Ralph Schoon (63.5k●3●36●46)
| answered Apr 10 '21, 10:05 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Please note:
|
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.