If anyone wanted to export a large amount of data without increasing the instance export limits, they should use the below-mentioned workaround
- Instead of exporting all records in one import. divide report by date wise and export multiple reports.
- Use the ServiceNow ODBC tool to get the records. Refer DOcumentation: https://docs.servicenow.com/bundle/madrid-application-development/page/integrate/odbc-driver/concept/c_ODBCDriver.html
- Use the export set: https://docs.servicenow.com/bundle/london-platform-administration/page/administer/export-sets/concept/c_ExportSets.html