CMDB table transfer between instances

[Siris]

Hi, How to add the Cmdb tables cmdb, cmdb_ci, and cmdb_rel_ci to an update set and transfer to another instance??

[Community Alums]

Hi @Siris ,

The most straightaway method is You'll want to export data from every cmdb_ tables as XML and import on the destination instance.

There's a couple of ways you can accomplish this.
If your CMDB is pretty light on overall records, you can migrate it using data sources and do an XML pull from your other instance.
This method though is probably the most difficult to fully accomplish without tweaking because you'll most likely hit the record limit before you get all of your data out, also in my testing with this, there seems to be a hard limit on the rows that you can move using this method too.

Another undesirable way to do this would be to just export your cmdb via csv (which if you have anything on the relationship table is not going to work
because exporting the csv does not give you the sys_id to match for relationships)

Yet another way would actually be to export the entire cmdb to excel/csv using the odbc connector, although this isn't really practical, it does work and will give you the sys_id. (When I tried this I spent more time removing useless columns than actually importing and transforming the data)

[Dr Atul G- LNG]

HI @Siris 

If you want to move the data, you can use import / export XML from one instance to another instance. 

[Siris]

Hi, thanks for the response.  I tried it, but the issue is related CIs are not imported. 

[Dr Atul G- LNG]

Related CI means relationship? Please share the screenshot.