Bug #108093 Single table migration not showing in selection and not transferring table
Submitted: 9 Aug 2022 7:35 Modified: 10 Aug 2022 7:14
Reporter: Yasas Alwis Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version: OS:Windows (11 Build 22000)
Assigned to: CPU Architecture:x86 (Core I7)

[9 Aug 2022 7:35] Yasas Alwis 
Description:
In data migration cannot select a single table for migration. Table shows as selected but not in the collection(Objects to migrate area). After executing the table does not transfer and script exits without nothing transferring. In the final report following message appears. 

Migration Issues 
4.16. 4.16 Table [table name] was not migrated   

How to repeat:
1. Open MySQL Workbench -> Database -> Migration Wizard 
2. Select source DMBS connection. In my scenario source DB was in local network (DESKTOP-XXXXX) and the remote connection specifically made for target DB (DESKTOP-YYYYY) with sufficient access roles. 
3. Select target DBMS connection (DESKTOP-YYYYY).
4. Select DB which wants to migrate.
5. Select Show selection and move objects from 'Objects to Migrate' to 'Available Objects'. Select the object want to migrate and click '>' to move to 'Objects to Migrate'. Still 'Objects to Migrate' is empty but the top shows 24 total, 1 selected.
6. Click next until finish
[9 Aug 2022 12:56] MySQL Verification Team 
Hello,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.30 using dummy database to migrate but I am not seeing any issues at my end. 

Regards,
Ashwini Patil
[9 Aug 2022 12:57] MySQL Verification Team 
8.0.30 test results

Attachment: 108093_test_results.PNG (image/png, text), 74.39 KiB.
[9 Aug 2022 15:46] Yasas Alwis 
Issue

Attachment: Screenshot 2022-08-09 211608.png (image/png, text), 50.89 KiB.
[9 Aug 2022 15:53] Yasas Alwis 
Please refer [Screenshot 2022-08-09 211608.png] for reference. I tried with different server but it produce the same result. It only appear when selecting single table from data migration. It shows i selected but does not selects.
[9 Aug 2022 15:56] Yasas Alwis 
issue with highlight

Attachment: Screenshot 2022-08-09 212627.png (image/png, text), 70.59 KiB.
[10 Aug 2022 7:14] MySQL Verification Team 
Thank you for the feedback. Duplicate of Bug #103955, please see Bug #103955. Thanks.