How to import large volume of data into CRM 2011 Online entities?

Question

I need to import millions of records into a CRM 2011 Online entities. Is there any efficient way to do it?

Answer 1

With CRM 2011 Online you have different ways:

• Use the standard Import Data Wizard functionality
• Use CRM Web Services to get the additional capabilities for import data, more details here: Import Data in Microsoft Dynamics CRM
• Use CRM Web Services to build your own import tool using the new ExecuteMultipleRequest, more details here: Use ExecuteMultiple to Improve Performance for Bulk Data Load
• Use an integration software as Scribe

Which one is more efficient between these methods depends on your crm structure, the source of your data, the complexity of the transformation, etc.

Answer 2

There are a couple of other import tools for importing data SSIS integration toolkit is one and Import manager another