Workbench Migration using WbCopytables Is Extremely Slow From Windows 2012
(Doc ID 2493462.1)
Last updated on MARCH 02, 2020
Applies to:MySQL Workbench - Version 6.3 and later
Information in this document applies to any platform.
On : 6.3 version, Migration Toolkit
wbCopytables is extremely slow on windows 2012 R2
In an environment it was observed that migrating from a Source MSSQL DB to MySQL ( 2012 R2 ) was impacted by a severe slowdown after a short period of time.
Comparing this performance impact on an identical server running Windows 2008 did not experience the same performance impact.
The source tables were nvarchar(MAX).
It was also observed that while 6.3 and 8.0 were affected by the performance impact in this Environment, using an older version ( 6.2 ) did not appear to be affected.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!