Re: Migrate from SQL Server 2000 using Workbench

[Paul Guillou]

Thank you Milosz but the change was to alter it the other way around,
from
query_pre_90 = 'SELECT name FROM sys.databases'
to
query_pre_90 = 'SELECT name FROM master.dbo.sysdatabases'.

I made good progress buy after selecting which tables and views to migrate an APPCRASH occurred at the point of "Generate SQL CREATE Statements". Details below:

Problem Event Name: APPCRASH
Application Name: MySQLWorkbench.exe
Application Version: 6.3.7.0
Application Timestamp: 57581ea6
Fault Module Name: grt.dll
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 57581620
Exception Code: c0000005
Exception Offset: 000617c5
OS Version: 6.2.9200.2.0.0.272.7
Locale ID: 2057
Additional Information 1: 5861
Additional Information 2: 5861822e1919d7c014bbb064c64908b2
Additional Information 3: 5c1f
Additional Information 4: 5c1f554df00553b422a8baa03b19335a

What to do next?

Paul.