Bug #82069 Cannot migrate sql server 2000 database
Submitted: 30 Jun 2016 17:14 Modified: 14 Oct 2016 21:53
Reporter: Kevin Gearhardt Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Migration Severity:S5 (Performance)
Version:6.3.7 OS:Microsoft Windows (Microsoft Windows 7 Professional)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[30 Jun 2016 17:14] Kevin Gearhardt
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\kgearhar\AppData\Roaming\MySQL\Workbench\log\wb.log]

It appears that your new version of Workbench no longer support migration from SQL Server 2000.  The schema list cannot be retrieved because Workbench is looking for sys.databases which is a SQL Server 2005 construct I believe?  It should be master.dbo.sysdatabases for SQL Server 2000.

How to repeat:
Try to migrate a SQL Server 2000 database.  Errors out every time.
[30 Jun 2016 17:15] Kevin Gearhardt
Workbench log file as requested

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

[6 Jul 2016 7:55] Milosz Bodzek
Thank you for the bug report.
[14 Oct 2016 21:53] Christine Cole
Fixed as of the upcoming MySQL Workbench 6.3.8 release, and here's the
changelog entry:

Database migration from Microsoft SQL Server 2000 emitted errors and
stopped when the operation failed to locate the required schema list
associated with the database version.

Thank you for the bug report.