Export all data in an application

[tjschmitt]

I searched for this topic but did not find anything.

Is there any way to export all of the data in an application out of the system and reimport the data later?

What happened is that we allowed some people to play with the GRC module in our development environment. They've been exploring development for about 3 months and they have quite a bit of data. We'd like to refresh development with production data but they've asked us to back up their data in development first. The GRC module has several tables - is there a way to export all of the data and remiport it?

I would assume that there is not but thought I would check.

Tim
ServiceNow Newb

[zachkenyon]

Yes, you can export all records in a table to XML. Go to a list view for the application, set the filters to All, then right-click one of the column headers and select Export > XML.

To re-import the data, right-click on the column header for any table and select Import > XML.

https://wiki.servicenow.com/index.php?title=Exporting_Data

[tjschmitt]

I can see that there is a way to export a specfic table but can you do all of the tables in an application? For example, the GRC application is made of tables. Is there a way to do just all of them at once?

[zachkenyon]

Not that I'm aware of, I'm guessing you'd need to go to each table and export it manually. Alternatively if you're using Berlin you might be able to set the clone not to overwrite the GRC tables using Data Preservers, but if you don't have GRC activated on your prod instance I don't know if that would work.