What is the difference between dataloader and batch apex in salesforce?

Data Loader:

Data Loader is a client application for the bulk import or export of data. Use it to insert, update, delete, or export Salesforce records. When importing data, Data Loader reads, extracts, and loads data from comma-separated values (CSV) files.

The Data Loader is an easy to use graphical tool that helps you to get your data into Salesforce objects. The Data Loader can also be used to extract data from database objects into any of the destinations mentioned above. You can even use the Data Loader to perform bulk deletions by exporting the ID fields for the data you wish to delete and using that source to specify deletions through the Data Loader.

When using Data Loader, the maximum records count is 5 000 000

More information about Data Loader: https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/data_loader.htm

Batch Apex:

Batch Apex is meant for processing of bulk data within SFDC.

Batch apex allows you to define a job that can be divided into manageable chunks, where each chunk can be proceed separately.

In batch apex, it will fetch all records which you want perform the field update and divide them into list of 200 records and every 200 records operation is performed separately.

Using Batch Apex: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_batch_interface.htm

Regards,
Greg
KeyNode Solutions
http://www.keynodesolutions.com

• This reply was modified 8 years, 11 months ago by  KeyNode.