Hi all,
I've noticed that it is (somewhat) possible to link MySQL or ODBC schemas into MSSQL Server but what I would like to do is link a MSSQL Server table to MySQL so that I can do cross-database joins. Having trouble finding this functionality, however. Does anyone know if there is a way or a tool out there to make a way? Using the ODBC data source would be the most helpful as I can foresee wanting to do this with other databases as well.
Thanks!
I've noticed that it is (somewhat) possible to link MySQL or ODBC schemas into MSSQL Server but what I would like to do is link a MSSQL Server table to MySQL so that I can do cross-database joins. Having trouble finding this functionality, however. Does anyone know if there is a way or a tool out there to make a way? Using the ODBC data source would be the most helpful as I can foresee wanting to do this with other databases as well.
Thanks!