+ Start a Discussion
Varma AlluriVarma Alluri 

Extract large data record from salesforce 35 million.

I have 35 million records in my salesforce org against 1 custom object....I need to extract those records based on the filter conditions.
In workbench it keeps on loading but unable to fetch the record . Same with data loader.
Do we have any tool or any other way to extract the records ?
CloudGeekCloudGeek
Hello Varma,

The SOQL query can fetch only 50K records (same with Workbench/Data Loader too).

Go through below links , if that helps :

https://developer.salesforce.com/forums/?id=906F000000090EEIAY

If needed on VF page :

http://sfdc-know-how.blogspot.com/2013/11/readonly-annotation.html

Note: Hit like if this helps, or Mark as solution it if resolves your problem.
Varma AlluriVarma Alluri
@cloudGeek: THanks for the post.
Currently I am not using a batch but I need a file (may be .csv) which will have all the records 35 M based on some filter conditions.
Like if Account has 35 million records... I wanted a csv with the below query

SELECT ID,NAME from ACCOUNT where name !='New Account';
CloudGeekCloudGeek
Like I posted above, You may want to try the suggestions discussed in here :

http://salesforce.stackexchange.com/questions/11116/how-to-export-more-than-50k-records-matching-a-query-as-a-csv
Raja Durai 28Raja Durai 28
To handle Large Data Volume (LDV), You should use BULK API option. Or you can use any appexchange backup tools
Tara RootTara Root
Really interesting! Plagiarism is a serious crime that is punishable by law. Competent writers from https://essaysrescue.com/enotes-review/ understand the significance of writing each assignment from scratch. Originality is a significant aspect that makes a service reliable. Thus, each task goes through various plagiarism checker tools before submission.