MySql to SQL Server - SQL Server Migration Assistance tool is showing few tables

Question

We have a database which has 511 tables and 'SQL Server Migration Assistance for MySQL' is showing only 31 tables. I am using Version-6.0.0. It is not showing any error in 'output' window.

Followed - https://www.youtube.com/watch?v=fXe4XL41jVE for migration.

I have a table which has 87120301 records, and this is the last table which is displayed. Is there any restrictions for this tool ?.

Is there any other tool I can use for this Big Data Migration?. Total size of the database in MySQL is 37GB.

Answer 1

Made changes in Project Settings as follows.

General - Migration - Batch Size = 99999999 (Maximum value)
GUI - Maximum Row Number of Source = 999999999 (Maximum value)
Maximum Row Number of Target = 999999999 (Maximum value)

Its working now.