Connect to SQL server using MySQL

 the company i work for has a SQL server to which i only have read access. Is there a way to connect to the sql server using mysql?
I was trying to use Toad for MySQL, but i dont even see a option to remotely connect to the SQL server.

Thanks in advance,

Who is Participating?
digital_thoughtsConnect With a Mentor Commented:
Not sure about going from MySQL tools to SQL Server, but if you can request a linked server to be added, you could have your MySQL box added and then access data using the OPENQUERY method.
TOAD is for MySQL only.
Your best option is probably to download the free SQL Server 2005 Express Management Studio (free) which can connect to SQL Server.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

mooklanderAuthor Commented:
thanks for the quick response experts. Is there no other alternative to do this with MYSQL. I had already created the database using sql server express, but was asked to try and recreate it in MYSQL.

Digital thoughts,
 Did you mean that i need the MySQL server connected as a linked server in the MS SQL server to achieve this?

imitchieConnect With a Mentor Commented:
Assuming you have installed the MySQL connection drivers, then yes, you can link from MSSQL to MySQL.
If you still have the create script (and not much data), then it's probably easier to recreate it from the script.
stavramaConnect With a Mentor Commented:
If you dont have installed sql server on your pc and assuming that you have access, you can do the following in order to export the tables to the new db on mysql.

First of all go and dl the odbc driver for mysql from this link:

You need to create 2 odbc connections. The first one will be in order to link the sql server tables from mssql to access and the 2nd will be in order to export the tables from access to mysql.

Go to administrative tools-> data sources(ODBC) and click add on the dbase files there. Choose sql server from the list and then click finish. On the new window that will appear, choose a name for your odbc driver and the server in which the sql db is. Click next and then next again. On the new window choose the database you want to use and then click next until it is finished.

The same thing you will do in order to create the odbc connection for mysql. Go again to data sources(ODBC) but this time choose mysql ODBC 3.51 Driver. On the new window fill  the following:

name: The name of the driver
server: Where mysql is
user: root
pass: password
database: the db in which you want to migrate the sql db.

Now open your access, click open file and choose the ODBC databases on file of type. On the new window, go to machine data source and from there choose the odbc driver we created for the access.
Choose the number of tables you want to link and click ok.

Now, left click to a table and choose export. On the new window choose again odbc databases to save as type and then specify the name of the new table that will be exported on your mysql db. Choose again after that the machine data source and this time pick the odbc driver for mysql. Do that for every table and your new db will be ready. I hope that this will help
mooklanderAuthor Commented:
was unable to try and implement this because of changes to the project. Just wanted to thank you experts for taking your time out for this.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.