Bug #76008 Break in Migration Between SQL Server 2000 to MySQL
Submitted: 23 Feb 2015 15:19 Modified: 24 Feb 2015 11:43
Reporter: Torrey Dupras Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S1 (Critical)
Version:6.2.4 OS:Windows (Microsoft Windows 7 Professional Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[23 Feb 2015 15:19] Torrey Dupras
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\tdupras\AppData\Roaming\MySQL\Workbench\log\wb.log]

When attempting to Fetch Schemas List from source DB, the application gives the following error:

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration_source_selection.py", line 456, in task_fetch_schemata
    self.main.plan.migrationSource.doFetchSchemaNames(only_these_catalogs)
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration.py", line 241, in doFetchSchemaNames
    catalog_names = self.getCatalogNames()
  File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\migration.py", line 205, in getCatalogNames
    return self._rev_eng_module.getCatalogNames(self.connection)
SystemError: ProgrammingError("('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'sys.sp_databases'. (2812) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getCatalogNames
ERROR: Retrieve schema list from source: ProgrammingError("('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'sys.sp_databases'. (2812) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getCatalogNames
Failed

How to repeat:
Attempt a migration from SQL Server 2000 to MySQL using the migration tool.  The application will fail the Fetch Schemas List step.
[23 Feb 2015 15:19] Torrey Dupras
Error Log for this bug.

Attachment: wb.log (application/octet-stream, text), 33.39 KiB.

[24 Feb 2015 11:43] MySQL Verification Team
Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=73142.