MySQL Forums
Forum List  »  Microsoft SQL Server

Connecting MySQL to SQL!
Posted by: Angelo Wolfe
Date: July 19, 2011 03:11PM

Hello MySQL community!

I was looking for some assistance regarding connecting to a SQL Server. I have seen many, many different posts and websites that hint at third-party programs and all sorts of different alternative tools. But I feel there should be a simplistic way to do this. If you can point me towards some reading material or have a good suggestion of how to do this, please let me know!

Now, I plan on hosting a MySQL Server / Database on a machine to act as a backend, and will use Microsoft Access 2007 as a front-end. I can set the MySQL server up easily and can verify it connects through linking to it no problem. Here's the issue:

The data I want is being hosted on a SQL Server and is not going to remain on that server. So, I have to find a way to connect MySQL to the SQL Server, append / dump the data into MySQL tables (They can be identical), and run my queries from the static data. Any suggestions? I can find information on how to import MySQL into SQL, but not the reverse.

Thanks in advance!

Options: ReplyQuote

Written By
Connecting MySQL to SQL!
July 19, 2011 03:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.