Andrew Hanna

Andrew Hanna

Data Migration Tools in Salesforce: Which One to Use When

Data Migration Tools in Salesforce: Which One to Use When

The short answer: use the Data Import Wizard for simple loads under 50,000 records, Data Loader for larger or scheduled loads up to 150 million records, and an org-to-org tool when you need to copy related records between production and sandboxes. That last job, the one Salesforce teams do most often, is where native tools stop and SFDMU or a DevOps platform's data deployment takes over.

What are data migration tools in Salesforce?

They are tools that insert, update, upsert or export records in a Salesforce org at a volume or complexity that manual entry cannot handle. They fall into four groups:

  • Native file loaders: the Data Import Wizard and Data Loader, both from Salesforce.
  • CLI utilities: such as SFDX Data Move Utility (SFDMU), a Salesforce CLI plugin.
  • ETL and integration platforms: for transforming data from external systems and keeping it in sync.
  • DevOps data deployment: org-to-org data moves inside a release tool such as Serpent, Copado or Gearset.

Which Salesforce data migration tool fits which job?

A one-off import of a clean list

Use the Data Import Wizard. It is built into Setup, needs no install and handles up to 50,000 records at a time. Watch out: it supports a limited set of objects and gives little control over relationships.

A large or recurring load from files

Use Data Loader. According to Trailhead, it handles 50,000 to 150 million records, objects the wizard does not support, and scheduled loads such as nightly imports. Watch out: it works from CSV files on a local machine, so exports, mappings and error files live outside Salesforce.

Related records between two orgs

Use SFDMU or a DevOps data deployment. Watch out: plain file loaders break lookups between orgs, because record IDs differ in every org.

Continuous sync with an external system

Use an ETL or integration platform. That is integration rather than migration, and it needs its own monitoring.

For the end-to-end process around whichever tool you pick, follow our step-by-step data migration guide.

Where do Data Import Wizard and Data Loader stop?

Both come with Salesforce and both are file-based. The wizard suits admins importing Accounts, Contacts, Leads or custom object records from a spreadsheet. Data Loader suits volume and can use the Bulk API for large jobs. The Trailhead large data volumes module recommends the Bulk API for anything from a few thousand to millions of records, and loading parents before children.

Where they stop: neither knows about your release process. There is no dependency check across orgs, no masking, and no record of which data shipped with which release.

How do you migrate data between Salesforce orgs?

  • SFDMU. The open-source SFDX Data Move Utility is a Salesforce CLI plugin under the Apache-2.0 license. It migrates org to org or through CSV, supports insert, upsert, update and delete, handles related objects including circular references, and is configured with a single export.json file. It runs locally, so someone on the team owns the scripts.
  • Copado Data Deploy. Per Copado's documentation, it uses data templates that define a main object with its parents and children, deploys relational data between sandboxes and to and from production, and offers PII masking.
  • Gearset data deployment. Gearset's docs describe dependency checks, optional per-field masking, temporary deactivation of flows, triggers and validation rules, and retrieval of up to 100,000 records per parent object.
  • Serpent. Covered below.

If the goal is a test-ready sandbox rather than a one-time move, see how to seed a Salesforce sandbox with realistic data. If your org is moving to Hyperforce, that is Salesforce moving your org's infrastructure, not you moving records, so work from our Hyperforce migration checklist instead.

What should you check before choosing a tool?

  1. Relationships. Does it resolve lookups through external IDs or a dependency graph?
  2. Automation handling. Can it pause triggers, flows and validation rules, and does it switch them back on?
  3. Masking. Can it obfuscate personal data before records reach a sandbox?
  4. Where data travels. Does it pass through CSVs on a laptop, or move org to org?
  5. Run history. Can you see what moved, what failed and when?
  6. Pipeline fit. Can data move in the same release as the metadata it depends on?

How does Serpent handle data migration?

Open Migrate Data in the Data Management tab, pick a source and a destination org, turn on PII masking if you need it, start the migration, then review its progress and results. The Migration Details page shows the execution timeline, the Migrated Objects table filters by success and failed status, and built-in dependency checks reduce migration surprises. Full steps are in the data migration and masking guide.

Two things matter in a DevOps workflow. Migrate Data is an action in the visual automation flow builder, so metadata and data move in the same release flow. And sandbox seeding runs as part of environment setup and release pipelines, so refreshed sandboxes and scratch orgs come back populated without a manual script run. Before a large write, the Backups view captures a known-good state you can restore from, as described in backup and restore. See data deployment for how it fits the pipeline. Deploy data is on every plan, including the free Essentials plan.

FAQ

What is the best free data migration tool for Salesforce?

Data Loader for file-based loads and SFDMU for org-to-org moves. Neither carries an extra license cost, and SFDMU needs the Salesforce CLI.

How many records can Data Loader handle?

Up to 150 million records, per Trailhead. The Data Import Wizard handles up to 50,000 records at a time.

Can I migrate data between sandboxes with Data Loader?

Only by exporting and reimporting CSVs and remapping lookups by hand. An org-to-org tool handles the relationships for you.

Do Salesforce data migration tools mask PII?

The native file loaders do not. Salesforce Data Mask & Seed, Copado, Gearset and Serpent all offer masking.

More how-to playbooks for Salesforce DevOps teams live in SF Guides.

Related Articles

Curious about faster shipping before you dive in? Let's talk

Commitment free!