locked
Migrating MariaDB to SQL Server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have a MariaDB that I want to migrate tables, data, views, triggers and stored procedures to SQL Server.  The Microsoft SQL Server Migration Assistant only gives the option for MariaDB to go to MariaDB Azure.  Can I use the Microsoft SQL Server Migration Assistant and use the MySQL option to transfer the MariaDB and the objects to SQL Server??  I think it would work but wanted to check to see if anyone has tried it.  Thanks.
    Tuesday, June 30, 2020 7:16 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi TREX_444,

    Sorry that I have no MariaDB on hand and limited documents could be researched about this migration using SSMA.

    You could have a try with the answered method mentioned in Migrating site from MariaDB to MS SQL 2012.

    In addition, I recommend you to use SQL Server Integration Services (SSIS) to import the table structure and the data from MariaDB into SQL Server.

    BTW, you also have other choices to achieve the same goal.

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, July 1, 2020 6:20 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks!  Several good suggestions in the articles you linked.  The one that mentions moving MariaDB to MYSQL first then using the SSMA seems like a very good option.  Thanks again!

    Wednesday, July 1, 2020 12:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi TREX_444,

    Thanks for your update.

    You could have a try with Migrating site from MariaDB to MS SQL 2012 and let us know if it works.

    Please also remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. Thank you for understanding!

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com



    Thursday, July 2, 2020 12:48 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi TREX_444,

    Could you please provide any update? Thanks.

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, July 7, 2020 8:13 AM