Mysql workbench - connecting to MSSQL

Page content

  1. Follow this link https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql.html

  2. you have to install iODBC separately as MAC doesn’t seem to port it anymore. http://www.iodbc.org/

  3. The user has to have spl permission as shown in this video, 2:17 http://mysqlworkbench.org/2013/08/video-tutorial-setup-a-restricted-sql-server-account-for-migrations-with-mysql-workbench/

http://stackoverflow.com/questions/17038716/not-retrieving-schema-list-from-source-when-migrating-from-mssql-to-mysql-using