Export huge amount of data

[Kevin Paul]

Hi All,

I am trying to export data from cmdb_ci table, CI records that we use. The total records to export as CSV is 788000,

the CSV max limit is 300000. Can anyone please help me in exporting the records, how to separate them and export as batches? How to sort and export? I have already sort ascending by name of the CI and exported first 300000 records, please suggest me some tips.

Thanks!

[Kevin Paul · Accepted solution]

I used the method of sorting by sys_id, exporting a batch and then using the last sys_id from first batch to create a new batch and export it again. 

The following link helped.

https://davidmac.pro/posts/2021-07-02-sn-bulk-export/