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.
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.