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

CLM 606 Liberty change database from SQL 2014 to Oracle 12c

Questions
Tags
Users
Badges
Sunil Deshpande
(13●1●12) Apr 08 '21, 6:25 a.m.

 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

0 votes

3 answers
1,662 views
0 votes

Accepted answer

Permanent link
Adam Rabčan
(45●3) Apr 09 '21, 6:43 a.m.

 Hi Sunil,

After you run -rebuildIndices and -reindex all you then continue with exporting the database to .tar files.
Once you have exported all the databases, change the database configuration settings in teamserver.properties of jazz.
Oracle DBs should already be set up and configured properly.
Now, you will run repotools -import  from the previously exported .tar DB files. This action takes the data from the file and inserts them into the Oracle Database according to your changed settings in teamserver.properties.
If data architecture needs to be changed because of different DB vendor, the previous command does it all.


Ralph Schoon selected this answer as the correct answer

0 votes

Comments
Sunil Deshpande
Apr 09 '21, 7:01 a.m.

Thanks Adam..! 

Sunil Deshpande
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.

Adam Rabčan
Apr 10 '21, 10:08 a.m.

 Hi Sunil,

DB password may be changed if needed (you can edit it in temaserver.properties)
Yes, you need to create DB tablespace (not tables) in Oracle server before running the import.

Do not run -addTables command, the -import proccess will do it instead.

All other points are correct.

HINT: After you reconfigure teamserver.properties with new DB configuration you may run repotools -verify  command to check if the applciation is able to communicate with new database.

Please check this short article describing moving DNG database from Derby to Oracle in more detailed way. I think it woud help you (the process is the same for other databases): https://jazz.net/wiki/bin/view/Deployment/MigratingDNGDBFromDerby2Oracle

In case you need direct support with anything related to Jazz, you can find us at www.softacus.com :)

Sunil Deshpande
Apr 09 '21, 8:56 a.m.

Thanks Adam!! 

2 other answers

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Apr 10 '21, 10:05 a.m.
Please note:

  1. The export and the import can be very time consuming.
  2. Setup  an isolated test system and test the procedure to find out you do it right and get a baseline for how long it takes.

0 votes

Permanent link
Vijay Panari
(11●1●5) May 25 '21, 8:21 a.m.

 Hello Ralph,


Is there any other way we can migrate SQL DB to Oracle DB. 

Thanks 
Vijay P

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 25 '21, 8:24 a.m.

If you want to ask a question, ask a new question. 

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,495
× 1,325

Question asked: Apr 08 '21, 6:25 a.m.

Question was seen: 1,662 times

Last updated: May 25 '21, 8:24 a.m.

Related questions
Confirmation Cancel Confirm