Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Max Gilbert @ ftrMax Gilbert @ ftr 

Calculating Opportunity Amount Differently

Need to delete 35,000,000 records from an object containing 49,000,000 records.  What is the best method to accomplish this? 

 

@anilbathula@@anilbathula@

Hi Max,

The best way to delete these many records use Dataloader or Jitterbit Dataloader.
Max Gilbert @ ftrMax Gilbert @ ftr

Dataloader times out during the extract process even if using bulk API.
Mari GanesanMari Ganesan

You can use two options

 

    1) Apex dataloader with "Bulk Api" option enabled.

 

    2) Use Workbench (https://workbench.developerforce.com/login.php)

   
cplusplus_pleasecplusplus_please
Simple.

for(int i = 0 ; i < 35million; i++)
{
Click on the appropriate record, press delete.
}

:P



=============================
Developer for www.voicent.com
Voicent provides CRM, auto dialer, predictive dialer, reminder, and call center solution that is suitable for anyone in any level
Voicent strives to meet customer demands to integrate Voicent software with CRM of their choice.
sandeep@Salesforcesandeep@Salesforce

For that you need to fetch record from Databse using SOQL ( limit 50,000 records) so we should use Data loader which user batch internally.