MySQL Bugs: #67129: Migrating from SQL Server 2008 to MySql, a 5GB database. I get an insufficient

Bug #67129	Migrating from SQL Server 2008 to MySql, a 5GB database. I get an insufficient
Submitted:	8 Oct 2012 7:09	Modified:	20 Mar 2013 15:41
Reporter:	larry lubman	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S1 (Critical)
Version:	5.2.44	OS:	Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
Simply migrating from SQL Server 2008 to MySql.  All steps seem to be OK, no errors or issues or warnings about compatibility.  Everything is created, but then, during data transfer, it takes a very long time and finally crashes with error, Program can't continue, insufficient memory, or something like that.  

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\Larry\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
CPU: 8x Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 16.0 GiB RAM
Active video adapter (0): mv video hook driver2
Installed video RAM: 0 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 6.0.1.0
Installed display drivers: NULL
Active video adapter (1): NVIDIA GeForce GT 420
Installed video RAM: 1024 MB
Current video mode: 1600 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.12.9610
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United States)

Exception = System.OutOfMemoryException
Message = Insufficient memory to continue the execution of the program.
FullText = System.OutOfMemoryException: Insufficient memory to continue the execution of the program.
   at System.Runtime.InteropServices.Marshal.AllocCoTaskMem(Int32 cb)
   at System.Windows.Forms.UnsafeNativeMethods.GetWindowText(HandleRef hWnd, StringBuilder lpString, Int32 nMaxCount)
   at System.Windows.Forms.Control.get_WindowText()
   at System.Windows.Forms.TextBoxBase.get_WindowText()
   at System.Windows.Forms.TextBoxBase.ScrollToCaret()
   at MySQL.Forms.TextBoxImpl.append_text(TextBox* self, basic_string<char\,std::char_traits<char>\,std::allocator<char> >* text, Boolean scroll_to_end)
   at MySQL.MCallback3<void\,mforms::TextBox \*\,std::basic_string<char\,std::char_traits<char>\,std::allocator<char> > const \&\,bool>.cpp_callback(TextBox* a1, basic_string<char\,std::char_traits<char>\,std::allocator<char> >* a2, Boolean a3)
   at boost.function0<bool>.()(function0<bool>* )
   at TimerHandler.timer_tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
I was migrating 5GB database, schema, functions/view/stored procedured, and data.

Thank you for the bug report. Please check if related or duplicate of http://bugs.mysql.com/bug.php?id=66516 . Thanks.

This does look like it could be related to Bug #66516 but it is a bit hard to follow that since the errors are in Spanish/Portugese?  I can't see specifically if they are getting the out of memory error.  

I can duplicate this, I've run it twice.  Is there something I can provide to help prove this?

Thank you for the feedback. Please describe the steps you did and which point the crash happens. Thanks.

Hmmm, thought I did describe the steps in the original description.  I set up a migration using the wizard, SQL Server 2008 to MySql, migrating schemata, views, stored procedures, fuctions, and data.  Used all of the default settings.  Every stepped passed with no issues including the conversion report, no error or compatibility issues and all tables seemed to be created correctly.  The actual data migration started and was taking a very long time.  It eventually failed giving an out of memory error as described in the original report.

Any progress on this?  I'd really like to begin testing on our migrated database from MS SQL but I can't migrate because of this.

Thanks a lot to your report.
Our dev team its working on it.

http://bugs.mysql.com/bug.php?id=72231 marked as duplicate of this one.

https://bugs.mysql.com/bug.php?id=85055 marked as duplicate of this one.