Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
damon88
Starting Member
5 Posts |
 Posted - 2012-02-07 : 05:40:21
|
| I want to ask if its possible to pull data from a different server , MYSQL server on a different machine from Microsoft Sql Server function or subprocedure. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-07 : 06:54:38
|
| You can create a linked server and use OPENQUERY. I have not tried this with MySQL, but this page shows step by step instructions, and seems straightforward: http://sql-articles.com/blogs/creating-linked-server-to-mysql-from-sql-server/ |
 |
|
|
damon88
Starting Member
5 Posts |
|
|
|
|
|
Access MYSQL database from Microsoft Sql ?