Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can I connect to a Microsoft SQL Server with MySQL Workbench

Is it possible for me to connect to a MSSQL database server with MySQL Workbench?

like image 906
moe Avatar asked Oct 30 '12 22:10

moe


People also ask

Can MySQL connect to Microsoft SQL Server?

No, you cannot use MySQL to connect to MSSQL. You have to use clients that were specifically created to understand MSSQL protocol. One of the most popular solutions for this on Linux is FreeTDS. Also, you can use ODBC or JDBC drivers provided by Microsoft.

Is MySQL Workbench the same as SQL Server Management Studio?

MySQL and SQL Server are two different data bases, so MySQL Workbench is the graphical management tool for MySQL and SQL Server Management Studio is the graphical management tool for SQL Server. Both let you interact with their respective database in an easy way.


1 Answers

You cannot use MySQL Workbench as a Microsoft SQL Server client.

But technically speaking, yes, you can connect to a Microsoft SQL Server database using ODBC if you are using the database migration wizard.

Source: https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-connection.html

like image 92
Jake From State Farm Avatar answered Sep 28 '22 06:09

Jake From State Farm