MySQL Bugs: #71272: Facing problem when migrating the DB from MS sql to mysql

Bug #71272	Facing problem when migrating the DB from MS sql to mysql
Submitted:	2 Jan 2014 12:18	Modified:	21 Sep 2014 19:11
Reporter:	Palak Lakhani	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S2 (Serious)
Version:	6.0.8	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Facing problem when migrating the  DB from MS sql to mysql

How to repeat:
While migrating the data from MS sql 2008 facing this issue.

Below is the log:

First pass of table reverse engineering for schema dbo completed!
Reverse engineering 0 views from dbo
Traceback (most recent call last):
  File "/usr/lib/mysql-workbench/modules/db_mssql_grt.py", line 396, in reverseEngineer
    reverseEngineerViews(connection, schema)
  File "/usr/lib/mysql-workbench/modules/db_mssql_grt.py", line 942, in reverseEngineerViews
    for idx, (view_count, view_name, view_definition) in enumerate(cursor):
MemoryError

Traceback (most recent call last):
  File "/usr/share/mysql-workbench/libraries/workbench/wizard_progress_page_widget.py", line 192, in thread_work
    self.func()
  File "/usr/lib/mysql-workbench/modules/migration_schema_selection.py", line 160, in task_reveng
    self.main.plan.migrationSource.reverseEngineer()
  File "/usr/lib/mysql-workbench/modules/migration.py", line 353, in reverseEngineer
    self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: MemoryError(""): error calling Python module function DbMssqlRE.reverseEngineer
ERROR: Reverse engineer selected schemata: MemoryError(""): error calling Python module function DbMssqlRE.reverseEngineer
Failed

Marking this serious since i am not able to run my application on ubuntu

what version of ubuntu?

Version is 12.0.4

Hi. How many objects the schema has? Can you send a dump of the schema without the data?

db dump without table data

Attachment: script.sql (application/octet-stream, text), 145.90 KiB.

Hi,

Attached is the db dump file without data

Thank you for uploading script. 
Can you estimate how many objects the schema has?

Can you send a screenshot of the stage in WB where the crash occurs? How many tables, view, functions and stored procedures does your source schema have?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".