SSMA stopped working when we upgraded source database to MariaDB 10.11.x, how can we resolve this?

Mark Daugherty 0 Reputation points
2024-06-06T16:36:10.5+00:00

We are working on migrating from an Azure MariaDB to SQL Server on an Azure VM. The process was working until we upgraded MariaDB from 10.6.x to 10.11.x. Now we get an error stating, "Error occurred while collecting data". Additional error in output pane states, "Object cannot be cast from DBNull to other types.

This is a showstopper and has been confirmed against multiple MariaDB instances to confirm the incompatibility starting at 10.11.x.

Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
56 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,063 questions
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.
540 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 19,571 Reputation points Microsoft Employee
    2024-06-25T17:45:40.43+00:00

    @Mark Daugherty

    Thank you for posting your solution so that others experiencing the same thing can easily reference this!

    Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept "the answer. Accepted answers show up at the top, resulting in improved discoverability for others.

    Issue: We are working on migrating from an Azure MariaDB to SQL Server on an Azure VM. The process was working until we upgraded MariaDB from 10.6.x to 10.11.x. Now we get an error stating, "Error occurred while collecting data". Additional error in output pane states, "Object cannot be cast from DBNull to other types.

    Solution: SQL Server Migration Assistant (SSMA) is not certified for MariaDB as a source database for the migration tool. This could be the root cause of the error you’re experiencing. Downgrading your MariaDB installation to 10.6.x, which was working previously, could indeed resolve the issue.

    1 person found this answer helpful.
    0 comments No comments

  2. MikeyQiaoMSFT-0444 3,190 Reputation points
    2024-06-07T03:42:44.0766667+00:00

    Hello, Mark Daugherty

    1.Can you roll back MariaDB to a previous version?

    2.You can try assigning the DBNull fields separately during the migration process, for example, convert assignment = 0 (int).


  3. Oury Ba-MSFT 19,571 Reputation points Microsoft Employee
    2024-06-10T22:23:58.7166667+00:00

    @Mark Daugherty

    Thank you for reaching out.

    Azure Database for MariaDB currently supports the following version:

    MariaDB Version 10.2

    Patch version: 10.2.32

    Refer to the MariaDB documentation to learn more about improvements and fixes in this version.

    Please see this doc https://learn.microsoft.com/en-us/azure/mariadb/whats-happening-to-mariadb

    Please do also note that Maria DB is in retirement Phase.

    I would Migrate from Azure Database for MariaDB to Azure Database for MySQL - Flexible Server

    User's image


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.