Facing migration of all tables in to azuresql

[Sudip_J]

Hi Teams ,
I am facing an issue related to database tables migration from mysql to azuresql . I am going to share the problems error and snapshot as well .

Error -Failure happened on 'Source' side. 'Type=MySqlConnector.MySqlException,Message=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fromstadium' at line 1,Source=mscorlib,'

Thanks and regards
Sudeep Kumar

[v-sgandrathi]

Hi @Sudip_J,

Thank you for sharing the error details and screenshot. Based on the error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the correct syntax to use near 'fromstadium'...

This appears to be a MySQL syntax issue rather than an Azure SQL problem. The error indicates that the query being generated or executed on the MySQL source side contains an invalid or incomplete SQL statement, possibly due to a malformed table name, reserved keyword (like from), or a dynamic expression error.

For the most accurate assistance with this specific issue, I recommend posting it on the official MySQL Forums:
MySQL :: MySQL Forums

Experts there can help determine whether this is a reserved keyword conflict, naming issue, or a deeper syntax problem related to MySQL itself.

If this guidance was helpful, feel free to mark it as the Accepted Solution so others facing similar issues can benefit. 

Thank you.