PowerShell: New-MigrationBatch for Exchange Online migration

Originally published 11 July 2019

This PowerShell script helped the IT team and me initiate mailbox migrations from Exchange to Office 365 Exchange Online. Before it worked in our environment, I had two challenges to resolve.

We used a proxy server, so I needed to pass Proxy.Credentials to use PowerShell through it. Accessing the migration endpoint was another challenge because not every team member was a domain admin.

The New-MigrationBatch cmdlet initiates the migration of an on-premises mailbox. The migration can then be completed with Complete-MigrationBatch. The example includes both automatic and manual completion, so choose the method you want to use before running the script. It saved the team a lot of clicking.

PowerShell32 lines

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
#Define user for the migration
$upnuser = "[email protected]"

#Define admin email
$emailadmins = "[email protected]"

#Create and define CSV file as input for New-MigrationBatch
$csvfile = '.\ExchangeOnlineOnboarding.csv'
if (Test-Path $csvfile) {  Remove-Item $csvfile}
Add-Content -Path .\ExchangeOnlineOnboarding.csv  -Value 'EmailAddress,MailboxType'
Add-Content -Path .\ExchangeOnlineOnboarding.csv  -Value "$upnuser,"

#Set proxy authentication if filtering like McAfee Web Gateway is being used
$Wcl = new-object System.Net.WebClient
$Wcl.Headers.Add(“user-agent”, “PowerShell Script”)
$Wcl.Proxy.Credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials

$UserCredential = Get-Credential -UserName $emailadmins -Message "Enter admin credentials"
$proxysettings = New-PSSessionOption -ProxyAccessType IEConfig
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection -SessionOption $proxysettings
Import-PSSession $Session -DisableNameChecking

#This migration batch will Autostart and Autocomplete for 100%. When completed the user will be migrated to Exchange Online
New-MigrationBatch -Name $upnuser -SourceEndpoint migration.networknet.nl -CSVData ([System.IO.File]::ReadAllBytes("$csvfile")) -AutoStart -BadItemLimit "1000" -TargetDeliveryDomain networknet.mail.onmicrosoft.com -AutoComplete -NotificationEmails $emailadmins

#This migration batch will Autostart and sync for 95%. You will need to run the Complete-Migration step to finish the final 5%
New-MigrationBatch -Name $upnuser -SourceEndpoint migration.networknet.nl -CSVData ([System.IO.File]::ReadAllBytes("$csvfile")) -AutoStart -BadItemLimit "1000" -TargetDeliveryDomain networknet.mail.onmicrosoft.com -NotificationEmails $emailadmins
Get-MigrationBatch -Identity $upnuser | Format-List
Complete-MigrationBatch -Identity $upnuser

#Check the migration report
Get-MigrationUserStatistics -Identity $upnuser -IncludeReport  | FL *Skip*,Error,Report

More in Exchange