skip to Main Content

Migrate Exchange mailboxes with CSV file

We like to migrate Exchange mailboxes with a CSV file to another database. It will work the same if you want to migrate Exchange mailboxes to a new server. Before doing a batch migration with a CSV file, we need to create the CSV file. Also, a small adjustment in the CSV header needs to take place. In this article, you will learn how to migrate Exchange mailboxes with CSV file.

Information

Before you start, read the article New-Migrationbatch or New-MoveRequest in Exchange Server. It will give you an understanding of the available options to move mailboxes. Why do you want to migrate mailboxes in Exchange Server? Some examples:

Export CSV file

Log into Exchange Admin Center. Click in the feature pane on recipients and follow with mailboxes in the tabs. Click the more icon in the toolbar and click on Export data to a CSV file.

Migrate Exchange mailboxes with CSV file

Check the checkboxes DISPLAY NAME, MAILBOX TYPE, and EMAIL ADDRESS. Click Export.

Migrate Exchange mailboxes with CSV file

It will download the CSV file to the Downloads folder by default. If a prompt shows up, make sure to save the CSV file.

In the next step, we will edit the CSV header.

Migration batch CSV header

It’s essential to edit the CSV file before uploading the CSV file in the next step. If you don’t do that, it will not work when uploading, and an error shows up.

Read more: The given key was not present in the dictionary »

Go to the file and rename ExportData.csv to MigrationBatch01.csv.

Place good attention and edit the CSV file. Remove the space between EMAIL ADDRESS.

Migrate Exchange mailboxes with CSV file before CSV header

It needs to look like EMAILADDRESS. Save the file.

Migrate Exchange mailboxes with CSV file after CSV header

In the next step, we will create a new migration batch and upload the CSV file.

Create migration batch with CSV file

Click migration in the tabs. Click the + icon and select Move to a different database.

Migrate Exchange mailboxes with CSV file to different database

Select the radio button Specify the users with a CSV file. Check the checkbox Allow unknown columns in the CSV file. Click the Browse button and select the MigrationBatch01.csv file.

Migrate Exchange mailboxes with CSV file browse

The CSV is read, and the total mailboxes to migrate are showing. Click Next.

Migrate Exchange mailboxes with CSV file mailboxes to migrate

Give the new migration batch a name. In our example, MigrationBatch01. Click Browse and select the target database you like to move the mailboxes to. In our example, it’s DB02.

Do the mailboxes have an archive, and do you want to migrate them too? Browse and select the target archive database. Click Next.

Migrate Exchange mailboxes with CSV file new migration batch

Select the mailbox that will get a report after the migration batch finishes. Click New to start the migration batch. Read more about external recipient for notification emails in migration batch.

In the next step, we will check the status of the Migration batch.

Check mailbox move progress

Select the MigrationBatch01 in the list view. Click in the details pane on View details to get more information regarding the mailboxes move.

Migrate Exchange mailboxes with CSV file migration batch view details

It first will start with Validating the mailboxes move request. Click the refresh icon.

Migrate Exchange mailboxes with CSV file migration batch details

The status will change to Syncing or Failed. Click on the failed mailbox to check why it failed. In our example, it failed because the mailbox is already in the target database.

Migrate Exchange mailboxes with CSV file mailbox failed

In the next step, which is the last step, we will verify the migration batch completion status.

Verify migration batch completion

Migration batch Completed with errors. You can see if all the mailboxes are finalized or failed in the details pane on the right side. In our example, eleven mailboxes failed because they already are hosted in the target database. If you have other errors, troubleshoot further.

Migrate Exchange mailboxes with CSV file migration batch completed with errors

The migration report is sent to the mailbox that you set up earlier.

Migration batch report

We can always verify and check the mailbox database location of the mailboxes.

Migrate Exchange mailboxes with CSV file database column

All mailboxes in the CSV file are moved to the specified target database. Did this help you to migrate Exchange mailboxes with CSV file to another mailbox database or a new server?

Other ways to move mailboxes

Interesting articles that can help you move mailboxes:

Conclusion

In this article, you learned how to migrate Exchange mailboxes with CSV file. First, export the mailboxes to CSV file from Exchange Admin Center (EAC). Remove the email addresses that you don’t want to move from the CSV file. Don’t forget to edit the header and save the CSV file. If you don’t, an error shows up when uploading the CSV file. Create a new migration batch and upload the CSV file. Keep an eye on the migration progress status.

Did you enjoy this article? You may also like Complete migration batch with PowerShell. Don’t forget to follow us and share this article.

ALI TAJRAN

ALI TAJRAN

ALI TAJRAN is a passionate IT Architect, IT Consultant, and Microsoft Certified Trainer. He started Information Technology at a very young age, and his goal is to teach and inspire others. Read more »

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top