Post reply

Querying MySQL Database Tables from Microsoft SQL Query Analyzer and Vice Versa

  • July 26, 2006 at 9:18 pm

    #61687

    Hi all,

    Does anyone know if there is a way to query MySQL database tables from Microsoft SQL. Here is what im currently up against. I work for a company in which uses a mulitple server setup. Some of the servers having Microsoft SQL and the others, MySQL. We have numerous tables on each server and it has become very taxing in trying to find all the information we need in a timely fashion. Any help in the matter would be greatly appreciated.

    sinking fast,

    Jerry

  • July 27, 2006 at 5:48 am

    #651835

    If you need to pull the information into SQL Server, you can install MyODBC on the SQL Server and then created a linked server connection just as you would to any other ODBC data source. If you mean use QA to query directly against MySQL, that's not an option, unfortunately. The MySQL Query Browser is rather nice, however, and similar to QA.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply