Phase 0
Decide & Plan
Lock the decisions that cause mid-migration scope creep when skipped.
-
Risk if skipped: Discovering mid-cutover that Butler automations were assumed in-scope but were never planned for blocks workflow continuity on day one.
-
Risk if skipped: Loading boards into Personal scope when the team needed Workspace collaboration forces a board-by-board move after cutover.
-
Risk if skipped: Users expect to see closed work and historical comments on day one and find truncated activity, eroding trust in the new system.
-
Risk if skipped: Building on Free and discovering a paid-only feature mid-migration forces an unplanned tier upgrade or a re-architecture.
-
Risk if skipped: If residency is required but not provisioned at sign-up, switching regions later requires re-migrating the Workspace through Atlassian's data migration flow.
-
Risk if skipped: A regulated data set landing in an unconfigured Workspace can trigger a reportable incident before users even log in.
-
Risk if skipped: Without written criteria, the project never formally ends and the source system never gets decommissioned.
Phase 1
Pre-Migration Prep
Everything that must be true before the first byte leaves the source.
1a. Source-system audit and cleansing
-
Risk if skipped: Without baseline counts, you cannot prove the destination received everything during validation.
-
Risk if skipped: Duplicate emails resolve to the wrong user during member invitation and reassignment becomes a per-card cleanup job.
-
Risk if skipped: Cards landing without a due date or owner force a per-card triage pass before users can resume work.
-
Risk if skipped: Importing case-mismatched values silently creates a parallel dropdown option, doubling the value list and breaking filters.
-
Risk if skipped: An over-cap dropdown blocks creation of the 51st option, orphaning cards tagged with truncated values.
-
Risk if skipped: Oversized direct attachments fail silently on import and leave cards without their reference material.
1b. Destination setup
-
Risk if skipped: Provisioning on Free when paid features are needed forces a tier upgrade under deadline pressure mid-cutover.
-
Risk if skipped: Testing against the production Workspace exposes real users to dirty test data and burns Butler operations from the production quota.
-
Risk if skipped: If members do not exist at import time, the Members field silently leaves cards unassigned.
-
Risk if skipped: Missing or mis-ordered lists at import time force a per-card move pass after cutover.
-
Risk if skipped: Forgetting to enable Custom Fields on one board out of fifteen drops every custom-field value on that board's cards.
-
Risk if skipped: Missing field definitions cause data to land in the card description as free text, requiring per-card re-parsing.
-
Risk if skipped: Without an external-ID column, re-running an import after fixing a transform creates duplicate cards instead of updating in place.
-
Risk if skipped: An unpaused Butler rule during a 10,000-card load can consume the entire monthly Butler operation quota and send 10,000 notifications.
-
Risk if skipped: Hitting the Butler quota cap pauses every automation in the Workspace until the cycle resets.
1c. People prep
Phase 2
Source Export
Get every byte you'll need out of the source, in a form you can transform.
-
Risk if skipped: Skipping one object class is the most common reason validation fails reconciliation in Phase 6.
-
Risk if skipped: Losing item order or completion state forces a per-checklist manual rebuild after import.
-
Risk if skipped: Without an export timestamp, the cutover delta is unknown and last-minute edits silently get lost.
-
Risk if skipped: A silently truncated export propagates downstream; the data is missing in the destination and only surfaces at user-acceptance test.
Phase 3
Transform & Map
The data-engineering core: source files in, destination-shaped files out.
3a. Mapping spreadsheet
-
Risk if skipped: Skipping the mapping spreadsheet means every transform decision lives in one engineer's head and re-runs become guesswork.
-
Risk if skipped: Unmapped values land as new options on the destination dropdown, doubling the list and breaking saved filters.
-
Risk if skipped: Silent drops surface as missing data weeks after cutover when a user goes looking for context.
-
Risk if skipped: Mapping a status to both a list and a label doubles the encoding and breaks downstream filtering.
3b. Data transformation
-
Risk if skipped: Mixed date formats parse to wrong dates or shift hours due to ambiguous timezone handling.
-
Risk if skipped: Corrupted Unicode characters propagate through every downstream view and require a per-card cleanup pass.
-
Risk if skipped: A single bad row half-way through a 10,000-row file means the second half never imports and the row count mismatch only surfaces in Phase 6.
-
Risk if skipped: Truncated dropdowns drop the 51st value silently and tag every affected card with no value.
3c. Relationship and audit-trail decisions
-
Risk if skipped: Without a captured original timestamp, every age-based report shows zero days since creation on day one.
-
Risk if skipped: Imported closed cards landing on the active board flood the Kanban view with thousands of done cards.
-
Risk if skipped: Re-uploading 50 GB of binaries against the destination's throughput ceiling exhausts the budget and stretches the cutover window by hours.
3d. PM-specific transforms
-
Risk if skipped: Mapping a four-level source hierarchy to a two-level Trello structure without explicit rules leaves the team with no consistent way to find a card.
-
Risk if skipped: Importing cards without a dependency mechanism breaks every downstream sequencing rule that the source enforced.
-
Risk if skipped: Time-entry history that cannot be imported into the Power-Up becomes an archive-only record outside Trello.
-
Risk if skipped: Threaded replies collapsed without a marker lose conversation order and become a wall of disconnected text.
-
Risk if skipped: Recurring tasks left untranslated stop generating after cutover and the work silently goes undone.
-
Risk if skipped: Oversized direct-upload attempts fail silently and leave cards without their referenced files.
Phase 4
Sandbox Test Migration
Catch every problem in a test Workspace before it costs you in production.
-
Risk if skipped: A sample that skips edge cases passes sandbox and then fails at production volume.
-
Risk if skipped: Skipping field-by-field validation lets one silent mismatch (e.g., dropdown case mismatch) reach production unchallenged.
-
Risk if skipped: Unicode and special-character failures only surface at the specific records that contain them; you find them in Phase 6 if you don't test them here.
-
Risk if skipped: Attachment failures often only surface when a user clicks the file; sandbox is the cheap moment to catch them.
-
Risk if skipped: Hitting throughput ceilings at production volume stretches the cutover window unpredictably; the rehearsal proves the timing assumption.
-
Risk if skipped: Extrapolation reveals whether the cutover window is realistic; learning the answer at 2 a.m. on cutover night is too late.
-
Risk if skipped: Discovering that a planned automation exceeds Butler's quota tier mid-rebuild forces a tier upgrade or a feature cut at the worst moment.
-
Risk if skipped: Proceeding without written sign-off leaves accountability ambiguous when something breaks in production.
Phase 5
Production Cutover
The tightly-sequenced execution window. Densest cluster of risk.
-
Risk if skipped: Skipping the delta export means every edit between baseline and cutover is silently lost.
-
Risk if skipped: An active rule on cutover night blasts every Workspace member with notifications and burns the entire monthly Butler quota.
-
Risk if skipped: Loading cards before lists exist drops position data and forces a per-card move pass.
-
Risk if skipped: Attachment uploads are the slowest step and the most throughput-sensitive; running them last means a failure does not strand the rest of the load.
-
Risk if skipped: Without idempotent keys, a partial-failure re-run creates duplicates that have to be cleaned up by hand.
-
Risk if skipped: Catching a row-count mismatch step-by-step is cheap; catching it at the end means re-running everything to find the missing step.
Phase 6
Validate
Prove the migration was correct. Do not open the destination to users until this phase passes.
6a. Reconciliation
-
Risk if skipped: Even a small delta means cards went missing; finding which ones is harder than finding the delta.
-
Risk if skipped: Missing custom field values are the single most common Phase 6 finding; check them first.
-
Risk if skipped: Aggregate counts can match while individual records are wrong; field-by-field sampling is the only way to catch that.
6b. Relationship validation
-
Risk if skipped: An attachment that uploaded successfully but lost its card link is invisible until a user goes looking for it.
6c. Audit and compliance
-
Risk if skipped: An empty "Source Created On" field on day one means every aging report is wrong from day one.
-
Risk if skipped: A residency miss is a compliance event, not a feature gap; catch it before users log in.
6d. User-acceptance check
-
Risk if skipped: UAT is the last line of defense before go-live; skipping it exports the validation cost to every user on day one.
6e. Sign-off
-
Risk if skipped: Verbal sign-off creates accountability ambiguity when a defect is found weeks later.
Phase 7
Post-Migration Cleanup
Wrap up so the team can move on and the source can be decommissioned.
-
Risk if skipped: Forgetting one source automation breaks the workflow it enforced and the team finds out by missing a deadline.
-
Risk if skipped: Long-lived credentials left active after migration are a soft target for an audit finding against a freshly-loaded Workspace.
-
Risk if skipped: Source archives kept on the team drive without encryption are a soft target for an audit finding.
Watch list
Risks to track throughout
These risks live across multiple phases — keep an eye on them from kickoff through cutover.
-
Throughput ceilings compounding across rehearsals and re-runs
Trello enforces throttling on bulk operations, with separate headroom on the Boards path. Sandbox rehearsals, mapping fixes, and re-loads compound against the same caps. Track cumulative consumption from Phase 4 onward, pace bulk operations with exponential backoff on HTTP 429, and run attachment uploads last because they are the slowest and most throughput-sensitive step.
-
Audit-trail re-stamping at import and per-board Activity History caps
Cards are stamped with the import moment as creation date and there is no override flag, and Free-tier Activity History is capped at 250 events per board. Both behaviors break aging reports and historical context from day one if the Phase 3c "Source Created On" custom-field pattern is not applied and the tier mismatch is not surfaced in Phase 0. Validate them in Phase 6 before sign-off, not after users start filing tickets.
-
Tier-gated features and Butler quotas assumed but not licensed
Per-board Power-Up cap (Free: 1 Power-Up; Standard and above: unlimited), Butler operation quota (Free: 250/month, Standard: 1,000, Premium: 6,000, Enterprise: unlimited), attachment size cap (Free: 10 MB; paid: 250 MB), unlimited Activity History, Atlassian Guard SSO, and Workspace-level admin controls are all tier-gated. Confirm the destination Workspace's exact tier in Phase 0 and re-check before Phase 4. A tier downgrade or a misread of the pricing matrix mid-project forces a costly upgrade under deadline pressure or a re-scope.
-
Native gaps: dependencies, time tracking, threaded comments, required fields, recurring tasks
Trello has no native task dependencies, time tracking, threaded comments, required-field enforcement, or recurring cards. Each gap is addressed by a Power-Up (dependencies, time tracking), a Butler scheduled command (recurring), a custom-field convention (required), or a flattening rule (comment threads). Underestimating that rebuild is the single most common reason cutovers ship on time but adoption stalls at 30 days. Treat the Power-Up and Butler rebuild as in-scope Phase 7 work, not afterwork.
Pair this with the long-form guide
The complete Trello migration guide
Same research, written as prose: data model, import mechanisms, mapping strategy, pitfalls, and partner landscape.