asked on

Connect to SQL server using MySQL

Hi,
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,

Mooks

imitchie

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.

imitchie

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

ASKER CERTIFIED SOLUTION

digital_thoughts

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mooklander

ASKER

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?

thanks,
Mooks

SOLUTION

imitchie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

stavrama

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mooklander

ASKER

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.
cheers!
Mooks