Published

- 6 min read

Enterprise File Server to SharePoint Online Migration

img of Enterprise File Server to SharePoint Online Migration

1 Executive Summary

This project simulates a common enterprise scenario: migrating an on-premises Windows file server to SharePoint Online while maintaining identity synchronization and access control.

Many organizations historically rely on SMB file shares combined with NTFS permissions to store departmental data. As companies adopt Microsoft 365, these legacy file servers must be migrated to SharePoint Online document libraries or Microsoft Teams storage.

This lab recreates a simplified enterprise infrastructure using a hybrid identity architecture. The project demonstrates how to:

• design a domain-based identity infrastructure
• implement group-based access control
• deploy a departmental file server architecture
• synchronize on-premises identities with Microsoft Entra ID
• migrate data to SharePoint Online using Microsoft migration tools
• validate identity and permission mapping after migration

The entire environment runs inside a virtualized infrastructure and documents the process from infrastructure deployment to migration validation.

This project demonstrates how traditional Windows file servers can be modernized into a cloud-based collaboration platform while preserving identity and access control models.


2 Project Objectives

The primary objectives of this lab are divided into three areas.


Infrastructure Objectives

• deploy a multi-server Windows domain environment
• implement centralized identity management using Active Directory
• create department-based security groups
• deploy a Windows file server with NTFS permissions


Hybrid Identity Objectives

• integrate on-premises Active Directory with Microsoft Entra ID
• synchronize users and groups to the cloud directory
• validate identity mapping across environments


Migration Objectives

• analyze existing file share architecture
• prepare SharePoint Online document libraries
• migrate file server data using SharePoint Migration Tool (SPMT)
• validate user access after migration


3 Architecture Overview

The lab simulates a hybrid enterprise infrastructure consisting of multiple layers.

Core architecture layers:

Infrastructure Layer
Identity Layer
File Storage Layer
Cloud Integration Layer
Migration Layer

Architecture

Figure1 Architecture


4 Lab Environment

Virtualization Platform

The entire lab runs inside Proxmox VE, which hosts multiple Windows Server virtual machines used to simulate an enterprise environment.

Network segment:

192.168.20.0/24

Virtual Machine Inventory

ServerRoleIP
server2019-domainDomain Controller192.168.20.101
server2019-exchange1Additional infrastructure VM192.168.20.102
server2019-AD-ConMicrosoft Entra Connect192.168.20.103
server2019-filestorageFile Server192.168.20.104
win10-clientDomain workstationDHCP

Figure2 Virtual Machines

Domain name

nortant.local

Azure tenant

cooperhomelab.onmicrosoft.com

5 Identity Infrastructure (Active Directory)

Active Directory provides centralized authentication and identity management.

Services hosted on the domain controller:

• Active Directory Domain Services
• DNS
• DHCP

These services support authentication, name resolution, and network configuration across the lab environment.


User Accounts

User accounts simulate employees from different departments.

Example users:

david.it
lisa.hr
michael.finance
sarah.management
kevin.operations

Figure3 Local Users in DC


Security Group Strategy

Access control follows a group-based permission model, which is considered best practice in enterprise environments.

Security groups created:

GG_IT_RW
GG_HR_RW
GG_Finance_RW
GG_Management_RW
GG_Operations_RW

Figure4 Local Groups in DC

Permission model:

User

Security Group

Resource Permission

This design simplifies administration and improves scalability.


6 File Server Architecture

A dedicated Windows Server hosts the enterprise file storage system.

Server:

server2019-filestorage
192.168.20.104

Primary SMB share:

\\srv-2019-file1\CorpData

Directory Structure

CorpData
├ Archive
├ Projects
├ Shared
├ Users
├ Restricted
└ Departments
    ├ Finance
    ├ HR
    ├ IT
    ├ Management
    └ Operations

The Departments directory represents typical enterprise departmental file storage.


7 NTFS Permission Model

The file server uses both share permissions and NTFS permissions. Figure5 Setting permissions by using PowerShell script


Share Permissions

Authenticated Users → Change
Administrators → Full Control

NTFS Permissions

Permissions are assigned to security groups instead of individual users.

Example configuration:

Finance folder

GG_Finance_RW → Modify
Administrators → Full Control
SYSTEM → Full Control

Each department folder follows the same pattern.


Access-Based Enumeration

Access-Based Enumeration (ABE) was enabled.

ABE ensures users only see folders they have permission to access.

Example:

UserVisible Folder
Finance userFinance
HR userHR

8 Hybrid Identity Integration

To integrate on-premises identities with Microsoft 365, Microsoft Entra Connect was deployed.

Server:

server2019-AD-Con
192.168.20.103

Figure6 Connect Sync settings Figure7 Connect Sync settings


Synchronization Method

The synchronization method used is:

Password Hash Synchronization

This allows users to authenticate to Microsoft 365 services using their Active Directory credentials.

Figure8 Synchronization Method (30 mins)


Identity Synchronization Flow

Active Directory

       │ Entra Connect

Microsoft Entra ID


SharePoint Online

Sync Validation

Users and groups appear in Microsoft Entra ID with identity source:

Windows Server AD

This confirms successful hybrid identity integration. Figure9 Synced users in Azure Figure10 Synced groups in Azure


9 SharePoint Online Architecture

Before migration, SharePoint Online must be prepared.

Tenant:

cooperhomelab.onmicrosoft.com

Site Structure

SharePoint sites were created for each department.

SharePoint Online
├ Finance Site
├ HR Site
├ IT Site
├ Management Site
└ Operations Site

Each site contains a Documents library used to store migrated files.


SharePoint Permission Model

SharePoint permissions follow the standard group model.

Example:

Finance Owners
Finance Members
Finance Visitors

Synchronized Active Directory groups are added into these SharePoint groups.

This design prevents excessive unique permissions, improving SharePoint performance and manageability. Figure11 Site permissions

Figure12 Adding Azure groups to site


10 Pre-Migration Assessment

Before executing migration jobs, the source environment was analyzed.

The following checks were performed:

• verification of NTFS permission structure
• confirmation of Entra ID synchronization
• validation of SharePoint site preparation
• testing access using domain user accounts

Performing these checks helps prevent migration failures and permission mismatches.


11 Migration Architecture

The migration workflow connects on-premises storage with SharePoint Online.

File Server (SMB + NTFS)


        │ SharePoint Migration Tool

SharePoint Online
Document Library


SharePoint Site Permissions


Users via Entra ID Sync

12 Migration Execution

Migration was executed using the SharePoint Migration Tool (SPMT). Figure13 SharePoint Migration Tool


Migration Workflow

Figure14 Migration Workflow


Migration Configuration

Migration job configuration included:

Source
SMB file share
\\srv-2019-file1\CorpData\Departments\IT

Destination
SharePoint Site
IT → Documents Library

Figure15 SPMT source configuration

Figure16 SPMT destination configuration

SPMT settings used:

Automatic user mapping → Enabled
Preserve file share permissions → Disabled

Permission Strategy

File share permissions were not migrated directly.

Instead, access control was rebuilt using SharePoint groups linked to synchronized Active Directory security groups.

Permission flow:

User

AD Security Group

Entra ID Sync

SharePoint Group

SharePoint Site Permission

This model reflects Microsoft best practices for SharePoint environments.


13 Migration Validation

After migration, access validation was performed.

Validation steps:

• confirm files exist in SharePoint document libraries
• verify folder visibility
• validate permission inheritance
• test user access from different departments

Example test results:

IT user → can access IT site documents
HR user → cannot access IT site

This confirms correct permission mapping. Figure17 Migration complete

Figure18 No documents in SharePoint before migration

Figure19 Migration complete, checking group permissions


14 Migration Challenges

Several challenges commonly occur during file server migration.


NTFS Permission Complexity

NTFS permissions can become complicated due to:

• nested groups
• inheritance chains
• deny rules

These often require simplification before migration.


SharePoint Permission Limits

SharePoint performs best when:

• permissions inherit from site groups
• unique permissions are minimized

Excessive unique permissions can impact performance.


Identity Mapping

Successful migration requires consistent identity mapping across environments.

NTFS Identity

Active Directory

Entra ID

SharePoint

Any mismatch may cause permission errors.


15 Lessons Learned

Key insights from this project:


Group-Based Access Control

Assigning permissions to groups simplifies administration and supports scalable migration.


Hybrid Identity Is Essential

Identity synchronization is critical for mapping users between environments.


SharePoint Uses Simpler Permission Models

NTFS permission structures often require redesign before migration.


Migration Is Not Just Data Transfer

Successful migrations require understanding:

• identity infrastructure
• permission architecture
• collaboration platform design


16 Future Improvements

Possible enhancements for this lab include:

• implementing Conditional Access policies
• integrating Microsoft Teams document libraries
• testing OneDrive Known Folder Move
• automating migrations with PowerShell
• simulating large-scale migration scenarios


17 Portfolio Impact

This project demonstrates practical experience in:

Active Directory infrastructure deployment
NTFS permission design and access-based enumeration
Hybrid identity integration using Microsoft Entra ID
SharePoint Online site architecture and permission model
Enterprise file server migration using SPMT
Migration validation and access verification

These capabilities are directly applicable to modern enterprise infrastructure and cloud migration projects.