0

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?

2
  • cant you export one more time?
    – Annappa PH
    Commented Oct 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/… Commented Oct 30, 2018 at 11:39

3 Answers 3

2

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.

1

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.

0
0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .