Salesforce Data Migration Checklist

A successful data migration into requires a well designed plan that goes well beyond the mechanics of moving data between 2 systems. This checklist is intended to surface some of the non-obvious, finer points of a data migration.
More Learning Resources for Salesforce Migrations
image.png

📋 People

Is there anyone on your team who understands the old and new Salesforce Data model?
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: This question aims to identify if there's existing knowledge about Salesforce data models within your team.
Have you identified who will help verify the accuracy and validity of data mapping and make decisions for mapping values between picklists?
[ ] Yes
[ ] No
[ ] I am not sure
Many times there isn’t perfect 1-1 mapping between your existing application and Salesforce. Having someone readily available to make decisions will help ensure timely mapping.

🛠️ Process

Have you inventoried your Salesforce objects for migration?
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: This is about ensuring all relevant Salesforce objects are accounted for before migration.
How does your user adoption testing for Salesforce coincide with data migration?
[ ] User adoption testing before data migration
[ ] User adoption testing after data migration
[ ] Depends on remaining timelines and schedule
[ ] I am not sure
Clarification: Understanding the timing of user adoption testing in relation to data migration.
How much time has your team allotted for migration?
[ ] < 1 month
[ ] 1-2 months
[ ] > 2 months
[ ] I am not sure
Clarification: This question seeks to understand the time frame set aside for the migration process.
How will you transition users from old system to new system?
[ ] Hard cutover
[ ] Rolling cutover
[ ] Soft cutover
[ ] I am not sure
Clarification: This involves the strategy for moving users from the old system to Salesforce.

💾 Data

Have you created migration key fields in all objects you are migrating?
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: This relates to the preparation of key fields necessary for data migration.
Do you have a data dictionary for the system you are migrating from?
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: A data dictionary would provide a detailed view of the data elements in the system being migrated from.
Do you have a data dictionary for your app?
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: This is about having a comprehensive data dictionary specific to your Salesforce application.
Have you created data mapping document from the old application to Salesforce?
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: Data mapping documents are crucial for understanding how data from the old system will fit into Salesforce.
Have you documented the mapping of picklist values?
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: This ensures that the picklist values in the old system are appropriately mapped to Salesforce.
Are you migrating documents into Salesforce (example PDFs)
[ ] Yes
[ ] No
[ ] I am not sure
Clarification: Documents require additional APIs mapping and planning. Clarifying document migration early will help allot adequate time for mapping.
How would you rate the data quality of the system you are migrating from?
[ ] A - Data is pristine and tightly controlled
[ ] B - Data is controlled but with known issues
[ ] C - Data is not tightly controlled, may cause issues
[ ] D - Data is dirty and could pose problems
[ ] I am not sure
Clarification: Understanding the current quality of the data will help anticipate challenges in migration.

💻 Technology

How extensive are data validation rules in Salesforce?
[ ] Small (1-2 rules per object)
[ ] Medium (3-5)
[ ] Large (6-12)
[ ] Extra Large (13+)
[ ] I am not sure
Clarification: Knowing the scale of data validation rules in place can impact the migration strategy.
What type of automations exist in Salesforce when records are created or updated?
[ ] Workflows
[ ] Process Builders
[ ] Flows
[ ] Triggers + APEX
[ ] I am not sure
Clarification: Understanding the automation landscape in Salesforce is key for migration planning.
What kind of automated communications exist in your Salesforce instance?
[ ] Triggered Salesforce Emails
[ ] Triggered SMS
[ ] Triggered Marketing Automation Emails
[ ] Other communication triggers
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.