Our website is hosted by a third party company using Linux and Apache. Internally, we have SQL Server 2008. I want to be able to provide our clients access to their data from our website. I don't want to have to export data from SQL to mySQL, as that would be a constant process to make sure the data was up to date. Currently, our SQL server does not have an external IP address.
I just need some ideas of how to make this happen.