Hi.
This is a limitation of MSSQL of course. I did not realize that a database like MSSQL cannot handle a simple ORDER BY a short field if the rowsize is bigger than 8094 byte...
private static String procedureSelect = "SELECT ROUTINE_NAME, ROUTINE_TYPE, "
+ "MODULE_NAME, ROUTINE_DEFINITION "
+ "FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA=? "
+ "ORDER BY ROUTINE_NAME";
As a fix I removed the ORDER BY in ReverseEngineeringMssql.java and now it works. Please download the fixed files at
ftp://ftp.mysql.com/pub/mysql/download/mysql-migration-toolkit-1.0.7-patch-for-mssql.zip
Please extract them to .\bin\windows\java\com\mysql\grt\modules and overwrite the existing files there.
I also added the missing database field in the connection dialog.
I hope this addresses your problem.
Mike
p.s.: Please note that SPs cannot be converted automatically at the moment.
Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
Edited 1 time(s). Last edit at 06/01/2005 03:18PM by Michael G. Zinner.