CRM migration

Migrate from Market Maker to Microsoft Dynamics 365 Sales

Field-level mapping, validation, and rollback between Market Maker and Microsoft Dynamics 365 Sales . We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Sales .

Market Maker logo

Market Maker

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

90%

9 of 10

objects map 1:1 between Market Maker and Microsoft Dynamics 365 Sales .

Complexity

CModerate

Timeline

48–72 hours

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Market Maker stores CRM data in a flat object model with contacts, companies, deals, and activities as the primary records. Dynamics 365 Sales uses the Microsoft Dataverse foundation with Account and Contact as separate but related tables, Lead as a distinct pre-contact record, and Opportunity as the deal entity tied to business-unit-scoped business process flows. We map Market Maker contacts to Dynamics 365 Contact records with Account lookups resolved first, companies to Account records, and deals to Opportunity records using pipeline-to-business process flow mapping. Custom fields from Market Maker become custom columns on Dataverse tables — Dynamics 365 Sales Professional caps custom tables at 15, while Enterprise removes this ceiling, so your license tier determines schema planning scope. Activities (calls, emails, meetings, notes) migrate as Dataverse Activity records with original timestamps and owner assignments. We carry data and field values only; workflows, automations, templates, and reporting configurations must be rebuilt in Dynamics 365 using Power Automate, Dynamics workflows, or Power Apps. Our migration engine uses the Dataverse Web API for record creation and the Bulk API for high-volume loads, with field-level validation before commit.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Market Maker logo

Market Maker

What's pushing teams away

  • Limited CRM functionality — MarketMaker is primarily a directory and matchmaking tool rather than a relationship-management platform with pipelines, deals, and forecasting.
  • Geographic coverage is concentrated in participating US states; out-of-network buyers and sellers cannot leverage MarketMaker connections.
  • No public developer API or modern integration ecosystem — data exchange typically requires manual export.
  • User experience and mobile capabilities lag commercial directory tools.
  • Not a fit for businesses that need true CRM (contacts, deals, automation) — those teams pair MarketMaker with a separate CRM.

Choosing

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

What's pulling them in

  • Deep Microsoft 365, Teams, and Outlook integration makes Microsoft Dynamics 365 Sales a natural fit for Microsoft-first organizations already invested in that ecosystem
  • Sales Enterprise and Premium tiers offer unlimited custom tables and advanced AI-driven forecasting and predictive analytics not available in lower tiers
  • Professional tier pricing at $65 per user per month offers a lower entry cost than Salesforce for SMB teams with straightforward CRM needs
  • Flexible customization options allow businesses to build bespoke apps, tailor forms and views, and integrate with other Dynamics 365 modules
  • Microsoft Copilot AI tools are embedded directly into the sales workflow on Enterprise and Premium, automating routine tasks and providing deal intelligence

Object mapping

How Market Maker objects map to Microsoft Dynamics 365 Sales

Each row shows how a Market Maker object lands in Microsoft Dynamics 365 Sales , including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

Market Maker

Contact

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

Market Maker contacts map 1:1 to Dynamics 365 Contact records. The email address is the primary lookup key. Phone, job title, address, and created/modified timestamps carry over as Dataverse column values. Primary company resolves to AccountId before contact creation. Additional fields such as social media handles or custom classification tags are migrated as custom columns, preserving any data formatting present in the source.

Market Maker

Contact (unmatched company)

maps to

Microsoft Dynamics 365 Sales

Lead

1:many
Fully supported

Market Maker contacts without a primary company association, or those marked as prospects, route to Dynamics 365 Lead. The Last Name field populates the required Lead.name field; email and phone carry over as contact methods. Your team qualifies leads into Contact records during the sales process.

Market Maker

Company

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

Market Maker company records map to Dynamics 365 Account. Account name, website, industry, employee count, and annual revenue transfer to corresponding Dataverse columns. Parent-company relationships map to Account.parentaccountid for hierarchical accounts. Multi-company contacts create Account Contact Relationships after the primary Account is set.

Market Maker

Deal

maps to

Microsoft Dynamics 365 Sales

Opportunity

1:1
Fully supported

Market Maker deals map to Dynamics 365 Opportunity. Deal name becomes Opportunity.name, amount transfers to Opportunity.estimatedvalue, close date maps to Opportunity.closedate, and pipeline stage maps to the active Business Process Flow stage. Owner resolves by email match to Dynamics 365 SystemUser.

Market Maker

Pipeline

maps to

Microsoft Dynamics 365 Sales

Business Process Flow

1:1
Fully supported

Each Market Maker pipeline becomes a Dynamics 365 Business Process Flow attached to the Opportunity table. Stages in Market Maker map to stage names in the BPF. If your Dynamics 365 license is Sales Professional, business process flows are supported but with the 15-table limit counting against custom tables you create.

Market Maker

Pipeline Stage

maps to

Microsoft Dynamics 365 Sales

ProcessStage

1:1
Fully supported

Stage names in Market Maker map to BPF stage names in Dynamics 365. Each stage's probability and forecast category are applied from Dynamics 365 side configuration. Stage-entered timestamps from Market Maker are stored as custom datetime columns for reporting continuity.

Market Maker

Activity (Call, Email, Meeting, Note)

maps to

Microsoft Dynamics 365 Sales

Task / PhoneCall / Appointment / Annotation

1:1
Fully supported

Market Maker activity types map to specific Dataverse activity tables. Calls become PhoneCall, emails become Email, meetings become Appointment, and notes become Annotation. Original timestamps, subject, body, and owner carry over. Activity-party records link activities to Contact or Account. If a source activity references a deleted or missing contact, the activity is flagged as unresolved and stored in a temporary holding table for manual review before final linkage.

Market Maker

Attachment / File

maps to

Microsoft Dynamics 365 Sales

Annotation (File)

1:1
Fully supported

Market Maker file attachments re-upload to Dynamics 365 as Annotation records with the file stored in Dataverse or connected SharePoint. File size limits (Dynamics 365 default 128MB per file attachment) apply; larger files are flagged for alternative storage before migration.

Market Maker

Custom Object

maps to

Microsoft Dynamics 365 Sales

Custom Table (Dataverse)

1:1
Fully supported

Market Maker custom objects become Dataverse custom tables in Dynamics 365. Custom object relationships that use N:N associations map to Dataverse many-to-many relationships. If you are on Sales Professional and already have 15 custom tables, custom objects may need to be stored as custom columns on standard tables.

Market Maker

User / Owner

maps to

Microsoft Dynamics 365 Sales

SystemUser

1:1
Fully supported

Market Maker owner IDs resolve to Dynamics 365 SystemUser records by email address match. Unmatched owners are flagged before migration; you either invite them to Dynamics 365 first or reassign their records to a fallback owner. Owner history is preserved as custom columns for audit continuity.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

Market Maker logo

Market Maker gotchas

High

Directory rather than CRM

Medium

USDA/state participation varies

Medium

No public API

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales gotchas

High

Professional tier 15-table custom table limit blocks migrations

High

October 2024 pricing increase applies at renewal for all customers

Medium

Custom fields must be created in the UI before API writes

Medium

Power Platform request limits apply to bulk migrations

Medium

Activity records orphaned to inactive owners fail silently

Pair-specific challenges

  • Sales Professional 15-table cap forces custom table prioritization

    Dynamics 365 Sales Professional licenses limit custom tables to 15 total in a single environment. If your Market Maker setup uses more than 15 custom objects, or if custom objects have complex relationships, we must map them to existing standard tables as custom columns instead. This constraint is invisible during data export — your team learns about it when field creation fails post-validation. We audit your custom object count against the destination license tier before migration planning commits, and we surface this as a pre-flight decision point.

  • Activity type split requires pre-migration schema enumeration

    Market Maker stores all activities in one object with a type field; Dynamics 365 splits them into PhoneCall, Email, Appointment, Task, and Letter tables with separate activitytypecode values. The regardingobjectid lookup links activities to Contact or Account, but that requires both the contact and the activity to exist before we can write the relationship. If Market Maker has activities with no associated contact or account, those records land as 'unresolved' and require a fallback disposition — orphan activity records that never link to a CRM object.

  • Lead-Contact split in Dynamics 365 duplicates records for unqualified contacts

    Market Maker does not distinguish between a raw lead and a qualified contact — every person record is a contact. Dynamics 365 separates Lead and Contact as distinct tables with different lifecycles, forms, and business process flows. If your Market Maker contact list contains people who have not been qualified through a sales process, those records route to the Lead table in Dynamics 365, creating apparent duplication for teams that only ever used Market Maker's Contact object. We document the routing rule and apply it consistently, but your sales team may see two records for the same person until leads are qualified and converted.

  • Business Process Flow stage probabilities reset on migration

    Dynamics 365 Business Process Flow stage probabilities are set in the BPF designer, not stored per record. When Market Maker deal records map to Opportunities with active BPFs, the stage names carry over but the forecast probability reverts to the BPF default until your Dynamics admin re-tunes the stage weights. Stage history timestamps from Market Maker are preserved in custom datetime fields, so historical stage-entered dates survive the migration, but the operational forecast model needs manual adjustment post-migration.

  • Dataverse API request throttling requires batch sizing discipline

    Dynamics 365 Dataverse API enforces per-user/per-app request limits that vary by license tier and Power Platform environment capacity. Large migrations hitting these limits receive HTTP 429 responses and retry headers. We implement exponential backoff and batch-size reduction dynamically, but high-volume migrations (over 200,000 records) may see extended cutover windows if throttling events accumulate. Your environment's API quota is checked during scoping; environments with low available quota require longer migration windows or staged migration runs.

Migration approach

Six steps for a successful Market Maker to Microsoft Dynamics 365 Sales data migration

  1. Discover source schema and destination license tier

    We export the full Market Maker object and field inventory via API, cataloguing every custom object, relationship type, and activity type. Simultaneously, we read your Dynamics 365 environment type (Sales Professional or Enterprise) to determine the custom table cap. If your Market Maker setup exceeds the Professional 15-table limit, we generate a custom-to-standard-table remapping plan that you approve before migration design begins. The output is a field-level schema diff between source and destination with transformation notes on every non-direct map.

  2. Resolve owner and user identities by email

    Market Maker owner IDs map to Dynamics 365 SystemUser records by email address lookup. We generate a pre-flight owner resolution report listing matched users, unmatched owners, and fallback assignments. Your team either invites unmatched owners to Dynamics 365 before migration or selects a fallback user for orphaned records. No record lands without an owner — the report must clear sign-off before we proceed to data load.

  3. Sequence data load: Accounts → Contacts/Leads → Opportunities → Activities

    Dynamics 365 foreign-key constraints require Accounts before Contacts and Contacts before Opportunities. We sequence the migration in dependency order: Account records first (resolving parent-account chains), then Contact records with AccountId lookups, then Lead records for unqualified prospects, then Opportunities with pipeline-to-BPF mapping and stage-value assignments, then Activities with regardingobjectid resolution. Custom tables migrate after standard tables, respecting the 15-table Professional cap. Each phase produces a validation report showing record counts, error rates, and lookup resolution percentages.

  4. Run sample migration with field-level diff

    A representative slice of 100–500 records migrates first — covering contacts from multiple companies, deals at different stages, and a sample of each activity type. We generate a field-level diff comparing source values to destination values for every mapped column, including custom fields. You review the diff and approve before the full run commits. Common approval blockers at this stage: missing pick-list values that need Dynamics 365 option-set configuration, stage name mismatches that require BPF designer updates, and owner resolution gaps that need additional user invitations.

  5. Execute full migration with delta-pickup window

    The full data set loads into Dynamics 365 using the Dataverse Bulk API for high-volume batches and the Web API for complex relationship writes. A delta-pickup window of 24–48 hours runs concurrently, capturing records modified or created in Market Maker during the cutover period. All operations log to an audit trail with record counts, timestamps, and error details. One-click rollback reverts the Dynamics 365 environment to the pre-migration state if reconciliation fails. After rollback, your team continues in Market Maker while we re-run the migration with corrected mapping.

Platform deep dives

Context on both ends of the pair

Market Maker logo

Market Maker

Source

Strengths

  • USDA-affiliated directory with institutional trust.
  • Free public-facing search and registry.
  • Geographic and commodity-code matching.
  • Multi-state coverage across participating states.
  • USDA-aligned taxonomy for reporting.

Weaknesses

  • Not a true CRM — no pipelines or automation.
  • Geographic coverage limited to participating states.
  • No public developer API.
  • Mobile UX lags commercial directory tools.
  • Pair with a separate CRM for relationship management.
Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

Destination

Strengths

  • Native integration with Microsoft 365, Teams, Outlook, and SharePoint for unified productivity workflow
  • Unlimited custom tables and complex workflows on Enterprise tier enable deep customization for complex sales processes
  • AI-driven predictive analytics and deal intelligence on Enterprise and Premium tiers help sales teams prioritize pipeline
  • Dataverse unified data layer provides a consistent API and data model across all Dynamics 365 and Power Platform apps
  • Strong security model with Field-Level Security and Record Ownership rules for governance-conscious enterprises

Weaknesses

  • Sales Professional tier caps custom tables at 15, creating a migration ceiling for highly customized SMB environments
  • October 2024 pricing increases of $15 per user across all tiers apply to existing customers upon renewal
  • Implementation typically requires costly certified partners, adding 30–50% to total project cost
  • Updates and platform releases can disrupt customizations and plugins, requiring regression testing after each wave
  • Non-Microsoft integrations require additional configuration or middleware, limiting flexibility for heterogeneous tech stacks

Complexity grading

How hard is this migration?

Moderate CRM migration. 5 of 8 objects need a manual workaround.

C

Overall complexity

Moderate migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Market Maker and Microsoft Dynamics 365 Sales .

  • Object compatibility

    F

    5 of 8 objects need a manual workaround.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Market Maker: Not applicable..

  • Data volume sensitivity

    B

    Market Maker doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your Market Maker to Microsoft Dynamics 365 Sales migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Market Maker to Microsoft Dynamics 365 Sales data migrations

Answers to the questions buyers ask most during Market Maker to Microsoft Dynamics 365 Sales migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your Market Maker to Microsoft Dynamics 365 Sales migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most Market Maker-to-Dynamics 365 Sales migrations complete in 48–72 hours for under 50,000 total records. Larger migrations with 500,000+ records or extensive custom-object schemas extend to 5–10 days. The longest planning step is custom field mapping — Market Maker custom properties that need Dataverse custom columns require Dynamics 365 admin coordination for schema creation before data can land. Sales Professional migrations with more than 15 custom objects require additional scoping time for remapping to standard tables.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Market Maker.
Land in Microsoft Dynamics 365 Sales , intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day