Import Data from One Instance to another one

[Naveen87]

Hey Guys,

I wanna import 1000's of record (Bulk data ) from One instance to another (DEV to UAT).

How this can be achieved in a simpler way ?

Any scripts etc..? Or we have to use typical transform map process.

Pull --> Staging table --> Target table.

Please suggest.

Thanks 

[Michael Jones -]

Import sets are usually the way to go; depending on the complexity of the data and how well the two instances are aligned, you can usually do a one-off load by creating an easy import template in your target instance and populating with data from your source instance. 

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/import-sets/concept...

If the instances are well aligned, you can sometimes get away with just and export of xml and import, depending on what references you are dealing with. If all of the references are ones you want to create, then you're good, otherwise if you have data references (like users, incidents, etc.) the import set method is best. 

I hope this helps!

If this was helpful or correct, please be kind and remember to click appropriately!

Michael Jones - Proud member of the CloudPires team!

[Appli]

Hi Naveen, you may select records applying filter via the list view, and click "Export -> XML" that will generate XML file with all these records inside in Raw format. Than import these excel file on target instance.

Hope it helps

[Murthy Ch]

Hi @Naveen 

You can do by export to xml file in source instance and import that XML file in target instance.

Thanks,

Murthy

Please mark my answer helpful if its solves your query.