how to copy the cmdb_ci table records to lower instances?

Community Alums
Not applicable

Hi,

I am new to cmdb world. I was asked to copy the cmdb_ci table to lower instances.

When I compared 'cmdb_ci' table in prod and dev/test, there were some 1000 records missing. Now, I need to get the prod data into dev/test, update the existing ones and insert the missing ones.

What I did it:

I exported the prod: cmdb_ci table into excel and tried to import these data's using System Import Sets.

But, it gave me only the columns in the default list view. If I need all the columns of the cmdb_ci table, should I configure the list layout or is there any other brilliant ideas behind this.

Why I am asking is, there are some duplicate records, so I am worried about doing the 'coalesce field'.

How to get the exact table records to dev/test from PROD?

Need step by step instructions please.

Thanks,

Rajini

4 REPLIES 4

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Rajnis,



Please check section 3.1 for more info.


http://wiki.servicenow.com/index.php?title=Exporting_Data#gsc.tab=0


Chuck Tomasi
Tera Patron

Hi Rajini,



For each table in the CMDB table structure, you need to go to the list, right click the header (assuming List v2) and export the data. Choose XML format to preserve all the the details of each record.


find_real_file.png



Once you have all your tables exported to XML, go to your target instance and do a similar operation and choose Import XML from the list menu to bring in each file.



find_real_file.png


Community Alums
Not applicable

Thanks All.


david_loo
Tera Contributor

To have a product approach without writing any code or creating any web service while maintaining the same sys_id between your instances, you can install and configure Perspectium Replicator



Using Replicator to sync up ServiceNow instances - YouTube



I hope this helps



David