Home > Documentation >
MS SQL to MySQL > Tutorial
Step 2 of 7. Connect to SQL Server
On this screen SQL Server to MySQL converter allows to provide necessary
information for connection to MS SQL or Azure SQL. In "MS SQL
Server" field the name of MS SQL instance must be specified.
Leave it empty if connecting to the local server. Custom SQL Server port
(other than 1433) can also be specified in "MS SQL Server" field
where 1234 is the custom port. Then select the type of authentication to use
when connecting to SQL Server:
- Windows authentication - SQL Server validates the connection via
Windows user information. The user has to be authenticated by Windows before
access is granted.
- SQL Server authentication - SQL Server will use the standard security
validation. To use this option, specify user name and password recognized on
the target MS SQL Server.
In "SQL Server authentication" mode MS SQL to MySQL converter
shows database tables owned by the specified user only. You can change it using
"Connect as database owner" checkbox. It will force the program
to display all tables from "dbo" tablespace, but only if the specified
user has enough privileges to read them. Otherwise, the option will not
If connection to MS SQL failed, read How
to configure SQL Server article for possible workaround.
If you are connecting to Azure SQL, see How
to connect to Windows Azure SQL article for related information.
Have questions? Contact us