Project Management migration

Migrate from SMART Project Control to Microsoft Project

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 logo

SMART Project Control

Source

Microsoft Project

Destination

Microsoft Project logo

Compatibility

67%

8 of 12

objects map 1:1 between SMART Project Control and Microsoft Project.

Complexity

BStandard

Timeline

4-6 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

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

SMART Project Control logo

SMART Project Control

What's pushing teams away

  • SmartPM is an analytics overlay, not a scheduling engine — teams that want to do the actual CPM planning inside one tool still need P6, MS Project, Asta, or Phoenix and end up evaluating integrated all-in-one alternatives.
  • Verticalized to commercial construction — non-construction project portfolios get little value from the construction-specific metrics (SPI, compression, critical path delays in CPM terms).
  • $12K-$25K annual pricing is fair for portfolios of 50+ projects but expensive for small contractors with under 10 active jobs.
  • Schedule data must come from one of the supported scheduling tools — teams running niche or in-house scheduling engines have no clean ingest path.
  • Smaller market presence than Oracle Primavera Unifier or Procore — buyers comparing against enterprise PM suites face fewer reference customers and a thinner ecosystem.

Choosing

Microsoft Project logo

Microsoft Project

What's pulling them in

  • Organizations already running Microsoft 365 and Azure AD adopt Microsoft PPM because it slots into existing identity, Teams, and SharePoint infrastructure without requiring a separate identity provider or SSO vendor.
  • Enterprise PMOs choose it for critical-path scheduling, baseline comparison, cross-project dependencies, and resource utilization reporting that standalone PM tools cannot replicate at this depth.
  • Project Online's integration with Power BI gives portfolio-level dashboards and cost-rollup reporting that satisfies executive governance requirements without third-party BI tooling.
  • Government, financial services, and healthcare organizations select it because FedRAMP, ISO 27001, and SOC 2 compliance certifications meet enterprise procurement requirements out of the box.
  • Large IT departments default to it as the market-leader in project portfolio management software, often driven by corporate licensing agreements that bundle it with other Microsoft 365 seats.

Object mapping

How SMART Project Control objects map to Microsoft Project

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

maps to

Microsoft Project

Master Project or Project Online Portfolio

1:many
Fully supported

SMART 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

maps to

Microsoft Project

Project

1:1
Fully supported

Each 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

maps to

Microsoft Project

Baseline

1:1
Fully supported

The 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

maps to

Microsoft Project

Task

1:1
Fully supported

Activities 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

maps to

Microsoft Project

Outline Code or Summary Task

1:1
Fully supported

WBS 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

maps to

Microsoft Project

Resource

1:1
Fully supported

Labor, 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

maps to

Microsoft Project

Cost Custom Field or Cost Resource

1:1
Mapping required

CBS 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

maps to

Microsoft Project

Custom Field

lossy
Fully supported

Custom 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

maps to

Microsoft Project

Earned Value Data Table or Time-Phased Data

1:1
Fully supported

Cumulative 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

maps to

Microsoft Project

Critical Path and Total Slack

1:1
Mapping required

Critical 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

maps to

Microsoft Project

Custom Reference Fields

lossy
Fully supported

Earned 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

maps to

Microsoft Project

Documentation (no native migration)

lossy
Fully supported

Forecasting 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.

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.

SMART Project Control logo

SMART Project Control gotchas

High

No publicly documented migration or export API

Medium

Offering-scoped exports block multi-offering implementations

Medium

Earned Value metrics require manual recalculation post-migrate

Microsoft Project logo

Microsoft Project gotchas

High

Project for the web is being retired and merged into Microsoft Planner

Medium

Planner-tier portfolio features are incomplete despite Plan 5 labeling

Medium

Web app constraint controls are weaker than the Windows desktop client

High

Project requires a separate license not bundled with standard Microsoft 365

Medium

Project Online API is edition-gated and inconsistently documented

Pair-specific challenges

  • Oracle Cloud export prerequisites must be resolved before scoping begins

    SMART Project Control does not publish a public REST or bulk export API. Data extraction requires Oracle Cloud Functional Setup Manager configuration package exports or direct database exports, both of which require offering-scoped Oracle Cloud roles to be provisioned. We coordinate with the customer's Oracle Cloud administrator to grant the necessary data export roles before migration scoping begins. Without this step, there is no extract path and the migration cannot proceed. This typically adds three to five business days to project initiation.

  • Microsoft Project custom field ceiling is 10 per project

    SMART Project Control implementations often accumulate 15-30 custom fields per project across WBS element properties, activity-level metadata, and cost account attributes. Microsoft Project (Project Plan 3 and Plan 5) caps custom fields at 10 per project. We work with the customer during scoping to identify the 10 highest-value custom fields for native migration and document the remainder in a field inventory for manual post-migration entry or Power BI reference. Implementations with fewer than 10 custom fields migrate cleanly without prioritization work.

  • Programs require structural redesign as Microsoft Project has no Program object

    SMART Project Control Programs provide top-level grouping with cross-project rollup reporting. Microsoft Project does not have a native Program object. We map Programs to either a Master Project structure with subproject files (desktop and Project Plan 5) or to Project Online portfolio grouping in Project for the Web. Cross-project dependencies that span programs need to be manually rebuilt as external predecessor links or as Power BI dependency mapping. This is a design decision made during scoping that affects the entire portfolio structure.

  • Baseline data migrates as a static snapshot; EV engine recalculates independently

    SMART Project Control stores baseline snapshots with earned value calculations attached. We migrate the latest approved baseline as Microsoft Project's baseline fields with activity dates and durations preserved. Microsoft Project's Earned Value engine recalculates EV from the baseline and actual data post-import; the results may differ from SMART's original EV figures due to differences in calculation methodology. We preserve SMART's original EV values as custom reference fields and document the variance as part of the cutover validation report.

  • Multi-offering Oracle implementations require separate export packages per offering

    Oracle Cloud's data export framework operates per offering. If the SMART Project Control implementation spans more than one Oracle Cloud offering, we must create separate implementation projects — one per offering — to produce ordered export packages. This adds a preparation step to the scoping phase but does not affect the actual data migration work once exports are available. Single-offering implementations do not encounter this constraint.

Migration approach

Six steps for a successful SMART Project Control to Microsoft Project data migration

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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

Context on both ends of the pair

SMART Project Control logo

SMART Project Control

Source

Strengths

  • Purpose-built for schedule-critical industries with integrated critical path method calculations
  • Groups work under Programs and Portfolios for enterprise-wide visibility and rollup reporting
  • Supports baseline management for schedule change tracking and earned value analysis
  • Provides forecasting and bottleneck alerting to surface delays before they cascade
  • Integrates with Oracle Cloud infrastructure for enterprise SSO and role-based access control

Weaknesses

  • No public REST or bulk export API — data extraction depends on Oracle's Functional Setup Manager framework
  • Limited community presence and few independent reviews, making feature verification harder pre-migration
  • Primarily Oracle Cloud-centric — self-hosted or hybrid deployments have fewer migration tool options
  • Custom field and CBS structure variations between implementations require bespoke mapping work
  • Steep learning curve for teams without prior project controls or Primavera-style scheduling experience
Microsoft Project logo

Microsoft Project

Destination

Strengths

  • Deep critical-path scheduling with baseline comparison and cross-project dependency tracking unmatched by lighter PM tools.
  • Native Azure AD authentication, Teams integration, and Power BI reporting sit on infrastructure enterprises already license and manage.
  • Enterprise governance controls including demand intake workflows, resource request approval, and portfolio-level capacity analysis.
  • Supports both Waterfall and Agile methodologies within the same project, accommodating hybrid delivery teams.
  • Scalable from Project Plan 1 for small teams to Project Server on-premises for regulated industries with strict data-sovereignty requirements.

Weaknesses

  • Ease-of-use scores trail the category average by a wide margin; onboarding friction frustrates new users consistently across G2 and Capterra reviews.
  • Pricing ranks 42nd of 49 tools in its category — the total cost of ownership including IT administration and training is rarely recovered for small or mid-market teams.
  • No built-in client portal, external stakeholder sharing, or proofing workflow, limiting use cases to internal PMO environments only.
  • The web interface (Project for the web / Planner Premium) has materially weaker constraint controls and resource auto-leveling than the Windows desktop client.
  • Project for the web is being consolidated into Microsoft Planner, creating uncertainty about which product tier will host project portfolio data long-term.

Complexity grading

How hard is this migration?

Standard Project Management migration. 1 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across SMART Project Control and Microsoft Project.

  • Object compatibility

    B

    1 of 8 objects need a mapping; the rest are 1:1.

  • 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

    SMART Project Control: Not publicly documented.

  • Data volume sensitivity

    B

    SMART Project Control doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your SMART Project Control to Microsoft Project 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 SMART Project Control to Microsoft Project data migrations

Answers to the questions buyers ask most during SMART Project Control to Microsoft Project migration scoping. Not seeing yours? Book a call.

Can't find your answer?

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 consultation

Most tier 2 project management migrations land between four and six weeks for environments with under 20 projects, fewer than 5,000 activities, and a single Oracle Cloud offering. Multi-program implementations exceeding 50 projects, complex WBS hierarchies, CBS cost rollups, or S-curve time-phase data requiring transformation extend to eight to twelve weeks. The Oracle Cloud export preparation step adds three to five business days to project initiation regardless of scope.

Adjacent paths

Related migrations to explore

Ready when you are

Move from SMART Project Control.
Land in Microsoft Project, 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