MySQL Forums
Forum List  »  MySQL Workbench

MySQL Workbench not connecting to MS SQL Server for Migration
Posted by: Ira Fuchs
Date: February 07, 2020 04:29PM

I am trying to use MySQL WB (v8.0.19CE) to migrate a Windows MS SQL Server to MySql running on a Mac. I have downloaded and installed (using brew) mssql-tools and msodbcsql17. I have tested the Server and connectivity with sqlcmd and it works fine. However I cannot get the migration wizard to talk to the MS SQL server. I have used the Mac ODBC manager utility to define the driver although I'm not sure I have that set correctly. I pointed it to /usr/local/cellar/17/17.5.1/lib/libmsodbcsql.17.dylib. I then created a DSN which points to the SQL Server. In the Migration wizard I selected Microsoft SQL Server as the source and point to the DSN and the Driver. When I test the connection, the cursor spins for a few minutes and then asks for a password. I enter the password and it spins for several minutes and then spins the cursor and never stops.

Can anyone help?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Workbench not connecting to MS SQL Server for Migration
163
February 07, 2020 04:29PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.