My Oracle Support Banner

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.

Goal

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.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.