Getting error "Error occurred while inserting table information into Data Migration Auxiliary table. Reason: Invalid object name 'digital.m2ss.MSSsmaDmTables' when migrating data from MYSQL to SQL Server

Question

I use SSMA for MYSQL application to migrate my schema, tables and data from MYSQL to SQL Server. I followed these steps

1. Convert Schema (MYSQL Metadata explorer) - In the setting I changed the target schema name instead of the default schema name it suggested
2. Synchronize to Database (SQL Server Metadata explorer)

After this when I tried to Migrate Data, on all tables it got failed with reason

Error occurred while inserting table information into Data Migration Auxiliary table. Reason: Invalid object name 'digital.m2ss.MSSsmaDmTables'.

Please help on this issue

Answer 1

Hi @Sathiyaseelan Ponnusamy [Optum]

In the setting I changed the target schema name instead of the default schema name it suggested

Did you try again without changing the default schema name?

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.