SSMA Migration failed

Matti Niskasaari 26 Reputation points
2021-04-25T08:34:35.47+00:00

I've tried to migrate mysql database to azure sql database:
1 I create project (Azure SQL)

  1. Connect to mysql database
  2. connect to azure sql database
  3. Convert schema
  4. Synchronize with database

All goes fine so far but when I start to migrate data execution breaks off after starting migration.

I can't find reason for that

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
712 questions
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,886 Reputation points MVP
    2021-04-25T17:13:17.713+00:00

    Please examine the log files in C:\Documents and Settings\myUser\Application Data\Microsoft SQL Server Migration Assistant\YourProject\log\ssma.log folder. Change myUser by your user name on Windows. Application Data is a hidden folder.

    Have you follow all the steps provided on this documentation?

    If you are migrating big tables, please consider these adjustments.

    UPDATE:
    Based on the errors you found on the logs, llease make sure you are specifying the correct schema and database name to SSMA. Grant ALL PRIVILEGES and FLUSH PRIVILEGES to that login MNPalvelinanonymous user where the MySQL instance is installed.


0 additional answers

Sort by: Most helpful