Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Can I connect to a Microsoft SQL Server with MySQL Workbench

Tags:

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
Sign in to Comment

Related questions

Set value of boolean (type = bit(1)) in Mysql Workbench
How to see errors in MySQL Workbench 6.1?
How to change a value of a field using MySQL Workbench?
What is the maximum allowance for group_concat_max_len in MySQL?
MySQL Workbench crashes on mac os (fresh install)
error code 1292 incorrect date value mysql
how to open multiple model/database in mysql workbench
Openshift: How to remote access MySQL?
Any way to put in order automatically tables in Mysql Workbench diagram?
Mysql workbench foreign key options [Restrict, Cascade, Set Null, No Action], what do they do?
How to execute multiple SQL queries in MySQL Workbench?
MySQL Workbench EER Diagramm - how to change storage engine?
MySQL Workbench EER Diagram changing table colors
How to Schema Diff two databases using MySQL Workbench?
Error Code: 1055 incompatible with sql_mode=only_full_group_by
MySQL Workbench: Error in query (1064): Syntax error near 'VISIBLE' at line 1
How do I delete a table from the MySQL Workbench catalog?
MySQL workbench table data import wizard extremely slow
MySQL Compatibility with MacOS Sierra
Errno 121, duplicate key on write or update?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!