It's all about the answers!

Ask a question

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


Sunil Deshpande (11) | asked Apr 08, 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

Accepted answer


permanent link
Adam Rabčan (26) | answered Apr 09, 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

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

Thanks Adam..! 


Sunil Deshpande commented Apr 09, 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 commented Apr 09, 8:15 a.m. | edited Apr 10, 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 commented Apr 09, 8:56 a.m.

Thanks Adam!! 

2 other answers



permanent link
Ralph Schoon (58.4k23642) | answered Apr 10, 10:05 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.

permanent link
Vijay Panari (113) | answered May 25, 8:21 a.m.

 Hello Ralph,


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

Thanks 
Vijay P


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

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


Your answer


Register or to post your answer.