Bug #84328 data migration using MySQL workbench

• Submitted: 23 Dec 2016 21:17
• Modified: 4 Jan 2017 4:56
• Reporter: Dimtiri Papachristos
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S5 (Performance)
• Version: 6.3.8
• OS: Windows (Microsoft Windows 7 Professional Service Pack 1)
• CPU Architecture: Any
• Tags: WBBugReporter

[23 Dec 2016 21:17] Dimtiri Papachristos

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\dpapachristos\AppData\Roaming\MySQL\Workbench\log\wb.log]

when using the migration wizard, the final step is to insert the rows from SQL server to MYSQL. The process crashes on a data column that contains 
an ' (apostrophe). What do we need to do to get the workbench migration to escape the ' (apostrophe) so what the data can be migrated successfully.

Thanks
Dimitri Papachristos

How to repeat:
as above

[23 Dec 2016 22:55] MySQL Verification Team

Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=83616.

[27 Dec 2016 17:42] Dimtiri Papachristos

Hello Miguel

I have looked at the previous duplicate issue and one of the suggestions was

"Give the wizard the ability to search for, and properly escape, special characters". Where do we do this, how do we do this?

Thanks
Dimitri

[3 Jan 2017 17:32] Dimtiri Papachristos

Hi Support

I have looked at the previous duplicate issue and one of the suggestions was

"Give the wizard the ability to search for, and properly escape, special characters". Where do we do this, how do we do this?

Thanks
Dimitri