data-migration
Installation
SKILL.md
Skill: Data Migration
When to Use
Trigger when migrating data into Dataverse from external systems, legacy CRM (D365 on-prem), CSV/Excel files, or other databases. Also trigger for data quality processes, bulk operations, and migration rollback planning.
Migration Approach Decision Table
| Volume | Complexity | Approach | Tools |
|---|---|---|---|
| < 10K rows | Simple (flat) | Dataverse import wizard | Built-in CSV/Excel import |
| < 100K rows | Simple to moderate | Dataverse dataflows | Power Query Online |
| < 100K rows | Complex (transforms) | Power Automate | Flow with Apply to Each |
| 100K-1M rows | Any | Web API bulk (CreateMultiple/UpdateMultiple) | Script (bash/PowerShell) |
| 1M-10M rows | Any | Web API bulk + parallel scripts | Custom script with batching |
| 10M+ rows | Any | Azure Data Factory + elastic tables | ADF pipelines |
| D365 on-prem → online | CRM-specific | D365 Migration Tool or Web API | KingswaySoft, Scribe, ADF |