Hello,

I am in the process of migrating 2000 users from exchange 2003 to Exchange 2007. My objective is to spread the mailboxes evenly across all the databases on the target 2007 sever. The source users would be just the aliases of the users in a text file. I am working on a powershell script but it may take me some time given that I am a newbie. can anyone help?

I had looked at that posting earlier but unfortunately it does not address what I am looking to do.

Are the users already spread out evenely on 2003?

What do you mean by "even" - do you want 300 users in each database, or do you want 20GB of data in each one?

Karl

Let's say I do a migation every night. I want to input the alias of 200 users in a text file (regardless of the size of their mailboxes) and move them evenly across 50 databases I have on the server. The ideal way to do it I guess is to put geimailboxdatabse in an array and then for each db in mailboxdatabase pick one user and move it then move to the second db in the array and pick the next user in the input file. Or, maybe do it the other way arround and do get-content  of c:\users.txt and move-mailbox of one user to one db and the next user into the next db and stop at the last user but keep looping onto the dbs. I hope that makes sense...

Something like this might help. NOTE, this is not tested. Try it with the -whatif as posted, and once you see what it is going to do, remove the -whatif.

On the first day, do only 51 to make sure it really works. (Obviously, 51 of your least favorite people) ;)

$mailboxes = Get-Content "C:\monday.txt"
$DBIncriment = 0
foreach ($mailbox in $mailboxes)
{
    do
    {
        $DBIncriment ++
        Get-Mailbox -Identity $mailbox |Move-Mailbox <server\database$DBIncriment -WhatIf
        
    }while ($DBIncriment -ne 51)
}

I will try it and let you know but I have a question:

I am not sure what to put in the <server\database$DBIncriment . Let say my server is called server1 and I have 50 storage groups SG1-SG10and each 1 has a DB Let's say the DBs are called server1SG1DB1to Server1SG50DB50.

I meant SG1 through SG50 (not SG10).

This should look like:

Get-Mailbox -Identity $mailbox |Move-Mailbox server1\SG$DBIncriment\database$DBIncriment -WhatIf

Hi,

This is not working because of the naming convention we have for the databases (see below)

server1\server1sg01\server1sg01db01

server1\server1sg02\server1sg02db02

server1\server1sg03\server1sg033db03

.

.

server1\server1sg50\server1sg50db50

I will play with it more tonight and see.

Thanks

Thanks for the posting. That's what I am looking to do. However, I get prompted to enter the database name when I run the script. Any ideas?

Nevermind I just naswered my own question. I just added -targetdatabase to your script where it was missing. I am running into a new issue. The script starts reading the users aliases from c:\users.txt then at the first user (let's say his alias is jdoe) it tells me this:

The operation could not be performed because object 'jdoe' could not be found on domain mydomain.

At line 8, position 0

get-mailbox $_ | move-mailbox -targetdatabase $mbdatabase

However, if I do a simple move from the command like it works like for example:

move-mailbox jdoe -targetdatabase dbname.

jonoble,

I got this to work. It was an issue with some of the accounts.  I am trying next, to modify your script (if you do not mind) and add some logging and error checking to see which mailbox moves fails.  Any help would be appreaciated.

Thanks