Why File Server Migration is Different from Email Migration
File server migrations to SharePoint Online are fundamentally different from email migrations because they require structural transformation, not just data movement. Email migrates 1:1 — mailbox to mailbox. File servers require rethinking the entire information architecture: folder hierarchies must be flattened, permissions must be remapped to a different model, and naming conventions must be updated to comply with SharePoint requirements.
Organizations that approach file server migration as a simple lift-and-shift consistently encounter problems: path length errors, broken permissions, poor search results, and low user adoption. The most successful migrations invest 30-40% of project time in pre-migration planning and structure design.
Migration Tool Comparison
| Feature | SPMT (Free) | ShareGate | AvePoint |
|---|---|---|---|
| Cost | Free | $5,000-15,000/yr | $10,000-50,000/yr |
| Permission Mapping | Basic | Advanced | Enterprise |
| Scheduling | Manual | Automated | Automated |
| Delta Sync | Yes | Yes | Yes |
| Reporting | Basic logs | Detailed reports | Enterprise audit |
| Best For | <1 TB, simple | 1-20 TB, mid-size | 20+ TB, enterprise |
For most enterprise engagements, EPC Group recommends ShareGate for its balance of capability and usability. AvePoint is justified when dealing with multi-tenant scenarios, complex permission structures, or migrations exceeding 20 TB.
Pre-Migration Assessment
Content Inventory
Before migrating, run a complete inventory of your file server. Tools like TreeSize Professional or the native Windows robocopy /L command can generate reports showing total file count, total data volume by folder, file type distribution, largest files, deepest folder paths, files with problematic characters in names, and files last modified over 3 years ago (candidates for archival rather than migration).
Content Cleanup
The single highest-ROI activity in any file server migration is pre-migration cleanup. Most file servers contain 30-50% of data that should not be migrated: duplicate files, outdated versions, personal files in shared locations, and abandoned project folders. Eliminating this content reduces migration time, storage costs, and post-migration clutter. Work with department heads to identify content that can be archived to cold storage or deleted entirely.
Structure Mapping
Map your file server hierarchy to SharePoint's site/library/folder model:
- Departments or business units → SharePoint team sites
- Major project areas → Document libraries within sites
- Subfolders (2 levels max) → SharePoint folders within libraries
- Deeper classification → Metadata columns (content type, year, status, etc.)
OneDrive vs. SharePoint Decision Matrix
| Content Type | Destination | Rationale |
|---|---|---|
| Home drives (H: drive) | OneDrive | Personal files, 1 TB per user |
| My Documents | OneDrive | Personal files synced to device |
| Department shared drives | SharePoint team site | Shared access, version control |
| Project folders | SharePoint team site | Collaboration, lifecycle management |
| Company policies/templates | SharePoint comm site | Broad read access, publish workflow |
| Archive data (>3 years old) | Azure Blob Storage | Cost-effective cold storage |
Post-Migration Validation
After migration, validate file integrity by comparing source and destination file counts and sizes, verify that folder permissions are correctly applied by spot-checking 10-15 folders with different permission levels, confirm that file version history was preserved where applicable, test search functionality for recently migrated content, and verify that OneDrive sync client connects properly for end users.
Frequently Asked Questions
What is the best tool for migrating file server data to SharePoint Online?
For enterprise file server migrations, the best tools depend on your scale and requirements. Microsoft SharePoint Migration Tool (SPMT) is free and handles basic migrations well for up to 100,000 files per batch. ShareGate offers superior permission mapping, scheduling, and reporting for mid-size migrations. AvePoint Cloud Migration is best for large-scale enterprise migrations with complex permission structures. For OneDrive migrations specifically, Microsoft Mover (now integrated into SharePoint admin center) provides a streamlined experience. Most enterprise consulting firms use ShareGate or AvePoint for their advanced scheduling, delta sync, and audit trail capabilities.
How do you handle folder structures during file server to SharePoint migration?
Folder structures require careful planning before migration. SharePoint Online has a URL path limit of 400 characters, so deeply nested folder structures must be flattened. Best practice is to map the top 2-3 levels of the file server hierarchy to SharePoint site collections and document libraries, then use metadata columns instead of subfolders for further classification. For example, instead of \\server\Finance\2024\Q1\Invoices\Approved, create a Finance document library with Year, Quarter, Type, and Status metadata columns. This approach improves searchability and eliminates the deep nesting that causes path length errors.
What file types and sizes are supported in SharePoint Online?
SharePoint Online supports virtually all file types with a few exceptions. Blocked file types include .exe, .dll, .cmd, .bat, and certain other executable formats (though administrators can unblock specific types). The maximum individual file size is 250 GB. File names cannot contain characters like \ / : * ? < > | # % ~ & { } and cannot begin or end with a period. File names have a maximum length of 400 characters including the path. The total path length (site URL + folder path + file name) cannot exceed 400 characters. Files with these issues must be remediated before migration.
How to map file server permissions to SharePoint Online permissions?
NTFS permissions on file servers must be mapped to SharePoint permission levels. The typical mapping is: NTFS Full Control maps to SharePoint Full Control, NTFS Modify maps to SharePoint Edit, NTFS Read & Execute maps to SharePoint Read, and NTFS List Folder Contents maps to SharePoint View Only. Active Directory security groups should be synchronized to Azure AD via Azure AD Connect before migration. SharePoint inherits permissions from parent to child by default, so plan your permission structure at the site collection and library level rather than individual folders. Use SharePoint groups mapped to Azure AD groups for scalable permission management.
Should you use OneDrive or SharePoint for file server migration?
The decision depends on file ownership patterns. Personal files (home drives, My Documents) should migrate to OneDrive for Business — each user gets 1 TB of personal storage. Shared departmental files, project files, and team resources should migrate to SharePoint document libraries organized by team or project. Files accessed by more than 3-5 people typically belong in SharePoint. Files accessed by only one person belong in OneDrive. Hybrid scenarios are common: personal files to OneDrive, shared project files to SharePoint team sites, and company-wide resources to SharePoint communication sites.
Planning a File Server to SharePoint Migration?
EPC Group has migrated petabytes of file server data to SharePoint Online for enterprise organizations. Start with a content assessment to understand your migration scope, timeline, and budget.
Schedule a Migration AssessmentErrin O'Connor
CEO & Chief AI Architect at EPC Group | 28+ years Microsoft consulting