I am able to access the tables and database using the MYSQL Workbench but would VERY much prefer if I can see all of the tables and information using Microsoft SQL Server (2005 or 2008), which is what we currently use for all of our other SQL needs.

I have the MySQL ODBC connector installed if that would help anything, but am not seeing the connector for Microsoft SQL Server program. 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

4

You have to set it up as a linked server, which I believe would be something like this: http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/

Answered 04/11/2013 by: jknox
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity