Walkthrough - Migrate OneDrive for Business to OneDrive for Business in PowerShell

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

Index

• Prerequisites
• How-to
  • Create a CSV guide for your migration
  • Create your script
• Considerations

Prerequisites

• Global administrator or SharePoint administrator permissions are required in the source and destination.

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

Note: You must be site collection admin on each OneDrive, even if you have higher admin privileges. In step (9) below, you will use SharePoint admin or global admin permissions to apply site collection permissions to all your OneDrives. The PowerShell script will then remove the site collection admin permissions as you migrate each OneDrive.

How-to

Tip: To migrate your documents to a new folder in your OneDrives, see Walkthrough - Migrate to a new OneDrive folder in PowerShell.

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 OneDrive for Business  as your object type.
4. Click Continue without saving.
5. Select your source Tenant.
6. Click on Run.
7. Select all your OneDrives with the checkmark box at top of the list.
8. Click Edit  in the Quick actions menu
9. Select Add administrators in the Transformations dropdown.
10. Search and add your account in the Select user or group field that appears.
11. Click Apply.
12. Click Back two times to go back to your report results.
13. Click on Export in the top right corner.
14. Save the file on your drive.
15. Repeat steps (1) to (14), selecting your destination tenant at step (5).
16. Open Excel.
17. Add titles SourceSite and DestinationSite to the first two columns.
18. Open the two files you saved in step (8).
19. Combine the data from both files into the new document so that the source URL corresponds to the destination URL under their respective column.
    
    If sorting alphabetically doesn't work, you can reorganize your data manually, or you can look for a solution with Excel macros or PowerShell.
20. Save this new file as a CSV on your drive.

Create your script

Copy and paste the following script into 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' with your Microsoft 365 credentials.
• Connect-site: The command to connect to a SharePoint site. If you need to change the authentication method, see Connect Site.
• 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.
• 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. For more information, see Remove Site Collection Administrator.

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

Considerations

• To use Browser authentication, see Use credentials from a previous browser connection.
• Migration reports are automatically generated, and you will be able to find them in Tasks. You can also export the reports in your script with Export-Report.
• You can schedule your migration using PowerShell to run it off-hours and optimize performance.
• To perform an incremental migration, see the Incremental update using PowerShell article.
• To replicate the copy options from the migration tool, see Replicate copy options. 
• If you have hundreds of gigabytes of data to migrate, we recommend creating multiple CSVs to run the migration in smaller batches.