It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×4,693
×1,214
×267
×118

question asked: Oct 19 '20, 4:43 a.m.
question was seen: 789 times
last updated: Oct 19 '20, 11:37 a.m.

Related questions

FAQ - How this Forum works

CLM Upgrade - DB import/export & Rebuilding indices

0
Amit Girme (11●3●19●27) | asked Oct 19 '20, 4:43 a.m.
edited Oct 19 '20, 11:37 a.m. by Ralph Schoon (63.1k●3●36●46)

Hello Team,


We are planning to change the database from MSSQL 2012 to Oracle 19 of CLM (6.0.6.1) for better performance and upgrade the ELM environment to 7.0.1. 

In order for better estimates need some inputs from folks who have already performed these activities.
  1. How long will it take to export the data of 2 TB size from MSSQL 2012
  2. How long will it take to import the same data of 2 TB to Orcale 19
Rebuilding the incidces is also an mandatrory part of the upgradation process, Any rough estimates to process below data size will be helpfull:
  1. RM DB size : 400 GB
  2. CCM DB Size: 800 GB
Note: Each server CCM,RM and Database server has 64GB of RAM 

Please let me know if you need any addtional details.

Thank you in Advance

Regards,
Amit G

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered Oct 19 '20, 11:28 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Oct 19 '20, 11:29 a.m.
Amit, you really, really want to clone and server rename your current environment into an isolated test setup and then test the upgrade/the DB migration.

You want to do that for the following reasons
  1. Create a documented step by step description
  2. Find issues and how to deal with them before you try a productive upgrade
  3. Test the process against your data and be able to test everything works fine.
  4. Understand the time involved e.g. DB migration, upgrade, reindex etc.
I have no numbers for your sizes above and I understand that there are very different numbers for different users because of the data types and versions involved.
Comments
Ralph Schoon commented Oct 19 '20, 11:29 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
See

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.