Project Management migration
Field-level mapping, validation, and rollback between SMART Project Control and Microsoft Project. We move data and schema; workflows are rebuilt natively in Microsoft Project.
SMART Project Control
Source
Microsoft Project
Destination
Compatibility
8 of 12
objects map 1:1 between SMART Project Control and Microsoft Project.
Complexity
BStandard
Timeline
4-6 weeks
Overview
Moving from SMART Project Control to Microsoft Project is a migration that requires solving the export challenge on the source side before any mapping can begin. SMART Project Control does not publish a public REST or bulk export API; data extraction relies on Oracle Cloud's Functional Setup Manager or direct database export, both of which require offering-scoped role provisioning before scoping starts. On the destination side, Microsoft Project supports up to 10 custom fields per project at the Project Plan 3 and Project Plan 5 tiers, which constrains how many SMART custom fields and WBS custom properties can migrate natively. We handle the Oracle export preparation, map WBS hierarchies to outline codes or summary-task structures, preserve the latest approved baseline as a static snapshot in Microsoft Project's baseline fields, and convert time-distributed S-curve data to data-table rows or earned value table format. Forecasting rules, bottleneck alerting logic, and Oracle-specific integrations do not migrate; we deliver a written inventory of these for the customer's project controls team to rebuild as Microsoft Power BI reports or SharePoint-based dashboards.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a SMART Project Control object lands in Microsoft Project, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
SMART Project Control
Program
Microsoft Project
Master Project or Project Online Portfolio
1:manySMART Project Control Programs act as top-level grouping containers with cross-project rollup reporting. Microsoft Project has no native Program object; we handle the grouping by either creating a Master Project with subproject files (desktop and Project Plan 5) or using Project Online's portfolio grouping in Project for the Web. Cross-project dependencies between programs are flagged as requiring manual rebuild as either cross-project predecessor links or Power BI dependency views.
SMART Project Control
Project
Microsoft Project
Project
1:1Each SMART Project maps to one Microsoft Project file (MPP) or one Project Online project. Core project-level attributes — name, start and finish dates, status, calendar, and schedule mode — migrate 1:1. We flag any project-level custom properties for field-level mapping and verify that the calendar type (standard, 24-hour, night shift) is compatible with Microsoft Project's calendar structure.
SMART Project Control
Baseline
Microsoft Project
Baseline
1:1The latest approved baseline migrates as a static schedule snapshot in Microsoft Project's Baseline fields. SMART stores multiple baselines per project; we migrate the most recently approved baseline as Microsoft Project's Baseline (BL) and flag remaining baselines as Baseline1 through Baseline10 if the destination license supports saved baselines. Earned value source values (PV, EV, SV) are stored as custom fields for reference since the destination engine will recalculate EV independently.
SMART Project Control
Activity
Microsoft Project
Task
1:1Activities are the core scheduling unit in SMART Project Control and map to Tasks in Microsoft Project. Dates, duration, and calendar assignments migrate directly. We rebuild predecessor-successor relationships using Microsoft Project's dependency types (FF, FS, SS, SF), mapping SMART's relationship definitions to the equivalent Finish-to-Start default unless the source uses non-standard dependency types that require explicit mapping.
SMART Project Control
WBS Element
Microsoft Project
Outline Code or Summary Task
1:1WBS elements define hierarchical accountability in SMART Project Control. Microsoft Project does not have a native WBS object; we map WBS levels to Outline Codes (Project Plan 5 or Project Standard/Professional with enterprise features enabled) or use Summary Task indentation as a structural proxy. Element-level custom properties on WBS nodes migrate as custom outline code values or custom fields depending on the destination license tier. We flag any WBS custom fields that exceed the 10-custom-field ceiling for prioritization decisions.
SMART Project Control
Resource
Microsoft Project
Resource
1:1Labor, material, and equipment Resources from SMART — including role definitions, rates, and unit-of-measure — migrate as named resources in Microsoft Project's resource pool. Resource calendars migrate as individual resource calendars attached to the resource. We verify that unit-of-measure conventions match between source and destination and flag any material resource types that may need conversion to a consumable resource model in Microsoft Project.
SMART Project Control
Cost Breakdown Structure
Microsoft Project
Cost Custom Field or Cost Resource
1:1CBS levels and cost accounts map to Microsoft Project's cost coding schema. Time-distributed cost data (period buckets from SMART's cost histogram) is converted to activity-level cost assignments using Microsoft Project's Cost field for labor and a separate material resource for material cost where applicable. We flag CBS levels that exceed a three-level depth for restructure recommendations, as Microsoft Project's flat cost structure is best suited to simpler cost coding hierarchies.
SMART Project Control
Custom Field
Microsoft Project
Custom Field
lossyCustom activity, project, and resource fields export with their current values and types. Microsoft Project (Project Plan 3 and Plan 5) supports up to 10 custom fields per project across Task, Resource, and Project custom field types. We require explicit prioritization from the customer during scoping to select the 10 fields that carry forward natively; remaining custom fields are preserved in a written field inventory for manual entry or Power BI reference post-migration.
SMART Project Control
S-Curve and Progress Curve
Microsoft Project
Earned Value Data Table or Time-Phased Data
1:1Cumulative S-curves and progress curves export from SMART Project Control as time-phased data rows per project. On import, we convert them to Microsoft Project's Earned Value table format (PV, EV, AC at each data point) or store as time-phased data table rows if the destination version supports it. We validate the S-curve reconstruction against the source by comparing total project cost and milestone alignment before sign-off.
SMART Project Control
Critical Path and Float
Microsoft Project
Critical Path and Total Slack
1:1Critical path and float values are preserved when Microsoft Project recalculates the schedule post-import. We document the expected critical path from the SMART source schedule as a reference document and validate that the destination's scheduling engine produces an equivalent critical path within a defined float tolerance (typically one day per activity). Non-critical path relationships that reference activities on the critical path are flagged for review.
SMART Project Control
Earned Value Metrics
Microsoft Project
Custom Reference Fields
lossyEarned value planned value, earned value, schedule variance, and cost variance are often stored as derived metrics in SMART rather than raw fields. We preserve the source-calculated EV values as static custom fields on the Task record so the customer has an audit trail of the source values. Microsoft Project's EV engine will recalculate independently; we document the variance between source and destination EV values as part of the validation report so the project controls team can assess materiality.
SMART Project Control
Forecasting and Bottleneck Alerts
Microsoft Project
Documentation (no native migration)
lossyForecasting rules and bottleneck alerting logic are SMART Project Control features with no Microsoft Project equivalent. We deliver a written inventory of every active forecast and alert rule, including its trigger conditions, threshold values, and notification action, so the customer's project controls team can rebuild these as Power BI threshold alerts, SharePoint workflow notifications, or Planner task rules depending on the Microsoft tooling in use.
| SMART Project Control | Microsoft Project | Compatibility | |
|---|---|---|---|
| Program | Master Project or Project Online Portfolio1:many | Fully supported | |
| Project | Project1:1 | Fully supported | |
| Baseline | Baseline1:1 | Fully supported | |
| Activity | Task1:1 | Fully supported | |
| WBS Element | Outline Code or Summary Task1:1 | Fully supported | |
| Resource | Resource1:1 | Fully supported | |
| Cost Breakdown Structure | Cost Custom Field or Cost Resource1:1 | Mapping required | |
| Custom Field | Custom Fieldlossy | Fully supported | |
| S-Curve and Progress Curve | Earned Value Data Table or Time-Phased Data1:1 | Fully supported | |
| Critical Path and Float | Critical Path and Total Slack1:1 | Mapping required | |
| Earned Value Metrics | Custom Reference Fieldslossy | Fully supported | |
| Forecasting and Bottleneck Alerts | Documentation (no native migration)lossy | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
SMART Project Control gotchas
No publicly documented migration or export API
Offering-scoped exports block multi-offering implementations
Earned Value metrics require manual recalculation post-migrate
Microsoft Project gotchas
Project for the web is being retired and merged into Microsoft Planner
Planner-tier portfolio features are incomplete despite Plan 5 labeling
Web app constraint controls are weaker than the Windows desktop client
Project requires a separate license not bundled with standard Microsoft 365
Project Online API is edition-gated and inconsistently documented
Pair-specific challenges
Migration approach
Oracle export preparation and source environment audit
We work with the customer's Oracle Cloud administrator to provision the data export roles required for SMART Project Control extraction. We audit the source environment: Programs, Projects, Baselines, Activities, WBS hierarchies, Resources (with calendars and rates), CBS levels, S-curve time-phase data, and custom field definitions. We confirm the number of Oracle Cloud offerings in scope and prepare separate export workstreams per offering if the implementation spans multiple offerings. The audit output is a written migration scope, a custom field prioritization list (required because Microsoft Project limits to 10 per project), and an Oracle export runbook for the customer's administrator to execute.
Destination schema design for Microsoft Project
We design the Microsoft Project target structure: resource pool with calendars and rates, outline code structures for WBS mapping, custom field assignments (top 10 per project by priority), baseline field mapping, and CBS cost field assignments. For organizations using Project Online or Project for the Web, we design the portfolio grouping structure to replace the SMART Program hierarchy. The schema design is documented in a written specification for customer sign-off before any test migration begins. We also confirm the target Microsoft Project version and license tier to ensure the schema design is compatible with the available field types.
Oracle export execution and data validation
The customer's Oracle Cloud administrator executes the export using the runbook we provide. We validate the exported packages: record counts per object (Programs, Projects, Activities, Resources), WBS hierarchy depth, CBS level count, S-curve data point density, and custom field completeness. We cross-check that the export contains all active projects and that any archived or completed projects flagged for migration are included. Discrepancies between the audit and the export are reconciled before test migration begins.
Test migration and reconciliation
We run a full test migration into a staging Microsoft Project environment using production-like data volume. We reconcile record counts (activities in, tasks out, predecessor links validated), WBS hierarchy fidelity (outline code levels match source depth), resource pool completeness (all named resources with calendars and rates), and S-curve reconstruction (total project cost and milestone alignment against source). Critical path output is compared against the source schedule's expected critical path. The customer's project controls lead reviews and signs off the test migration output before production cutover is scheduled.
Production migration and cutover
We run production migration in dependency order: resource pool first, then projects with calendars and baselines, activities mapped to tasks with predecessor-successor relationships, CBS cost assignments, S-curve time-phase data, and custom fields (top 10 by priority). Programs are structured as master project or portfolio grouping per the signed schema design. We freeze writes on the source SMART Project Control environment during the cutover window, run a final delta migration of any records modified during migration, and enable Microsoft Project as the system of record. We deliver the forecasting and bottleneck alert inventory document to the customer's project controls team for post-migration rebuild.
Validation, cutover report, and rebuild handoff
We validate the production migration against the test baseline: record counts, relationship integrity, critical path fidelity, and S-curve totals. We deliver a written migration report with mapping decisions, any data that could not migrate natively (and the workaround or manual entry path), and the inventory of WBS custom fields, CBS structures, and alerting rules requiring rebuild. We do not rebuild Forecasting, Bottleneck Alerts, or Oracle-specific integrations as part of the migration scope; these are documented for the customer's project controls team to rebuild using Microsoft Power BI, SharePoint, or Planner-based alternatives.
Platform deep dives
SMART Project Control
Source
Strengths
Weaknesses
Microsoft Project
Destination
Strengths
Weaknesses
Complexity grading
Standard Project Management migration. 1 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across SMART Project Control and Microsoft Project.
Object compatibility
1 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
SMART Project Control: Not publicly documented.
Data volume sensitivity
SMART Project Control doesn't expose a bulk API — REST + parallelization used for high-volume runs.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during SMART Project Control to Microsoft Project migration scoping. Not seeing yours? Book a call.
Walk through your SMART Project Control to Microsoft Project migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave SMART Project Control
Other ways to arrive at Microsoft Project
Same-Project Management migrations
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.