Re: MySQL Migration Toolkit 1.0.7 beta released (MS SQL Server migrations)

[Sinisa Jovanovic]

I do have problem connecting source as MS SQL
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class net.sourceforge.jtds.jdbc.Driver
Opening connection ...
Connection jdbc:jtds:sqlserver://zzzz:1433;user=xx;password=yyy
Fetching schemata list.
SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES GROUP BY TABLE_SCHEMA UNION SELECT ROUTINE_SCHEMA AS SCHEMANAME FROM INFORMATION_SCHEMA.ROUTINES GROUP BY ROUTINE_SCHEMA
The list of schema names could not be retrieved (error: 0).
Invalid object name 'INFORMATION_SCHEMA.ROUTINES'.
Details:
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150)
net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:587)
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:323)
net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1041)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)