Exchange 2013. Migration Batches using CSV File.

I tasked myself with creating multiple Migration Batches for a planned Exchange 2013 migration. Entering each user manually through the Web Gui would be a nightmare.

I planned to create these batches based on CSV files.

1) Populate the CSV File.

I populated the files with these attributes

EmailAddress,TargetDatabase

i.e.
EmailAddress,TargetDatabase
myuser1@mydomain.com,NewDB1
myuser2@mydomain.com,NewDB2
myuser2@mydomain.com,NewDB1

How you populate these files are up to you. I simply exported all MailboxStatistics, sorted by size, collected email addresses and evenly assigned new databases in a separate and then exported Batch CSV’s from the master sheet.

Note: The minimum property requirements are email address only, as you can specify other settings i.e. target database in the batch.

However, by using the TargetDatabase attribute, I can move users in a batch to different databases.

More information:
http://technet.microsoft.com/en-us/library/dn170437%28v=exchg.150%29.aspx

2) Create the Batch

New-MigrationBatch -Local -Name YourName -CSVData ([System.IO.File]::ReadAllBytes(“patchToYourCSVFile.csv”))

Note: As we are not specifying -Autostart or -Autocomplete, it means this won’t start automatically and when started, it won’t complete automatically.

This allows us to stage the moves by using Start-MigrationBatch and Complete-MigrationBatch like you would a MoveRequest.

More information:
http://technet.microsoft.com/en-us/library/jj219166%28v=exchg.150%29.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s