Knowledge Management

Get Involved. Join the Conversation.

Topic

    keerthi P
    Migrate answers from one OSC isntance to another
    Topic posted February 16, 2018 by keerthi PSilver Medal: 2,000+ Points 
    111 Views, 3 Comments
    Title:
    Migrate answers from one OSC isntance to another
    Content:

    Hello

    In one of the implementation we need to migrate answers from one OSC instance to another..?

    Do Oracle provide any such facility to do it internally at the instance level. 

    Has anybody done such migration where oracle themselves ported the data from one instance to another..?

    Let me know.

     

    Version:
    Service Cloud

    Comment

     

    • Suresh Thirukoti

      Some ways to do it.....implementation type depends upon the customer...but most common is to use Data Import wizard to upload CSV exported from the older instance....

      • This involves creating a custom report on answers and adding required fields in the output
      • Report output will be exported as CSV and then imported into the other system
      • But this requires some manual fixing on Product/Category assignment, UI elements alignment/formatting, fields assignment discrepancies...etc 

       If you have some special requirement like mapping product category or manipulating UI elements ..etc, then Customization is the way to go....High level approach will be

      • Build a PHP Script utilizing Connect PHP API to read the Answer data
      • Invoke the target system's REST or SOAP API to update the data
      • Somewhat complex implementation but achievable and you will have full control on the proceedings

      ~Suresh

       

       

       

      ~Suresh

    • keerthi P

      Thanks Suresh

      Yes the 2nd option is the backup option any ways. We were just thinking if ORacle could just pick up data from db and port it another instance...just how a tape backup/restore tables is done.

      Thanks.

       

    • Suresh Thirukoti

      Just raise a SR with Oracle to see if they can do something what you envisioned...

      ~Suresh