Could not find stored procedure 'sys.sp_databases' | MySQL Import SQL Server
Run MySQL Workbench 6.3.4, and set:
However, not work:
Installed the latest MySQL Workbench 6.3.8, then solved it
Update
#@ref https://www.martin-brennan.com/could-not-successfully-convert-ucs-2-string-to-utf-8/
Source RDBMS Connection Parameters
Parameters:
Database System: Microsoft SQL Server
Connection Method: ODBC Data Source (FreeTDS)
#Already Administrative Tools\Data Sources (ODBC) set
DSN: Local (ODBC Driver 11 for SQL Server)
#Leave blank if specified in data source
Username: {BLANK}
Protocol Version: {Microsoft SQL Server VERSION}
Advanced:
Tick: Drive sends Unicode data as UTF-8
However, not work:
#@ref http://bugs.mysql.com/bug.php?id=73142
Fail: Retrieve schema list from source
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_grt.py", line 186, in getCataloggNames
return [ row[0] for row in execute_query(connection, query ]
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_grt.py", line 62, in execute_query
return get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'sys.sp_databases'. (2812) (SQLExecDirectW)")
Installed the latest MySQL Workbench 6.3.8, then solved it
Update