Clarity

Expand all | Collapse all

Steps to migrate data from one clarity env to other clarity env?

Jump to Best Answer

Robert_Ensinger11-25-2014 06:49 PMBest Answer

  • 1.  Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:00 AM

    Hello experts,

    What are all the basic methods that we should uphold to migrate/refresh the data from one clarity env to other env.

    Curious to know the end-to-end steps and best practices invloved in migrating the data/refresh from one clarity env to other env.(Say from PROD to DEV of same version/different version)

    Waiting eagerly for your comments!

     

    Regards,

    Naga



  • 2.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:33 AM

    Hi Naga,

     

    Xog is the best way to do it in my opinion which maintains the data integrity

     

    Regards

    Suman Pramanik



  • 3.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:42 AM

    Hey Suman,

    Thanks for ur reply.

    I agree to ur point xog would be best way to do it, since it will take care of many unknown background process which are hindered for normal users.

    Xogging out an custom object from one env and xogging in to other env is always a best option.

    But think of just data, imagine that i have close to 1million records related to investments stored in oracle DB(inv_investments,etc..) in OOTB clarity env and i wanted to move it from PROD to DEV, do we have any handy method to move this big volume of data?...

     

    Regards,

    Naga



  • 4.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:44 AM

    Have you checked this thread ?

     

    https://communities.ca.com/message/241697482#241697482

     

    NJ



  • 5.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:48 AM


  • 6.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:50 AM


  • 7.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:56 AM

    Backup Clarity data and restore it to different server

    https://communities.ca.com/message/2294410#2294410

     

    NJ



  • 8.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-25-2014 03:47 AM

    Hi Naga,

     

    Why would you need to migrate from one clarity to other rather upgrade the system and they will take care. Data movement from one environment from other remains tedious and again xog is the best way forward and in 13.3 you have xml node configuration which will save you from out of memory issues.

     

    Regards

    Suman Pramanik



  • 9.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-26-2014 04:54 AM

    Hey Suman,

    To support development activities based on the data in PROD, we wanted to back up data from PROD to Dev.

     

    Regards,

    Naga



  • 10.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-26-2014 04:57 AM

    Hi Naga,

     

    If its same version then you can refresh the database from prod to dev if its samea version and take the back up of all the new customization/configurations.

     

    Regards

    Suman Pramanik



  • 11.  Re: Steps to migrate data from one clarity env to other clarity env?
    Best Answer

    Posted 11-25-2014 06:49 PM
      |   view attached

    Here's a redacted version of what we do.

    Attachment(s)



  • 12.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-26-2014 12:55 AM

    I have recently migrated configuration/data from clarity SQL Server to Clarity Oracle server by using XOG (around 300 GB data). But time lines is little bit high.



  • 13.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-26-2014 01:04 AM

    Here is another post detailing the challenges for 13.3

     

    https://communities.ca.com/message/241705178#241705178

     

    Have you tried reaching out to the CA Services Global Delivery team for the Data Migration tool ?

     

    NJ



  • 14.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-26-2014 05:01 AM

    Thank you all ur thoughts.

    As we are in oracle DB enterpise ed, suggestion from DBA was to go with database backup and recovery using RMAN

     

    Regards,

    Naga



  • 15.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-26-2014 06:57 AM

    HI Naga,

     

    That should be ok, its better to go with cold back up.

     

    Regards

    Suman Pramanik



  • 16.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 11-27-2014 07:28 AM

    Hi Senthi,

     

    We have plan to move from Oracle  to SQL Server in near future due to company policies. Approximately how much time you have spent in this activity.

    Our Current Version is Clarity 8 with Oracle 9i

    Target version is Clarity 14 with SQL Server 2014

     

     

    -Gurjeet



  • 17.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 12-08-2014 05:51 AM

    Time line will be based on size of DB & documents.



  • 18.  Re: Steps to migrate data from one clarity env to other clarity env?

    Posted 12-09-2014 02:35 PM

    Also on how much custom items, custom configuration, add ons and customization and may vary between organization and quality of plan.

    See also

    Upgrade strategy for 13.0.1.6 to 14.1

    for steps you might have not thought of.