Best way to move table data from Dev to Test.

[Community Alums]

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.

[Dr Atul G- LNG]

Hi @Community Alums 

Hi @Sandeep Dutta 

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

Atul: NO, it pick up all fields either part of list view or not.

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

Atul: Both. 

[Community Alums]

Hi @Community Alums ,

[Harish Bainsla]

Hi @Community Alums 

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