This documentation is archived and is not being maintained.

Comparison between Data Import and Data Migration

banner art

[Applies to: Microsoft Dynamics CRM 4.0]

Find the latest SDK documentation: CRM 2015 SDK

The following table contains comparison information for Data Import and Data Migration.

FeatureData Import (on-premises)Data Import (online)Data Migration (on-premises and online)
Import data into Microsoft Dynamics CRM Yes (All users who have appropriate permissions can import data.)Yes (All users who have appropriate permissions can import data.)Yes (Only the system administrator can migrate data in the offline mode.)
Import data into custom entity types and attributesYesYesYes
During data import or migration, create entity instances in Microsoft Dynamics CRM that have N:N (many-to-many) relationship with other entity instances.NoNoNo
Use multiple source files that contain related dataNo (You can only import one file at a time.)YesYes
Assign entity instances to multiple usersNo (All entity instances are assigned to one user.)YesYes
Update existing entity instancesYesNoNo
Detect duplicatesYesYesNo (You can run duplicate detection after you migrate the data.)
Delete all entity instances associated with one jobYes (Use the bulk delete feature.)Yes (Use the bulk delete feature.)Yes (Use the bulk delete feature.)
Automatically map data based on column headings in the source fileYesYesNo
Set the value of the createdon attribute for the entity from source dataNoYesYes
Customize Microsoft Dynamics CRM to match source dataNo (Customization must be done before import.)YesNo (Custom entities and attributes can be created by Data Migration Manager.)
Apply complex data transformation mappingNoYesYes
Import state and status informationNoYesYes
Import data from an Excel worksheet in XML format (XMLSS)NoYesNo

See Also

Other Resources

© 2010 Microsoft Corporation. All rights reserved.