Navicat supports the importing of data from ODBC data source. In this tutorial, we will show you how to set up an ODBC data source connection and import MSSQL data to a MySQL database using Navicat.
You should download and install a suitable ODBC driver from the web.
First, start the Import Wizard in Navicat and select “ODBC” as the import type.
Now, set the connection, username, and password to connect the server.
If the connection was successful, you can see all available tables in the list. Now simply select the tables you wish to import.
After that, you can continue the wizard and click the “Start” button to finish.
