Splitting one Content DB into 10 DBs in SP 2010

Question

We have 650 site collections all in one Content DB with 800+ GB in size.
Because of this huge size, performance goes down and we have decided to split the DB into 10 different content DBs with maximum 80 GB per content DB.
We can use Move-SPSite Powershell command to move one Site collection to destination database.
But as in our case we have 650 site collections, and we want to move 65 site collections to one content DB. And in this way, we will split into 10 different content DBs.
All we want to do this by Powershell. What is the best possible way to do this?

1. Is there any command to move multiple site collections at ones?
2. Is there Powershell command to create content DB?

Any good suggestion can help?

Answer 1

As you said you can use the command Move-SPSite on more site collection.
Select the site collection (by matching the url) and then move them.

Get-SPSite -Limit All | Where-Object {$_.Url -match "mySiteName" -or $_.Url -march "mySiteName1" } | Move-SPSite -DestinationDatabase ContentDb2

To create a new content DB, you can use New-SPContentDatabase

New-SPContentDatabase "MyDatabase" -DatabaseServer "MyServer" -WebApplication http://sitename

New-SPContentDatabase