Moving Mailboxes using a CSV file in EAC (Exchange Admin Center)

Share this:

Hi folks,

We have so many features in the new release of Exchange Server 2013 and I’m going to start with the feature that allows the administrator to use a CSV to move mailboxes and we are going to use an improvement on the batch mailbox moves. Basically in Exchange Server 2013 the batch move mailbox allows the administrator to manage the archive move process, incremental sync to migrate the changes (pretty cool, uh?), administrator can be alerted by e-mail after the process finishes

Let’s go through the process to generate a CSV file (yeah, I don’t want to create that manually), and then use that file to move the mailboxes.

Let’s use the following scenario for this post: we have some users on a database and we want to move all of them to a different database, sounds good? Let’s do it!

Logged on the EAC, let’s click on recipients and then mailboxes, click on … and then Advanced Search

image

Let’s add a condition, and select Database and let’s select the database  that we want to move the users from and then click OK.

image

Awesome! It’s getting better, now we have a list only of the users that we need to move away from that specific database, let’s go back to … and then let’s click on Export data to a CSV file

image

Let’s select the fields that we want in our CSV, for the move mailbox process we just need Email address and that is the only one that we are going to select, then click on Save and let’s save the file on the Desktop and let’s name it as MoveMailbox.csv.

image

Before starting the move process let’s open the file and do some clean up, as follows:

  • Make sure that there is no space on the first line between email and adress
  • Remove any blank lines (usually 2nd and 3rd line, and also the last line of the file)

The result should be something like this..

image

Time to move!!!!!

Okay, we have the file, let’s go to migration tab, and let’s click on Add and then Move to a different database

image

On the first page (select the users), let’s select Specify the users with a CSV file and let’s select the file that we just worked on which is MoveMailbox.csv. Click Next.

image

In the move configuration page. We can define if we are going to move archive and define the target database for either (mailbox or archive), also we can define the bad item and the large item limit. Click Next.

image

In the start the batch page. We can define which account will receive a report at the end of the process, also when we want to start this new batch and also if we are going to suspend the move process and finish up later on. Click on New to start the process.

image

If you are impatient enough, you can check the process by clicking on refresh on the migration tab, however you can go for a coffee and get a nice message when the process is finished.

image

 

 

Cheers,
Anderson Patricio
http://www.andersonpatricio.ca
http://www.andersonpatricio.org (Portuguese)
Twitter: @apatricio

Written by Anderson Patricio

Anderson Patricio is a Canadian Exchange Server MVP and MCSM (Solutions Master) and he contributes to the Microsoft Community with articles, tutorials, blog posts, forums and book reviews. He is a regular contributor at MSExchange.org, ITPROCentral.com and AndersonPatricio.org (Portuguese).