Exporting more than 250.000 XML records from a table (Export limit)

[cicgordy]

Hi all, 

I am trying to export over 250.000 xml records from a table. System properties (export limit) is only set to a default of 10.000 record to export maximum. Can I change and, if so, how do I change the xml export limit to over 250.000? Will the system allow me to do this or will it run into issues by setting such a high number? 

Thanks 🙂

[Mark Manders · Accepted solution]

Even if you get this to work, you will run into issues when loading them back into this (or another) instance, because of the size of the XML. Best way to move on is to do it in batches. It will make sure you can use them again. 

But yes: you can change the default to a higher volume, only do know that these are in place for a reason. It can cause performance issues when you are exporting these kinds of volumes.

[cicgordy · Accepted solution]

Hi Mark, thanks for the quick response, I understand. When you say the best way is to move them in batches, do you mean through update set? if so, will I have to select and add all the 250.000 records manually to an update set? Thanks

[mohcine elbah]

You can do this by changing the property glide.xml.export.limit in the sys_properties table.

Create it if it doesn't exist, then set the value you want.

[Mark Manders]

And then? You will get an XML of a size you can't do anything with, because you can't load it because of that size. That hasn't changed in the 3 YEARS since this question was asked.

[mohcine elbah]

Regardless of their use case, I only provided the solution to increase the data export limit; they may probably need to export the data to use on another environment or any other use case, not necessarily ServiceNow import 🙂

Thank you for your response