Migrating multiple SQL server databases to Azure

Hugo McDonald 1 Reputation point
2020-11-19T10:06:47.983+00:00

Hi All

We are looking for a solution to migrate multiple databases from a local SQL server to Azure. Ideally we would like to migrate multiple databases at a time due to the number of databases involved.

I have done a test migration using Data Migration Assistant, but from what I can see it only allows for the processing of one database at a time.

Is there a tool like Data Migration Assistant that would be able to process multiple databases at a time?

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
511 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. 21986829 481 Reputation points
    2020-11-19T20:15:21.74+00:00

    Some people probably have written something related to this in powershell dba tools

    https://dbatools.io/

    Thomas

    0 comments No comments