Best way to move table data from Dev to Test.

HrishabhKumar
Kilo Sage

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.

1 ACCEPTED SOLUTION

Community Alums
Not applicable
7 REPLIES 7

Hi @HrishabhKumar 

 

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. 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Community Alums
Not applicable

Hi @HrishabhKumar ,

 

Harish Bainsla
Kilo Patron
Kilo Patron

Hi @HrishabhKumar 

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