SQL-Server和MySQL的互操作性? [英] SQL-Server and MySQL interoperability?
问题描述
我们正在从SQL-Server 2008后端过渡到MySQL后端. SQL-Server和MySQL之间的互操作性是什么?
We're going from a SQL-Server 2008 backend to a MySQL backend. What's the interoperability between SQL-Server and MySQL?
我们将能够运行引用服务器中数据库中的表的SQL查询吗?
Will we be able to run SQL Queries that reference tables from databases across the servers?
例如,是否可能这样:伪代码
For example, is this possible: pseudo code
SELECT *
FROM
[SQL2008Server].[databaseA].[DBO].[table1] as t1
INNER JOIN
[MySQLServer].[databaseB].[dbo].[table2] as t2
ON t1.id = t2.fkid
如果没有,您可以推荐哪些选项来跨SQL Server 2008和MySQL集成数据?
If not, what options can you recommend for integrating data across SQL-Server 2008 and MySQL?
LINQ在合并来自SQL Server和MySQL的数据方面是否可以提供任何帮助?
Would LINQ provide any relief in regards to combining data from SQL-Server and MySQL?
推荐答案
可以将MySQL服务器作为链接服务器添加到SQL Server中.
It is possible to add a MySQL server into SQL Server as a linked server.
设置完成后,您可以使用OPENQUERY进行查询,如下所示:
Once you have set it up you can query using OPENQUERY like this:
SELECT t1.colA, t2.colB
FROM SQLdbName.dbo.tablename AS t1
INNER JOIN OPENQUERY(MySQLlinkedservername,
'SELECT colA, colB FROM tablename') AS t2
ON t1.colA = t2.colA
这篇关于SQL-Server和MySQL的互操作性?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!