?
Solved

Connect to SQL server using MySQL

Posted on 2007-12-06
7
Medium Priority
?
731 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:mooklander
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 25

Expert Comment

by:imitchie
ID: 20423030
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.
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20423032
0
 
LVL 8

Accepted Solution

by:
digital_thoughts earned 800 total points
ID: 20423071
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.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:mooklander
ID: 20423143
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
0
 
LVL 25

Assisted Solution

by:imitchie
imitchie earned 800 total points
ID: 20423188
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.
0
 
LVL 2

Assisted Solution

by:stavrama
stavrama earned 400 total points
ID: 20426564
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:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

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
0
 

Author Closing Comment

by:mooklander
ID: 31413251
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
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question