Demo - SharePoint Migration Tool
Start course
1h 10m

Microsoft 365 represents a combination of Office 365, Windows 10 and Enterprise Mobility offerings – providing the most complete set of SaaS technologies that Microsoft has to offer. With Microsoft 365, organizations can deploy a complete solution encompassing both devices and applications, along with applying security and compliance policies to protect the entire suite.

This course will help you as you plan your migration of users and data to Microsoft 365, including planning your identity and authentication solution, and the on-premises infrastructure needed to support your migration. We’ll also help you understand and identify your business requirements and use cases, to help drive your decision-making process when planning to transition your infrastructure to the Microsoft cloud. We’ll spend some time focusing on networking and discuss some of the networking decisions that need to be made to ensure an optimal migration experience, as well as the best experience for your users after migration.

This course will also help you to identify which data needs to be migrated to the cloud, and what the best migration method will be based on your scenario – we’re also going to cover the different types of user identities, how your users will authenticate, and how that’s going to affect your migration planning.

In addition to talking about these different components, we’re also going to run through a few demos – showing you some of the practical steps involved, along with some tips and tricks we’ve picked up along the way. 

Learning Objectives

By the end of this course, you should be able to:

  • Plan a Microsoft 365 Implementation, including the supporting infrastructure
  • Plan your identity and authentication solution, both on-premises and in the cloud
  • Identify your users, data, and mailboxes to be migrated to Microsoft 365
  • Plan the migration of your groups and user data to Microsoft 365

Intended Audience

This course is intended for people who:

  • Want to become a Microsoft 365 administrator
  • Are preparing to take the Microsoft’s MS-100 exam 


To get the most from this course, you should have a general understanding of networking & server administration as well as IT fundamentals such as DNS, Active Directory and PowerShell.


There are a number of third-party tools for migrating data from SharePoint On-Premises to SharePoint Online, as well as for migrating file shares into OneDrive for Business. Microsoft also provides a free utility called the SharePoint Migration Tool which can be used for both scenarios. 

As with the Exchange Online migrations it's good for you to know what the native options are and when you might have additional requirements that would push towards using a third-party tool for your migration. Let's take a few minutes and go through the SharePoint Migration Tool, and show you what the migration looks like. 

I've already downloaded the SharePoint Migration Tool and have it running here on my desktop. Once you open it up, it's gonna prompt you to log in to Office 365, authenticate using your global admin credentials, and click on Start your first migration. If you're migrating to OneDrive for Business, and you're doing multiple OneDrive migrations, you wanna choose the option to use a JSON or a CSV file for a bulk migration. When you click this option it's gonna give you a path so you can choose your file, as well as the option to view a sample. Now the sample's a little bit strange because the OneDrive migration sample that they give you includes a number of columns, and as well as, as you'd expect, some sample data to fill it up, but you're not allowed to use any of the headers in the columns. So what I recommend doing is grab the sample file, figure out exactly what you need to have to map to it. 

So for instance the column A is my Source. SourceDocLib and SourceSubFolder really only apply if I'm doing a SharePoint migration. You can see here it's left blank for a local folder. And it's included for a SharePoint site. So I'm gonna leave that blank on mine but you do need to leave those columns existing but empty. You can't put your target into B, the target has to remain in column D, but it can't have a header, a little bit strange, but once you get that figured out it's not too bad. 

So my TargetWeb is going to be the URL to my OneDrive Library, not the full path, just as far as it gets to my name, and then the Documents portion. So it just shows that it's going into the Document Library. I've got this ready to go, all saved up, say no, and I'm gonna go ahead and choose my file, onedrive-migration is mine, click Add, and we're gonna go Next, you can add other data there if you want. In this case we're just doing a very simple migration, so I'm gonna click Next. This is a great option here, if you have a lot of data that you're getting ready to migrate and you wanna prescan it beforehand, make sure you use this option, just do a scan only. Help you find any kind of issues that need to be resolved around folders or path lengths or invalid filenames, or anything that's gonna give you a hassle on the migration, use this option to perform the scanning and start the migration if you want to, or you can just say, we're gonna leave it off, and go from there. 

There's also some advanced settings here you can look around with and just see some of the options here that are available to you for automation and having the migration run consecutively or to keep on recurring until it's done. Great if you wanna schedule some delta migrations or incremental syncs as you're getting ready to cutover your users. Again very simple, we're just gonna keep everything as the defaults and click the Migrate button. Now it is gonna start by scanning the items in my folders. So it's gonna go ahead and do that now. Okay, it's a small amount of data so the eight items were scanned and there weren't any issues, eight out of eight items were migrated, 2.61 megabytes. 

Let's take a look at the report here. Okay, just gives me a bunch of files I can go and look at later. Basically I'm gonna be okay 'cause everything is eight out of eight, zero issues, and I'm not gonna save this. And then if I go to my OneDrive folder I can see the files that I've migrated have all been copied in and migrated and good to go, and we have a migration complete. Once again this is a very simple migration tool. You might have some requirements that are gonna make it necessary for you to use something else, but in the meantime it's free, it's relatively easy to use once you understand how to get the CSV file populated correctly. And yeah, that's it, pretty straightforward.

About the Author

Jeremy Dahl is a Senior Technology Consultant who has spent the last 8 years focusing on Microsoft 365 technologies and has been an Office 365 MVP for the last 6 years. Jeremy is a self-proclaimed cloud addict who architects technology solutions that combine cloud technologies with on-premises solutions, allowing organizations to make the most of their existing infrastructure while still taking full advantage of the agility and scalability of what the cloud has to offer.

Jeremy can be found blogging about Microsoft 365 technologies on his website,, and evangelizing the Microsoft cloud on Twitter.