Microsoft 365 Migration

How to Migrate a Large SharePoint Server 2016 Site to SharePoint Online

Huma Ashraf ChHuma Ashraf Ch Nov 4, 2026 870 views

Question details

The user needs to migrate a massive SharePoint Server 2016 site collection to SharePoint Online, bypassing standard tool limitations.

How to Migrate a Large SharePoint Server 2016 Site to SharePoint Online
Product
SharePoint Server 2016
Device & OS
not provided
Scenario
Migrating an on-premises enterprise SharePoint environment with a 2TB content database and dense document libraries to the cloud.
Observed behavior
The standard SharePoint Migration Tool struggles or fails due to the sheer volume of data (2 TB) and libraries exceeding 150,000 files.
Before you start

Before beginning a large-scale migration, audit your existing SharePoint environment to identify obsolete files, unneeded versions, and custom web parts that may not be supported in SharePoint Online.

Solution 1Recommended

Divide the Migration into Smaller Batches

Split the 2TB content database into smaller, manageable chunks to prevent migration tool timeouts and API throttling errors.

Massive migrations often fail when treated as a single job. By breaking the site collection into smaller components, you reduce the load on both the source server and the SharePoint Online destination.

1
Analyze site structure

Map out your SharePoint Server 2016 site collection to identify individual subsites, lists, and document libraries that can be migrated independently.

2
Create targeted migration jobs

Open the SharePoint Migration Tool (SPMT) and configure jobs specifically targeting the individual subsites or libraries rather than the root site collection.

3
Schedule off-peak migrations

Run these smaller batch jobs outside of normal business hours to maximize available network bandwidth and minimize user disruption.

4
Review migration logs

Check the SPMT error logs after each batch completes to quickly identify and resolve any file path length issues or unsupported characters.

List View Thresholds: Libraries with over 150,000 files may require restructuring into multiple smaller document libraries before migrating to ensure optimal performance in SharePoint Online.
Free Microsoft Office alternative

Edit Your Migrated Documents Locally with WPS Office

While migrating massive SharePoint libraries to the cloud, you may need a reliable local suite to access, review, and edit downloaded Microsoft Office files. WPS Office is a free, lightweight, and highly compatible alternative.

  1. 1. Install WPS Office: Download and install the free WPS Office suite on your local computer.
  2. 2. Sync migrated files: Use the OneDrive sync client to access your newly migrated SharePoint Online document libraries from your File Explorer.
  3. 3. Edit and collaborate: Open your synced .docx, .xlsx, and .pptx files directly within WPS Office to make edits and save them back to the cloud.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx) downloaded from SharePoint.Lightweight installation ensures fast performance even when reviewing large enterprise documents during migration.Familiar user interface requires no additional training for your team.Built-in PDF editing tools for comprehensive document management.
microsoft office alternative - wps office

Frequently Asked Questions

What is the maximum file size supported by the SharePoint Migration Tool?

The SharePoint Migration Tool (SPMT) supports migrating individual files up to 250 GB in size. However, migrating massive multi-terabyte databases all at once can cause performance bottlenecks and API throttling.

Why does my library with over 150,000 files fail to migrate?

Libraries with enormous item counts often hit internal processing limits or throttle the migration tool's API requests. It is highly recommended to reorganize extremely large libraries into multiple smaller document libraries before running the migration.

Can I migrate SharePoint Server 2016 directly to SharePoint Online?

Yes, the SharePoint Migration Tool supports direct migration from SharePoint 2010, 2013, 2016, and 2019 to SharePoint Online, provided your on-premises environment meets the necessary prerequisites.

How can I speed up a 2TB SharePoint migration?

To improve migration speeds, run multiple migration agents on different virtual machines concurrently, schedule migrations outside of peak business hours, and utilize high-bandwidth network connections.