Best way to move table data from Dev to Test.

[HrishabhKumar]

Hi 

I have to move all the records which a particular discovery source from "cmdb_ci_netgear" table in Dev and move it to Test instance. There are 7000 records in total. What will the best approach to do that?

I don't think exporting the excel and importing it in test is a good approach, let me know other better options.

Thanks.

[Community Alums · Accepted solution]

Hi @HrishabhKumar ,

Please refer to my answer here : https://www.servicenow.com/community/cmdb-forum/cmdb-table-transfer-between-instances/td-p/2843726#:....

[HrishabhKumar]

Hi @Community Alums  Can I just export XML from one instance and import it in another, will that work?

[Community Alums]

Yes you can @HrishabhKumar but it's going to be a huge data.

So please refer to the options i mentioned in my answer, you can get a notion on which method suits well for you.

[HrishabhKumar]

Hi @Community Alums 

1) Do I need to add all the fields in list view before exporting XML?

2) Will this update the records as well, or only insert  records?