Project Management migration

Migrate from Synergy to Microsoft Project

Field-level mapping, validation, and rollback between Synergy and Microsoft Project. We move data and schema; workflows are rebuilt natively in Microsoft Project.

Synergy logo

Synergy

Source

Microsoft Project

Destination

Microsoft Project logo

Compatibility

90%

9 of 10

objects map 1:1 between Synergy and Microsoft Project.

Complexity

BStandard

Timeline

3-5 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from Synergy to Microsoft Project is a migration from a vertically integrated AEC platform to a generalist scheduling tool, and the gap between those models shapes every decision. Synergy's developer API covers Projects and Tasks but omits Contacts, Activities, and Attributes, so those objects rely on the native JSON import/export bundle rather than a REST endpoint. We snapshot the full custom field schema including null fields before migration begins, because Synergy's API only returns non-empty custom fields and silent schema holes are the most common post-migration cleanup item. Microsoft Project structures work around a Work Breakdown Structure, task dependencies, and a Resource Sheet; Synergy's Job Structure (folder layouts, naming rules, folder-level permissions, and issue types) maps partially to these concepts but requires manual rebuild of permission-level configurations. Workflows, automations, approval chains, and custom reporting do not migrate; we deliver a written inventory of every Synergy Workflow and report for the customer's PMO admin to rebuild in Microsoft Project or Power Automate.

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

Synergy logo

Synergy

What's pushing teams away

  • Custom reporting produces inconsistent results and unreliable data, forcing teams to manually cross-check financial summaries against exported spreadsheets rather than trusting the built-in reports.
  • The user interface is widely described as unintuitive and complex, with a steep learning curve that frustrates new users and requires significant internal training investment to achieve basic competency.
  • Sync with QuickBooks Online can break silently when chart of accounts structures diverge between systems, leading to miscategorized expenses that are difficult to trace back and reconcile without dedicated accounting review.
  • Support response times are inconsistent, with some customers reporting multi-day delays on critical issues and a perceived gap between the quality of documentation and the depth of assistance available for edge cases.

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 Synergy objects map to Microsoft Project

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

Synergy

Project

maps to

Microsoft Project

Project (MPP) or Project for the Web Project

1:1
Fully supported

Synergy Projects map 1:1 to Microsoft Project files or Project for the Web Projects. We extract Project-level metadata including creation timestamps, project status, custom fields, and project-level notes. The destination Project is created before any Task import so that the file or database reference is available during Task load. If the customer uses Project Online or Project for the Web, we provision the project via the PWA REST API with project properties set from the Synergy source.

Synergy

Task

maps to

Microsoft Project

Task

1:1
Fully supported

Synergy Tasks map 1:1 to Microsoft Project Tasks with hierarchy preserved. We extract the full WBS (Work Breakdown Structure) numbering, parent-child relationships, start and finish dates, duration, percent complete, and predecessor dependencies. In Microsoft Project, predecessor links become predecessor task relationships (Finish-to-Start, Start-to-Start, etc.). We map Synergy's custom fields per Task to Microsoft Project enterprise custom fields or local custom fields, and we snapshot the complete custom field schema before migration to restore any null fields that Synergy's API omits from output.

Synergy

Custom Fields

maps to

Microsoft Project

Custom Fields (local or enterprise)

lossy
Mapping required

Synergy custom fields (text, number, currency, date, dropdown, multi-select) map to Microsoft Project local custom fields or Project Online enterprise custom fields. We pre-snapshot the complete custom field schema including null and unset fields, because Synergy's API omits empty custom fields from JSON output and the Microsoft Project CustomFields collection has the same behavior. We use the pre-snapshot to ensure every field defined in Synergy has a corresponding custom field in Microsoft Project, populated with type-appropriate defaults for null values. Dropdown fields in Synergy require lookup table creation in Microsoft Project before the task import runs.

Synergy

Job Structure

maps to

Microsoft Project

WBS Outline and Summary Tasks

1:1
Mapping required

Synergy's Job Structure defines folder layouts, naming rules, folder-level permissions, issue types, and dashboard configurations that are tightly coupled to individual firm setups. Microsoft Project has no direct equivalent of folder-level permissions or firm-specific issue types. We extract the Job Structure as a manifest with the full folder hierarchy, apply naming conventions to the WBS outline where Microsoft Project supports them, and flag folder-level permission models and issue type configurations as requiring manual rebuild in SharePoint permissions or Microsoft Teams channels post-migration.

Synergy

File and Versions

maps to

Microsoft Project

SharePoint Document Library or OneDrive for Business

1:1
Fully supported

Synergy files include content, all versions, change records (who and when), and file-level permissions. Microsoft Project stores files in SharePoint or OneDrive, with version history managed at the SharePoint level. We transfer binary file content alongside version history metadata and change records, linking the SharePoint file URL to the corresponding Synergy Project or Task via a custom field in Microsoft Project. 12d Model project files are supported as binary transfers without native viewer migration.

Synergy

Contact

maps to

Microsoft Project

Resource Sheet (Workforce) or SharePoint Contact List

1:1
Fully supported

Synergy Contacts are stored in the platform but the public API does not expose a Contacts endpoint. We access Contacts via the native import/export JSON bundle which auto-collects associated groups and contact attributes. In Microsoft Project, there is no native Contact object; we map Contacts to Resources in the Resource Sheet (for team members assigned to tasks) or to a linked SharePoint Contact List (for clients and external stakeholders). Contact-to-resource mapping is done by email match.

Synergy

Team

maps to

Microsoft Project

Resource Sheet and Project Team

1:1
Fully supported

Synergy Teams define group-level permissions and role assignments for Projects and Jobs. The native import/export tool handles Teams as part of the metadata bundle. Microsoft Project does not have a standalone Team object; team membership is represented through task assignments and the Resource Sheet. We extract team roles and map them to Microsoft Project resource roles (generic resources, material resources, or cost resources), and flag role-based permission configurations for manual rebuild in SharePoint site permissions or Azure Active Directory groups.

Synergy

Association

maps to

Microsoft Project

Task Notes and Hyperlink

1:1
Fully supported

Synergy Associations link Jobs, Tasks, and other objects to form cross-reference relationships that reflect cross-project dependencies. Microsoft Project has no native cross-record association object. We map these relationships to Task Notes (for inline references) or Hyperlinks (for external document links) and provide a written cross-reference manifest for the customer's PMO admin to rebuild as formal cross-project dependencies in Microsoft Project or as items in a linked Excel resource.

Synergy

Engagement (Activities)

maps to

Microsoft Project

Task Notes or SharePoint List

1:1
Fully supported

Synergy stores activity records (calls, emails, meetings, tasks) that do not have a public API endpoint. The native import/export bundle bundles these as part of the job and folder metadata package. Microsoft Project does not have a native Activity timeline equivalent; we map engagement records to Task Notes (for inline activity context) or export them to a SharePoint list linked to the Project, preserving the activity type, date, and associated contact or team member. Customers requiring full activity history as importable records should plan a SharePoint-based activity log as the destination.

Synergy

Attribute

maps to

Microsoft Project

Custom Fields or Task Notes

1:1
Fully supported

Synergy Attributes store metadata values tied to Jobs, Tasks, and Files. They are collected automatically by the import/export tool as part of the job and folder metadata package. Microsoft Project has no standalone Attribute object; we map Attribute key-value pairs to Microsoft Project custom fields (if the attribute applies to a project or task) or to Task Notes (for contextual annotations). Attribute naming conventions are preserved as field names or note prefixes in the destination.

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.

Synergy logo

Synergy gotchas

High

Only non-empty custom fields appear in API output

High

Public API lacks endpoints for Contacts and Activities

Medium

Job Structure complexity varies by firm configuration

Medium

Custom reports may not translate to destination platforms

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

  • Synergy's API omits empty custom fields, creating silent schema gaps in Microsoft Project

    Both Synergy and Microsoft Project share the behavior of returning only non-empty custom fields in API output and collection queries. When migrating from Synergy to Microsoft Project, the combined effect means that if a custom field is null in Synergy, it is absent from the source API response and also absent from the Microsoft Project CustomFields collection after import. We prevent this by snapshotting the complete Synergy custom field schema before migration, including field type metadata and null status, then pre-provisioning every custom field in Microsoft Project with type-appropriate defaults before any task data is loaded. Without this pre-snapshot, fields that the firm configured in Synergy vanish silently in Microsoft Project and require post-migration schema repair.

  • Synergy Contacts, Activities, and Attributes lack public API endpoints, requiring JSON bundle reconciliation

    The developer API at developers.totalsynergy.com exposes Projects and Tasks but does not document Contacts, Teams, Activities, or Attributes as addressable endpoints. Any migration touching these objects must rely on the native import/export JSON bundle, which handles associations and group memberships automatically but offers no granular filtering, no incremental sync, and no bulk query capability. We scope Contacts as a JSON bundle import into a SharePoint Contact List or Microsoft Project Resource Sheet, and we scope Activities as SharePoint list items linked to the migrated project. The customer should validate contact and activity record counts against the source export manifest before sign-off.

  • Job Structure permissions and issue types do not map to Microsoft Project equivalents

    Synergy's Job Structure includes folder-level permissions, issue types, and dashboard configurations that are deeply tied to individual firm setups. Microsoft Project has no equivalent of firm-specific folder permissions, issue type taxonomies, or project-level dashboard configurations. We extract the full Job Structure as a manifest and rebuild the WBS outline and naming rules in Microsoft Project, but folder-level permissions must be manually rebuilt in SharePoint site permissions and issue types must be reconstructed in a linked SharePoint Issues List or Microsoft Planner bucket. We flag all unsupported permission models and issue type configurations in the migration manifest for the customer's PMO admin to address before go-live.

  • Workflows, approval chains, and automation do not migrate to Microsoft Project

    Synergy's workflow automation engine handles approval chains, resource assignments, and status transitions across project lifecycles. Microsoft Project has no native workflow automation; task approvals and process-driven status changes require Power Automate. We do not migrate workflows as code. We deliver a written inventory of every active Synergy Workflow with its trigger conditions, automated actions, and assignee rules, plus a recommended Power Automate implementation approach for each. Approval chain configurations require separate rebuild work by the customer's admin or a Microsoft integration partner.

  • Project Online retirement (September 30, 2026) affects destination architecture decisions

    Organizations currently using Project Online as the destination alongside Synergy face a forced architectural decision before migration: move to Project Plan 3 desktop with local MPP files, move to Project for the Web (cloud-native, part of Microsoft 365), or migrate to Project Server Subscription Edition (on-premises or private cloud). Each destination has different API access, storage models, and custom field capabilities. We scope the destination architecture decision early in discovery because it affects the migration path (MPP export vs. PWA REST API vs. Project for the Web API), the timeline by one to two weeks, and the post-migration SharePoint integration model. Customers delaying this decision risk discovering mid-migration that their chosen destination is no longer supported.

Migration approach

Six steps for a successful Synergy to Microsoft Project data migration

  1. Discovery and Synergy source audit

    We audit the Synergy source environment across Projects, Tasks, Job Structure depth (folder levels, naming rule count, permission models), custom field schemas (including null-field inventory from pre-snapshot), file and version count, and contact and activity volume from the native JSON export manifest. We pair this with a destination architecture decision: Project Plan 3 desktop (MPP files stored in SharePoint), Project for the Web (cloud-native Project for the Web Projects), or Project Server Subscription Edition. The discovery output is a written migration scope document covering record counts, schema complexity, and the chosen destination architecture.

  2. Custom field schema pre-snapshot and pre-provisioning

    We snapshot the complete Synergy custom field schema before any data extraction begins. This includes every defined custom field name, type, and null status across all Projects and Tasks. We then pre-provision every Synergy-defined custom field in Microsoft Project as a local or enterprise custom field before any task data is loaded, filling null values with type-appropriate defaults. Dropdown and multi-select Synergy fields require corresponding lookup tables in Microsoft Project; we create these in the target system during the pre-provisioning step so that task imports do not fail on missing lookup values.

  3. JSON bundle preparation for Contacts, Activities, and Teams

    Because Synergy lacks public API endpoints for Contacts, Activities, and Teams, we extract these objects via the native import/export JSON bundle. We validate the bundle manifest against the Synergy source record counts to confirm completeness, parse the bundle for field mapping alignment, and prepare the JSON for ingestion into the Microsoft Project destination (Resource Sheet for contacts and teams; SharePoint list for activities). We flag any contact or activity records that cannot be parsed from the bundle or that reference objects not being migrated.

  4. Project and Task migration with dependency mapping

    We migrate Synergy Projects to Microsoft Project files or Project for the Web Projects. Within each project, we migrate Tasks with the full WBS hierarchy, predecessor dependencies (mapped to Microsoft Project predecessor task relationships), duration, start/finish dates, percent complete, and resource assignments. We resolve Synergy Task assignees to Microsoft Project Resource Sheet entries by email match. Files and version metadata are transferred to a SharePoint Document Library linked to the destination Project. Job Structure folder layouts and naming rules are applied to the WBS outline in Microsoft Project; unsupported permission models are flagged in the migration manifest.

  5. Sandbox reconciliation and mapping sign-off

    We run a full migration into a Microsoft Project test environment (SharePoint sandbox for Project for the Web or a local MPP test file for Project Plan 3). The customer's PMO lead reconciles record counts (Projects in, Tasks in, custom field count, resource count, file link count), spot-checks 25-50 random task records against the Synergy source for accuracy of dates, dependencies, and custom field values, and signs off the mapping schema before production migration begins. Any corrections to the WBS hierarchy, dependency types, or custom field mapping happen in this phase.

  6. Production migration and cutover

    We run production migration in dependency order: Resource Sheet (contacts and teams from JSON bundle), Projects and Tasks (with full WBS, dependencies, and custom fields), File links (SharePoint Document Library with version metadata). We freeze Synergy writes during cutover, run a final delta pass for any records modified during the migration window, then enable Microsoft Project as the system of record. We deliver the Workflow and Automation inventory document, the Job Structure manifest, and the Cross-Reference Association map to the customer's PMO admin for rebuild in Power Automate and SharePoint. We do not rebuild Synergy Workflows as Power Automate flows inside the migration scope.

Platform deep dives

Context on both ends of the pair

Synergy logo

Synergy

Source

Strengths

  • Combines project management, CRM, and financial sync in one platform for AEC-specific workflows
  • Highly configurable workflows, custom fields, and naming rules for complex project hierarchies
  • 12d Model project support with native file and version management for civil engineering deliverables
  • QuickBooks Online add-on enables direct AP/AR and financial data exchange without re-entry
  • Import/export tool bundles job structures, permissions, and file versions into a portable package

Weaknesses

  • Custom reporting produces inconsistent results and unreliable data, requiring manual cross-checking
  • User interface is unintuitive with a steep learning curve and significant training requirements
  • Public API lacks documented endpoints for Contacts, Teams, Activities, and Attributes
  • Contact support relies on native import/export JSON format rather than a REST API
  • No publicly documented API rate limits, auth methods, or bulk endpoint specifications
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 Synergy 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

    Synergy: Not publicly documented.

  • Data volume sensitivity

    B

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

Estimator

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

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

Can't find your answer?

Walk through your Synergy to Microsoft Project migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most migrations land between three and five weeks for firms with up to 50 Projects, 5,000 Tasks, clean naming conventions, and a straightforward Job Structure with fewer than 20 custom fields. Migrations with deep Job Structure nesting (multi-level folder layouts with naming rules and folder-level permissions), more than 50 custom fields, large file version histories, or complex dependency chains move to eight to fourteen weeks. The Microsoft Project Online retirement (September 30, 2026) adds planning scope for organizations deciding between Project for the Web and Project Plan 3/5 desktop; this architectural decision typically adds one to two weeks to discovery before migration begins.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Synergy.
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