Walkthrough - Migrating MySite to OneDrive for Business with PowerShell

Use PowerShell to automate your MySite to OneDrive for Business migration.

Index

• Prerequisites
• Create a CSV guide for your migration
• Create your script

Prerequisites

• You have Farm admin permissions in the source.
• You have Global admin or SharePoint admin permissions in the destination.
• You are connected to your SharePoint Central admin in Explorer.
• You are connected to your Microsoft 365 Admin center in Explorer.

• Your OneDrives are provisioned (can be automated with the Get-OneDriveURL cmdlet).

Note: You need to be Site collection admin on each MySite and OneDrive, even if you have higher admin privileges. You will use Farm admin, SharePoint admin, or Global admin permissions to apply Site collection admin permissions on all your MySites and OneDrives and then remove the Site collection admin permissions as you migrate each MySite.

Create a CSV guide for your migration

1. Go to All reports.
2. Click on Create custom report in the top right corner.
3. Select Site Collection  as your object type.
4. Click Continue without saving.
5. Select the Web app you use for your MySites.
6. Click on Next.
7. Click on Run now.
8. Select all your MySites with the checkmark box at top of the list.
9. Click Edit in the quick actions menu.
10. Select Add administrators in the Transformations dropdown.
11. Search and add your account in the Select user or group field that appears.
12. Click Apply.
13. Click Back two times to go back to your report results.
14. Click on Export in the top right corner.
15. Save the file on your drive.
16. Go back to All reports.
17. Click on Create custom report.
18. This time select OneDrive for Business  as your object type.
19. Click Continue without saving.
20. Select the Microsoft 365 tenant you use for your OneDrives.
21. Click on Next.
22. Click on Run now.
23. Select all your OneDrives with the checkmark box at top of the list.
24. Click Edit in the quick actions menu.
25. Select Add administrators in the Transformations dropdown.
26. Search and add your account in the Select user or group field that appears.
27. Click Apply.
28. Click Back two times to go back to your report results.
29. Click on Export in the top right corner.
30. Save the file on your drive.
31. Open Excel.
32. Add titles SourceSite and DestinationSite to the first two columns.
33. Open the two files you saved in the previous steps.
34. Combine the data from both the files into the new document so that the source URL corresponds to the destination URL under their respective column.
    
    Note: If sorting alphabetically doesn't work, you can reorganize your data manually or you can look for a solution with Excel macros or PowerShell.
35. Save this new file as a CSV on your drive.

Create your script

Copy and paste the following script in the PowerShell application of your choice.

Import-Module Sharegate
$csvFile = "C:\CSV\CopyContent.csv"
$table = Import-Csv $csvFile -Delimiter ","

$srcUsername = "sourceusername"
$srcPassword = ConvertTo-SecureString "sourcepassword" -AsPlainText -Force

$dstUsername = "destinationusername"
$dstPassword = ConvertTo-SecureString "destinationpassword" -AsPlainText -Force

Set-Variable srcSite, dstSite, srcList, dstList
foreach ($row in $table) {
 Clear-Variable srcSite
 Clear-Variable dstSite
 Clear-Variable srcList
 Clear-Variable dstList
 $srcSite = Connect-Site -Url $row.SourceSite -Username $srcUsername -Password $srcPassword
 $dstSite = Connect-Site -Url $row.DestinationSite -Username $dstUsername -Password $dstPassword
 $srcList = Get-List -Site $srcSite -Name "Documents"
 $dstList = Get-List -Site $dstSite -Name "Documents"
 Copy-Content -SourceList $srcList -DestinationList $dstList
 Remove-SiteCollectionAdministrator -Site $srcSite
 Remove-SiteCollectionAdministrator -Site $dstSite
}

Adjust your script so that it will work for you. Here are a few guidelines:

• $csvFile: Adjust the path so that it points to the CSV file you saved before.
• $table: The delimiter is the symbol your CSV uses to separate your items in a row. Make sure your script uses the same delimiter as your file (a quick way to verify this, is by opening the CSV with Notepad).
• $srcUsername, $srcPassword, $dstUsername, and $dstPassword: Replace "sourceusername", "sourcepassword", "destinationusername", and "destinationpassword" by your matching Microsoft 365 credentials.
• Connect-Site: If you need to change the authentication method, you will find how to do it in the Connect Site article.
• Set-variable and Clear-Variable: These commands help prevent an issue where a connection failure can cause your data to end up in the wrong OneDrive. If you have to use the browser connection method, you will have to remove these lines.
• foreach: We use foreach to loop through the values in your CSV file. You can find more about it here.
• Remove-SiteCollectionAdministrator: Removes your user account as site collection administrator on the OneDrive after its migration.

Run your script once it's property adjusted and tested.