cmdb ci relationship

Rishabh Dev Kha
Tera Contributor

Hi Everyone,

Can anyone suggest how to move ci from one instance to another, I tried using update set but relationship is not getting captured.

 

7 REPLIES 7

Robbie
Kilo Patron
Kilo Patron

Hi @Rishabh Dev Kha,

 

The best way to move data and records between instances is via 'xml'. 

Simply create a filter on the table which display the records you wish to move (in your case the cmdb_ci table), and then right-click on one of the table headers and select 'Export XML'..

You'll also need to export the relationship via XML as well. This can be achieved by opening up the CI record and navigate to the relationship record. Open this and export via XML the same way (Right-click at the top of the record).

If you need to export multiple records and multiple relationships... simply open the 'cmdb_rel_ci' table and filter the table to include all the required records and export these.

 

One you have the exported files which will be stored locally on your machine.... go to the instance you wish to move the records to, navigate to the same cmdb_ci and cmdb_rel_ci table - right click at the top of the table and select 'Import XML' - Jobe done.

 

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.

 

Thanks, Robbie

Kenn Denn
Tera Contributor

@Robbie & @Sruthi17 - THANK YOU! Your powers combined saved me so much time & headache.

Hi @Kenn Denn,

 

My / Our pleasure. We've all been there so happy to help.

 

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.

 

Thanks, Robbie