We're going from a SQL-Server 2008 backend to a MySQL backend. What's the interoperability between SQL-Server and MySQL?
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
If not, what options can you recommend for integrating data across SQL-Server 2008 and MySQL?
Would LINQ provide any relief in regards to combining data from SQL-Server and MySQL?