SSMA (SQL Server Migration Assistant) for MariaDB

Question

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 ??

Answer 1

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:
https://www.mssqltips.com/sqlservertip/3425/steps-to-import-mariadb-objects-and-data-into-sql-server/

Also, there are 3rd party tools available to migrate from MariaDB to Azure Sql but they come at a cost.
https://www.dbsofts.com/articles/mariadb_to_azure/

Answer 2

Hi,

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

https://www.youtube.com/playlist?list=PLpOY--bg9OVl_uyR4lQzr_9_v-fJzrmW3

If you have MongoDB -

https://www.mongodb.com/how-to-setup-mongodb-atlas-on-azure

https://datamigration.microsoft.com/scenario/mongo-to-cosmos?step=1

Regards,
Eshwar

Answer 3

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: https://aka.ms/ssmaformysql.

Regards,
Alex.