How can we move bulk of Problem records from One instance to another instance like dev1234 to dev 5678?

[Purushotham Gan]

Hi All,

How can we move bulk of Problem records from One instance to another instance like dev1234 to dev 5678?

Note: Only one time i need to move those records.

Please Assist me on this.

[Harneet Sital · Accepted solution]

Hi Purushotham, 

Yes, there are multiple ways you can do this. You can integrate the two instances but it isn't an ideal solution as you want to load the data just once. What might help you is - the data loading option in ServiceNow to load the problem data. Export your problem records from X instance and load them using the load data option so you can transform/map the fields while loading this data. 

https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_le...

Moving XMLs might lead to discrepancies like reference field sys ids, if they are different the problem records will have broken references. If they are consistent, then feel free to use the XML export/Import option and yes you can import more than 1000 records using XML import/export

Hope the answer has helped you, please mark the answer correct/helpful. Thank you.
-Harneet
ServiceNow Certified Technical Architect

[mitanshi-mandlo]

@Harneet Sital  If the record count is around 92 thousand, what should be the best approach to move the data from one instance to another.

[Dr Atul G- LNG]

Hi @mitanshi-mandlo 

Why you want to move data? You can do clone if required but that is upper to lower instance. 

[mitanshi-mandlo]

Hi @Dr Atul G- LNG 

Thanks for the response

I have around 92 thousand records in case table in dev instance, I want those records in the prod instance.

[Dr Atul G- LNG]

Hi @mitanshi-mandlo 

92K records, but why did you move the data from Dev to PROD? Dev data is like dummy data or not useful, what is needed to move that data?