Project Management migration

Migrate from web2Project to Microsoft Project

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

web2Project logo

web2Project

Source

Microsoft Project

Destination

Microsoft Project logo

Compatibility

55%

6 of 11

objects map 1:1 between web2Project and Microsoft Project.

Complexity

BStandard

Timeline

3-5 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

web2Project has no production REST API, so all data extraction happens through direct MySQL database reads. We connect to the source MySQL instance, inspect the schema version (pre- or post-v2.4, since the Custom Field system changed significantly between those releases), and map Projects, Tasks, Task Dependencies, Users, Companies, and Custom Fields to their Microsoft Project equivalents. Task hierarchy and predecessor-successor dependency chains transfer as-is. Budget fields migrate as read-only text because web2Project's budget fields are documentation-only and carry no financial calculation logic. Forum posts, file attachment metadata, and calendar events map to task notes and linked file references where the destination supports them. We do not migrate workflows, custom modules, or user activity logs because Microsoft Project does not have equivalent objects for these. The result is a validated project plan delivered as an MPP file or a SharePoint-connected Project Online workspace, depending on the destination license.

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

web2Project logo

web2Project

What's pushing teams away

  • The interface is dated and lacks the modern UX patterns found in competing SaaS tools, leading to steeper learning curves for non-technical team members.
  • No production REST API means integrations with modern tools require custom PHP development, limiting ecosystem connectivity.
  • Community-maintained with an uneven release cycle — some teams experience reliability concerns given the volunteer-driven development model.
  • Limited reporting and analytics compared to modern project management platforms, making it difficult to derive business intelligence from project data.

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

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

web2Project

Project

maps to

Microsoft Project

Project

1:1
Fully supported

web2Project Projects map directly to Microsoft Project Project files (MPP) or Project Online workspaces. The project name, description, color coding, start and finish dates, priority, and status transfer as-is. Project-level custom fields map to Microsoft Project custom fields via the Field Picker. We detect project count during discovery to determine whether the destination is a single MPP deliverable or a SharePoint-connected Project Online workspace with multiple projects.

web2Project

Task

maps to

Microsoft Project

Task

1:1
Fully supported

web2Project Tasks map to Microsoft Project Tasks with task name, start and finish dates, duration, priority, percent complete, and task notes preserved. Subtask hierarchy (parent-child relationships) transfers as Outline Level and Summary Task structure in Microsoft Project. Milestones in web2Project (tasks with zero duration) become Microsoft Project milestone tasks. Task-level custom fields map to corresponding Microsoft Project custom fields.

web2Project

Task Dependency

maps to

Microsoft Project

Predecessor / Successor Link

1:1
Fully supported

web2Project inter-task dependencies map to Microsoft Project predecessor-successor links. We translate Finish-to-Start (the standard web2Project dependency type) to Microsoft Project FS predecessor links. Start-to-Start and Finish-to-Finish dependencies map to SS and FF predecessor types respectively. Lead and Lag time values transfer as the Lag field in Microsoft Project. Circular dependency detection in web2Project is flagged and escalated during discovery so it does not block import.

web2Project

User

maps to

Microsoft Project

Resource

1:1
Fully supported

web2Project Users map to Microsoft Project Resources. We extract the user display name, email address, and role assignment. Resource type is set to Material or Work depending on whether the user represents a person or a consumable resource. Active/inactive status maps to Resource's active flag. Role names from web2Project transfer as Resource Notes for capacity planning reference. Capacity, calendar, and cost rate fields require manual configuration in Microsoft Project and are flagged in the handoff document.

web2Project

Company

maps to

Microsoft Project

Project Summary Task or Custom Field

lossy
Fully supported

web2Project Companies are organizational entities with projects assigned to them. Microsoft Project does not have a native Company or Account object. We map Companies as Project-level custom text fields (e.g., Client) on each project, or as a Summary Task named after the company at the top of the project outline. The customer chooses the preferred representation during scoping. If multiple projects map to the same company, the organization may prefer a SharePoint list or Project Online Enterprise Resource Pool entry for cross-project reference.

web2Project

Department

maps to

Microsoft Project

Resource Group or Custom Field

lossy
Fully supported

web2Project Departments are sub-organizational units within Companies. Microsoft Project Resources support a Group field that maps to organizational groupings. We map Departments to the Resource Group field on the corresponding resources, which enables filtering and grouping in Microsoft Project resource views. The alternative is a Project-level custom field if the organization prefers department-level reporting at the project rather than resource level.

web2Project

Custom Field

maps to

Microsoft Project

Custom Field (Field Picker)

lossy
Fully supported

web2Project v2.4 custom fields (text, number, date, dropdown, checkbox) map to Microsoft Project custom fields using the Field Picker. Note that Microsoft Project Plan 3 and Project Desktop support up to 10 custom fields per project; Project Plan 1 does not support custom fields at all. We confirm the destination license tier during scoping. If the source has more custom fields than the destination supports, we migrate the highest-priority fields and document the remainder for manual entry. Custom field schema differs between pre-v2.4 and post-v2.4 web2Project instances; we detect the source version during database inspection and adjust extraction logic accordingly.

web2Project

Budget Field

maps to

Microsoft Project

Text Custom Field

lossy
Fully supported

web2Project budget fields are explicitly documented as documentation-only with no financial calculation, tracking, or reporting logic. We migrate these values as read-only text custom fields in Microsoft Project. No budget-versus-actual reporting, no cost rollup, and no resource rate integration is implemented because the source values carry no financial calculation context. Any actual budget tracking must be re-implemented in Microsoft Project using cost resources, fixed costs, or a Project Online financial integration.

web2Project

Forum Post

maps to

Microsoft Project

Task Note

1:many
Fully supported

web2Project project-specific forum threads (categories and post content) map to Microsoft Project Task Notes. Each forum post becomes a separate line within the task note, preserving the post author, timestamp, and body text. Forum thread ordering is preserved by sequential numbering within the note. This is an informational mapping only; Microsoft Project does not have a native discussion or collaboration object. The customer should evaluate whether SharePoint task collaboration, Teams channel posts, or Planner comments are more appropriate for ongoing team communication post-migration.

web2Project

File Attachment

maps to

Microsoft Project

Hyperlink or SharePoint Reference

1:1
Fully supported

web2Project file attachments at the project and task level store file metadata (filename, upload date, uploader) and a reference to the file location. We migrate file metadata as a Microsoft Project Hyperlink on the relevant task, pointing to the original file path or a SharePoint document library URL. Actual file content transfer (moving binary files from web2Project's upload directory to the destination SharePoint site or file server) is a separate file transfer step coordinated alongside the database migration. We flag this step explicitly in the handoff document because it is not covered by database-to-API migration logic.

web2Project

Calendar / Event

maps to

Microsoft Project

Task with Date Fields

1:1
Fully supported

web2Project calendar events with iCalendar export support map to Microsoft Project Tasks with Start and Finish dates. The event title becomes the task name and the event description becomes the task note. Recurrence patterns in web2Project calendar events do not transfer; recurring events are migrated as individual tasks and flagged for manual recurrence setup in Microsoft Project. Microsoft Project's base calendar (Standard, Night Shift, or custom) can be configured to reflect the organization's working days if the web2Project calendar had non-standard working hours.

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.

web2Project logo

web2Project gotchas

High

No production API means direct database access is required for migration

Medium

Budget fields are documentation-only with no financial logic

Medium

Custom field format changed significantly in v2.4

Medium

Project Importer module has limited import scope

Low

Timezone handling in user logs was rebuilt in v2.4

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

  • No production REST API requires direct MySQL database access

    web2Project does not have a production REST API. All migration logic reads from the MySQL database directly. We require read credentials to the source instance's database server during the discovery and migration phases. If the database is on a private network, the customer cannot provide access, and the built-in Project Importer module is the fallback, which does not handle Users, Companies, Departments, or custom field values. We confirm database access and network reachability during the discovery call. Any network or credential changes after scoping may affect the migration timeline.

  • Custom field schema differs between web2Project v2.4 and earlier versions

    The web2Project Custom Field system was rebuilt from the ground up in v2.4 using SOLID OOP principles. The optionlist system and custom field storage tables changed significantly. Pre-v2.4 custom fields may use a different column structure and data type than post-v2.4 fields. We detect the source web2Project version during database inspection and adjust field extraction logic to avoid truncation or type mismatches. Customers running an older web2Project instance should confirm the version with their system administrator before scoping.

  • Task dependency precedence must translate to predecessor links

    web2Project stores dependencies by reference with a dependency_type field. Microsoft Project uses the predecessor task ID and predecessor type (FS, SS, FF, SF) in a dedicated PredecessorLink table. Incorrect translation produces a broken schedule where tasks do not reschedule when predecessors shift. We validate the dependency graph before import by computing the forward pass and comparing against the web2Project start date expectations. Circular dependencies detected in the source are flagged and removed before import to prevent a corrupt schedule.

  • File attachment metadata migrates but file content requires a separate step

    web2Project stores uploaded files in a file system directory referenced by the database. We migrate the file metadata (filename, uploader, date, URL reference) as a hyperlink on the relevant task in Microsoft Project. The actual binary file content (documents, images, archives) must be transferred separately from the web2Project upload directory to a SharePoint site, OneDrive, or the destination file server. This file transfer step is coordinated alongside the database migration but is scoped separately. If the file repository is large or contains thousands of attachments, the file transfer may extend the timeline beyond the database migration estimate.

  • Budget fields are documentation-only and carry no financial logic

    web2Project includes budget fields in the project schema, but the official documentation explicitly states they are for documentation purposes only and are not used for tracking, evaluation, or reporting. Customers migrating from web2Project often assume budget fields are live financial data. We flag this during scoping, migrate the values as read-only text custom fields in the destination, and note that any active budget tracking, cost rollup, or budget-versus-actual reporting must be re-implemented in Microsoft Project using resource cost rates, fixed costs, or a Project Online financial integration.

Migration approach

Six steps for a successful web2Project to Microsoft Project data migration

  1. Discovery and database connectivity

    We connect to the web2Project MySQL database directly to audit the source schema. We detect the web2Project version (pre- or post-v2.4) to determine the custom field extraction logic, enumerate all Projects, Tasks, Task Dependencies, Users, Companies, Departments, Custom Field definitions, Budget values, Forum structures, and File attachment references, and identify any community-added modules extending the standard schema. We also inventory the file attachment repository location. If direct database access is unavailable, we fall back to the built-in Project Importer module with a scoped migration that excludes Users, Companies, Departments, and custom fields. The discovery output is a written scope document with record counts and a database access confirmation.

  2. Schema design and custom field mapping

    We design the destination Microsoft Project schema in a Sandbox or test environment. For each web2Project custom field, we define the corresponding Microsoft Project custom field type (Text, Number, Date, Flag, or Outline Code). We confirm the destination license tier because Project Plan 1 does not support custom fields and Plan 3 and Desktop are limited to 10 per project. If the source exceeds this, we prioritize fields used in active projects and document the remainder. We design the resource structure by mapping web2Project Users to Microsoft Project Resources, apply the Department-to-Resource Group mapping, and define any Company-to-Project custom field mappings.

  3. Data extraction and transformation

    We extract all identified records from the web2Project MySQL database in dependency order: Users first (for resource resolution), then Companies and Departments, then Projects and Tasks with hierarchy, then Task Dependencies, then Custom Field values, then Budget values, then Forum posts, then File attachment metadata, then Calendar events. All timestamps are normalized to UTC during extraction. For pre-v2.4 instances, we apply the timezone-aware extraction logic to account for server-local timezone storage in activity logs. The extracted data is staged in an intermediate transformation layer where we apply the custom field type mappings, dependency graph validation, circular dependency removal, and outline level computation before generating the target project plan.

  4. Test import and validation

    We import the transformed data into a test Microsoft Project file or a Project Online sandbox workspace and validate the resulting schedule. Validation checks include: task hierarchy matches the web2Project WBS outline, all predecessor links resolve to existing tasks, start and finish dates match the web2Project source values within one business day, resource assignments resolve to named resources, custom field values are present and correctly typed, and forum post content appears in task notes in correct order. We generate a row-count reconciliation report and a sample record comparison against the source. The customer's project manager reviews the test import and signs off before production migration begins.

  5. Production migration and cutover

    We run the production migration into the confirmed destination environment. If the destination is Microsoft Project Desktop, we deliver a validated MPP file per project. If the destination is Project Online, we publish to the PWA workspace via the SharePoint REST API. The migration runs in record-dependency order: Resources first, then Projects and Tasks, then Dependencies, then Custom Fields, then Budget values, then Forum notes, then File hyperlinks, then Calendar tasks. Each phase emits a reconciliation count. During cutover, we freeze writes to web2Project, run a final delta extraction for any records modified during the migration window, and enable the destination as the system of record.

  6. Handoff and archive planning

    We deliver the production project plan(s), a written inventory of migrated objects with record counts, a mapping audit log of every field transformation, a list of any records skipped or truncated with reasons, and a file transfer manifest for the attachment repository. We document the budget field status (read-only text, no financial logic), the custom field limitation if the source exceeded the 10-field destination cap, and the forum-to-notes conversion for the customer's review. We provide a two-week post-migration support window for reconciliation questions. We do not rebuild web2Project custom modules, PHP workflows, or forum structures in Microsoft Project; these are documented for the customer's admin to re-implement using Microsoft-native tools.

Platform deep dives

Context on both ends of the pair

web2Project logo

web2Project

Source

Strengths

  • Zero licensing cost — fully open-source with no per-seat, per-project, or tier-based fees.
  • Full source code access enables deep customization, self-hosting, and auditability without vendor dependency.
  • Modular architecture lets teams install or remove modules to match their exact workflows and reduce bloat.
  • Role-based permissions model provides fine-grained access control at the project and module level.
  • Multi-language support with iCalendar export for calendar interoperability with external tools.

Weaknesses

  • No production REST API — all data access requires direct database queries or web interface scraping.
  • Dated user interface compared to modern SaaS project management tools, affecting team adoption.
  • Community-maintained with an uneven release cadence and no commercial support SLA.
  • Limited built-in reporting and analytics — no dashboards or data export pipelines beyond basic module reports.
  • Budget tracking fields are informational only and not integrated into any calculation or reporting workflow.
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 web2Project 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

    web2Project: Not applicable — self-hosted; constrained by the customer's Apache/MySQL/PHP stack..

  • Data volume sensitivity

    A

    web2Project exposes a bulk API — large-volume migrations stream efficiently.

Estimator

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

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

Can't find your answer?

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

Book a free 30 minute consultation

A single-project migration with under 5,000 tasks, straightforward dependencies, and no custom fields lands in three to five weeks. Migrations with multiple projects, complex cross-project dependencies, pre-v2.4 or post-v2.4 custom field translation, file attachment metadata mapping, or forum-to-notes conversion move to six to ten weeks. The timeline assumes database access is confirmed during discovery and the destination license tier is identified before extraction begins.

Adjacent paths

Related migrations to explore

Ready when you are

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