i need to export 19,00,000 records from the production. i started the process but in the middle due to network issue the process failed. and export file having only some of the records from where was the issue raised, so i need to export rest of the records.. HOW?
-
cant you export one more time?– AnnappaOct 30, 2018 at 11:27
-
Considering the size of data I would restrict myself from using data loader because of API calls it would make. Using Standard Weekly Data export seems like best approach. help.salesforce.com/…– Pranay JaiswalOct 30, 2018 at 11:39
Add a comment
|
3 Answers
You can reexport the records from the beginning by using dataloader with Bulk API option, it will hardly take 2-3 minutes max to export all 1.9M records.
Otherwise, in the dataloader settings you can specify starting row from which it can be exported the rest of the records.
answered Oct 30, 2018 at 12:42
Next time consider chunking the queries in smaller batches using the createddate range as a scope. So next time you fail due to network issues it will only impact that batch.
In addition to Data Loader, maybe you can try other third-party tools, such as Acho, to bulk export data. Although it still takes time to retrieve data, the process runs on cloud so you don't need to worry about the network issue.
