Saturday, March 1, 2008

Accessing MySQL tables from MSSQL

While my main task is to convert this huge database from mssql to mysql, there are still many legacy applications that need to speak to the sql server database. After searching online for a while, I found the "linked servers" feature in sql server that may allow the our legacy apps a way to speak to the new database using sql server essentially as a proxy.

The article is a little dated, so I'm not sure if this will work, but it's definitely worth investigating.

No comments: