SSMA (SQL Server Migration Assistant) for MariaDB

Swapnil Solanki 1 Reputation point

I have on-premise MariaDB. I am Planning to migrate it to Azure SQL Database.
Can i use SSMA (SQL Server Migration Assistant) for Migration???
Does SSMA supports MariaDB as source ??

Azure Database for MariaDB
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.
515 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Anurag Sharma 17,586 Reputation points

    Hi @SwapnilSolanki-4729, SQL Server Migration Assistant currently supports database migration for Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.

    To fulfil your requirements, you can create SSIS package and achieve the objective. You need to write code in package to loop through all the tables in your on-premise DB but this gives you control over any data transformation you need to perform too. You can refer to below article for more details:

    Also, there are 3rd party tools available to migrate from MariaDB to Azure Sql but they come at a cost.

  2. Malleswara Reddy, G 1,631 Reputation points


    SQL Migration tools to migrate on-premises SQL Server to Azure but they do not match for MongoDB. I made 3 videos on SQL Server Migration, Please go through it

    If you have MongoDB -


    0 comments No comments

  3. Alexander Ivanov 491 Reputation points

    Hi @Swapnil Solanki ,

    While we do not officially support MariaDB as a source in SSMA, I've heard success stories with SSMA for MySQL being used for this purpose. In fact, we found MariaDB ODBC driver to work way better with MySQL, then official MySQL ODBC driver.

    I would suggest you to try SSMA for MySQL to migrate your MariaDB database:


    0 comments No comments