Bug #73203 MSSQL 2000 sys_database

• Submitted: 5 Jul 2014 1:10
• Modified: 8 Aug 2014 0:00
• Reporter: myFirstName myLastName
• Status: No Feedback
• Category: MySQL Workbench: Migration
• Severity: S2 (Serious)
• OS: Windows
• CPU Architecture: Any

[5 Jul 2014 1:10] myFirstName myLastName

Description:
I am working with mssql 2000 and it was not finding sys.sp_databases so I changed it to sp_databases and it works.

I am using the SQL Server native driver.

How to repeat:
Try to migrate something with mssql 2000

Suggested fix:
C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_grt.py: change query = 'exec sys.sp_databases' yo  query = 'exec sp_databases'

[8 Jul 2014 0:00] MySQL Verification Team

Please provide the WorkBench version. Thanks.

[8 Aug 2014 1:00] Bugs System

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".