How to Migrate Data to SharePoint Online: A Step-by-step Guide

Xillio
4 min readDec 7, 2020

Phasing out a legacy ECM (e .g., Livelink, FileNet, OpenText, Documentum) and embracing a modern and more cost-efficient system is becoming urgent for enterprises nowadays, especially when remote-work is necessary and more and more popular. Microsoft 365, with its powerful knowledge management, collaboration features, and intranet networking, is the leading supplier of software in the cloud (33%). But migrating to Microsoft 365 or SharePoint can be challenging considering the differences between the original and the target systems. After doing migration projects of all sizes and complexities for years, I have summed up this guide to make your migration to SharePoint a fast and secure process.

1. Always analyze the content on the source system first

Just like moving is the best time to get rid of the trash in your house, migrating to a new system is also the best opportunity to sort out your documents and data. You don’t want to migrate junk or work with a new system messed up just like the old one. So my suggestion for any migration is to have a thorough analysis of all content in your source system first. I do it with Xillio Insight, a handy tool to get an in-depth report.

During this analysis, you should get the information below:

  • The volume and formats of your documents
  • File categories and extensions
  • Content types, schemes or blueprints and data models
  • Folder and file activity
  • Metadata keywords and usage
  • Duplicates files and folder structures

With this analysis report, you can define your migration rules, for example, delete duplicates, archive outdated content, or abandon files with a certain extension. In this way, you will only move the content you need and want to your new system, and in good shape.

Now you’ve got all your packages ready, don’t forget to check if an API or export functionality is available to export the selected data from your old system in an automated and structured way.

2. Determine the data structure in your new SharePoint system

After the analysis of the content in the source system(s), you can determine your data structure in SharePoint. SharePoint structures data from general to specific in web applications, site collections, sites and subsites, lists/libraries, and folders. The most common way to structure SharePoint data is using several hierarchical trees of sites.

data structure in SharePoint
An example of data structure in SharePoint

Each site in such a hierarchy has its configuration of content types, users, permissions, metadata-fields, and other site settings. Sites at lower levels in the hierarchy can inherit and specialize the settings from sites positioned at higher levels. And you can change the permission by breaking the inheritance.

3. Define a global data model in SharePoint

It’s time to define a new metadata model based on the decision you made in step 1. During this step, you can compare the data models of the source system with the target system and merge the data models to one global data model so that all data can be covered. Having one global metadata model will improve the quality of your SharePoint content and findability.

Common Data Model in SharePoint
The Common Data Model in SharePoint

4. Classify all content according to the new metadata model

If you wish to increase your content’s findability, you need to add metadata tags to classify your data. You can use SharePoint’s ‘Content types’, ‘Managed Metadata’, and ‘Lookup fields’ to manage your classification. If you have a large amount of data, I would recommend using tooling to automatically classify the content from your source system.

5. Transfer your data into SharePoint

Now you have cleaned up your new house and get the cabinets and drawers to put your stuff in. It’s time to move!

Using SharePoint import connector to transfer data from any system to SharePoint

Using SharePoint import connector to transfer data from any system to SharePoint

In the most trivial of scenarios, you can transfer the data manually. But if you want to ensure that no data or metadata is lost during a migration, you should transfer in an automated way. Wich will put your content in the right place.

Author: Evan Goris

Originally published at Xillio Blog

Decided to migrate to SharePoint?

Download this free whitepaper, and learn all the challenges of SharePoint migration and the way to overcome them.

Whitepaper: How to take the headache out of your Migration to Microsoft 365

--

--

Xillio

Xillio is the leading content migration and content integration company in the world, also a Microsoft Charter Partner for Content Services.