CRM migration

Migrate from Core Practice to Microsoft Dynamics 365 Sales

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

Core Practice logo

Core Practice

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

100%

10 of 10

objects map 1:1 between Core Practice and Microsoft Dynamics 365 Sales .

Complexity

BStandard

Timeline

72–96 hours

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Core Practice is a cloud-based dental practice management system built around patients, appointments, and treatment records. It lacks the pipeline management, forecasting, and reporting depth that sales teams and multi-location practices need. Dynamics 365 Sales is Microsoft's CRM platform built on Dataverse — it uses Account and Contact as the core objects, supports custom tables, and integrates natively with Microsoft 365, Power Platform, and Copilot for Sales. The migration challenge is significant: Core Practice stores clinical and operational data with no direct equivalent in a CRM object model. We extract Core Practice records via its API, map patient records to Dynamics 365 Contact entities, adapt treatment and appointment history to custom tables, and surface billing data as Account-level custom fields or Opportunity records depending on revenue intent. Owner resolution happens by email match against Dynamics 365 users. A delta-pickup window captures in-flight records during cutover, and a sample migration with field-level diff runs before the full commit. We do not migrate appointment-scheduling automations, clinical workflows, or treatment-plan templates — those are practice-management logic that must be rebuilt in Dynamics 365's model-driven apps or Power Apps.

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

Core Practice logo

Core Practice

What's pushing teams away

  • Excessive clicks and overcomplicated workflows frustrate staff and slow down appointment booking.
  • Patients are reported lost due to poor data integrity and unreliable patient record management.
  • The platform scores poorly on ease of use, value for money, and customer service compared to competitors.
  • Low review volume (6 verified reviews) suggests limited adoption and a lack of community resources.
  • Users report the software is useless at making appointments, directly undermining core dental practice operations.

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 Core Practice objects map to Microsoft Dynamics 365 Sales

Each row shows how a Core Practice 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.

Core Practice

Patient

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

Core Practice Patient records map directly to Dynamics 365 Contact. Each patient becomes one Contact with the practice's contact details (name, phone, email, address) mapped field by field. The patient's primary email is used as the unique match key for owner resolution against Dynamics 365 users.

Core Practice

Patient

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

In Dynamics 365 Sales, Accounts represent organizations. If Core Practice stores a referring practice or clinic name alongside the patient record, we surface that as a lookup to an Account. Solo practitioners without organizational records get a default 'Individual Patient' Account to satisfy Dynamics 365's AccountId relationship on Contact.

Core Practice

Treatment Record

maps to

Microsoft Dynamics 365 Sales

Custom Table: TreatmentHistory__c

1:1
Fully supported

Core Practice treatment records (procedure codes, dates, provider, notes) have no standard Dynamics 365 equivalent. We create a custom TreatmentHistory table with fields for procedure code, treatment date, provider name, tooth/quadrant reference, and clinical notes. A lookup to Contact preserves the patient relationship.

Core Practice

Appointment

maps to

Microsoft Dynamics 365 Sales

Custom Table: Appointment__c

1:1
Fully supported

Appointment data (date, time, duration, appointment type, provider, status) migrates to a custom Appointment table linked to Contact. Note that Dynamics 365 Sales has no native scheduling — appointment slots do not become CRM calendar events automatically; we preserve the data for reporting and Power Apps rebuild.

Core Practice

Billing / Invoice

maps to

Microsoft Dynamics 365 Sales

Opportunity or Custom Table: Billing__c

1:1
Fully supported

If the practice generates per-patient revenue tracked in Core Practice, we map that to a Dynamics 365 Opportunity with Amount reflecting total billed value and a 'Treatment Completed' stage. Practices focused on reporting rather than pipeline management use a custom Billing table instead.

Core Practice

Provider / Staff

maps to

Microsoft Dynamics 365 Sales

User or Contact

1:1
Fully supported

Core Practice providers and staff are resolved by email against Dynamics 365 Sales users. If a Core Practice staff member does not have a Dynamics 365 license, their records are stored as Contact entities with a 'Provider' role custom field for identification.

Core Practice

Patient Notes / Clinical Notes

maps to

Microsoft Dynamics 365 Sales

Annotation (Note) on Contact

1:1
Fully supported

Core Practice clinical notes attached to patient records migrate as Dynamics 365 Annotations linked to the corresponding Contact. We preserve original note timestamps and author information. Rich-text formatting is maintained where the source data supports it.

Core Practice

Insurance / Payer Information

maps to

Microsoft Dynamics 365 Sales

Custom Field on Contact + Account

1:1
Fully supported

Insurance carrier name, policy number, group number, and coverage type from Core Practice migrate to custom fields on Contact (Insurance_Carrier__c, Policy_Number__c, Group_Number__c, Coverage_Type__c). Practices managing multiple payers per patient use a related custom Insurance custom table.

Core Practice

Treatment Plan

maps to

Microsoft Dynamics 365 Sales

Custom Table: TreatmentPlan__c

1:1
Fully supported

Proposed or scheduled treatment plans from Core Practice migrate to a custom TreatmentPlan table linked to Contact. Each plan line maps to a TreatmentPlanLine custom table with procedure code, estimated cost, and status. Planned vs. completed treatment is distinguished by a status pick-list.

Core Practice

Patient Attachments / X-Rays

maps to

Microsoft Dynamics 365 Sales

SharePoint / Dynamics 365 Attachments

1:1
Fully supported

Core Practice file attachments (X-rays, consent forms, images) are downloaded and re-uploaded to Dynamics 365's native file storage connected to the Contact record. File size limits of Dynamics 365 apply (default 25MB per file); large imaging files may require SharePoint document library integration.

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.

Core Practice logo

Core Practice gotchas

High

No publicly documented public API for direct data extraction

High

Proprietary patient archiving logic can silently drop records

Medium

Appointment booking reliability is a documented weakness

Medium

Limited review volume limits migration confidence

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

  • Core Practice has no standard CRM object model — every export requires custom table creation in Dynamics 365 Sales

    Core Practice is a practice-management system, not a CRM. Its primary objects (Patient, Treatment, Appointment, Billing) have no native equivalents in Dynamics 365 Sales. Before migration data can land, your Dynamics admin must create custom tables in Dataverse for TreatmentHistory, Appointment, TreatmentPlan, and Billing. Dynamics 365 Sales Professional enforces a 15-table limit — practices needing more than 15 custom entities must upgrade to Enterprise ($105/user/mo) before migration proceeds. We provide the exact table schemas and field definitions as part of the migration plan so your admin can pre-create the structure.

  • Appointment scheduling does not migrate to Dynamics 365 Sales — scheduling must be rebuilt in Bookings or a third-party app

    Core Practice stores appointment records with date, time, provider, and status. Dynamics 365 Sales has no native scheduling engine — appointment records migrate as historical data but the appointment-scheduling workflow requires a separate rebuild. Microsoft Bookings is the native path for Dynamics 365 environments, but it is a separate product requiring additional licensing and setup. We preserve all appointment history as data but do not migrate active scheduling logic, recurring appointment rules, or calendar-sync configurations. This must be addressed in the post-migration Power Apps or Bookings setup phase.

  • Insurance and payer data requires custom fields on Contact with no native Dynamics 365 equivalent

    Dental and specialist practices using Core Practice store insurance carrier, policy number, group number, subscriber ID, and coverage percentages per patient. Dynamics 365 Sales has no standard insurance or payer fields on Contact. We create custom text fields (Insurance_Carrier__c, Policy_Number__c, Group_Number__c) and optionally a related Insurance custom table for multi-payer scenarios. However, these custom fields do not integrate with Dynamics 365's native billing or finance modules — they are reference fields only. Practices needing insurance-claims integration must evaluate Dynamics 365 Fraud Protection or a third-party dental billing connector.

  • Owner resolution by email fails for staff without Dynamics 365 user licenses

    Core Practice providers and administrative staff are assigned as record owners in the source system. Dynamics 365 Sales requires a licensed User record to own a Contact, Account, or Opportunity. We resolve Core Practice staff to Dynamics 365 users by email match. Staff members without a matching Dynamics 365 user are flagged before migration — their patient and treatment records land as Contacts owned by a designated fallback user. This means provider attribution in migrated treatment history may require a post-migration data patch once licensing is settled.

  • Treatment-plan and clinical-note attachments face file-size and format constraints in Dynamics 365

    Core Practice attachments — X-rays, intraoral images, consent forms, PDF treatment plans — migrate to Dynamics 365 file storage linked to Contact records. Dynamics 365's default file size limit is 25MB per file; dental imaging files commonly exceed this. We chunk large files and upload to the associated SharePoint document library connected to the Contact rather than inline attachments. Intraoral image formats (JPEG, PNG, DICOM) are preserved as-is. Practices using DICOM imaging may need a dedicated medical imaging storage integration post-migration.

Migration approach

Six steps for a successful Core Practice to Microsoft Dynamics 365 Sales data migration

  1. Extract Core Practice data via API and document the schema

    FlitStack AI authenticates against Core Practice's API to export all patient records, treatment histories, appointments, billing entries, and attachments. We generate a schema inventory listing every field, data type, and pick-list value in use. This inventory drives the Dynamics 365 schema preparation phase and identifies which custom tables need to be created before data lands.

  2. Prepare Dynamics 365 custom tables and fields

    Based on the schema inventory, your Dynamics 365 admin (or our team) creates the required custom tables in Dataverse: TreatmentHistory, Appointment, TreatmentPlan, TreatmentPlanLine, and Billing. Insurance fields are added to Contact. We deliver a detailed setup guide specifying table names, field types, pick-list values, and relationships so the schema is ready before validation runs. If your setup uses Sales Professional, we confirm table count stays within the 15-table limit.

  3. Resolve Core Practice staff to Dynamics 365 users by email

    We match Core Practice provider and staff records against Dynamics 365 user accounts by email address. Unmatched staff are flagged and routed to a designated fallback owner. Owner resolution is validated during the sample migration — any unresolved staff appearing in patient or treatment records surface before the full run commits.

  4. Run sample migration with field-level diff

    A representative slice of 100–500 Core Practice records migrates first — spanning patients with treatment history, appointments, and billing. We generate a field-level diff comparing source values against the Dynamics 365 records, verifying patient name mapping, treatment date preservation, appointment status value mapping, and owner resolution. You review the diff before the full migration proceeds.

  5. Execute full migration with delta-pickup window

    Full migration runs against your Dynamics 365 environment. A delta-pickup window (typically 24–48 hours) captures any Core Practice records created or modified during the cutover. All operations are logged in an audit trail. If reconciliation reveals discrepancies, one-click rollback reverts the target environment to its pre-migration state so corrections can be applied and the run re-executed.

Platform deep dives

Context on both ends of the pair

Core Practice logo

Core Practice

Source

Strengths

  • Cloud-based with no server maintenance or upfront capital costs.
  • No lock-in contracts allow month-to-month commitment.
  • Australian-hosted infrastructure for local data residency compliance.
  • All-in-one bundling of commercial, clinical, and clerical functions.
  • Real-time access from any device for multi-location practices.

Weaknesses

  • Extremely low review rating (2.7/5) indicating widespread user dissatisfaction.
  • Only 6 verified reviews exist, making independent evaluation difficult.
  • Poor ease-of-use scores (3.0/5) reflect overcomplicated workflows.
  • Weak customer service ratings (2.6/5) from the small reviewer base.
  • Minimal third-party integrations and limited API documentation published.
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?

Standard CRM migration. All 8 core objects map 1:1 between Core Practice and Microsoft Dynamics 365 Sales .

B

Overall complexity

Standard migration

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

  • Object compatibility

    A

    All 8 core objects map 1:1 between Core Practice and Microsoft Dynamics 365 Sales .

  • 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

    Core Practice: Not publicly documented.

  • Data volume sensitivity

    B

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

Estimator

Estimate your Core Practice 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 Core Practice to Microsoft Dynamics 365 Sales data migrations

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

Can't find your answer?

Walk through your Core Practice 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 Core Practice to Dynamics 365 Sales migrations complete within 72–96 hours for under 25,000 patient records with standard field mapping. Larger practices with 25,000+ records, multiple custom tables, or complex treatment history structures extend to 8–14 days. The longest step is typically Dynamics 365 schema preparation — creating custom tables and fields in Dataverse before data can be imported — which we complete in parallel with migration planning.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Core Practice.
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