question

SwapnilSolanki-4729 avatar image
0 Votes"
SwapnilSolanki-4729 asked AlexanderIvanov-MSFT edited

SSMA (SQL Server Migration Assistant) for MariaDB

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

sql-server-migration-assistantazure-database-mariadb
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

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/




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SwapnilSolanki-4729, please let us know if this was helpful and you were able to get what you were looking for.






If an Answer is helpful, please “Accept Answer” or Up-Vote for the same which might be beneficial to other community members reading this thread.







0 Votes 0 ·
MalleswarReddy avatar image
0 Votes"
MalleswarReddy answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexanderIvanov-MSFT avatar image
0 Votes"
AlexanderIvanov-MSFT answered

Hi @SwapnilSolanki-4729 ,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.