SQL Server Management Studio Express and MySQL?

Question

Is there a way to use SQL Server Management Studio Express together with a MySQL database? I guess even if it works, intellisense wont work?

Thanks!

Solution 1

It will not works with MySQL.The name of product is "SQL Server Management Studio", so it manages SQL Server instances.

If you need tool with similar functionality, try Toad for MySQL, it's freeware or Oracle SQLDeveloper.

Solution 2

I don't know if you found the answer yet, but the following links can help:

1- HOWTO: Setup SQL Server Linked Server to MySQL
2- Creating Linked server to MYSQL from SQL Server

Solution 3

I can't see how this will ever work, SSMS is written only for MSSQL.

You can however create a link server to the mysql database and use it that way, I doubt intellisense will work though. see here for more info.

Comments

[rkosegi]

Yes, but you still need to manage existing SQL Server.Even when you connect ODBC linked database, you lose MySQL specific functinality, you will be limited by ODBC compatible features

[TBohnen.jnr]

you are correct, sql express will do fine however so that should not be an issue but this is the only way I can think of that it will be possible at all.

[Sam]

The name of the product is actually "Microsoft SQL Server Management Studio" despite the acronym being SSMS. SQL means "Standardized Query Language". I wish more aspects of SQL were standard like the LIMIT command! But, that's not relevant at all here.

[natenho]

Just for the record, "SQL" actually stands for "Structured Query Language"