Our company uses MSSQL2000 for our manufacturing database (job status, stock levels etc.). We wish to give our customers web access to the stock levels of their products.
The problem is that our IT department does not want to give the customers access to the manufacturing database via the web, for security reasons. It has been suggested that we setup MySQL on a separate Server and allow the webserver to query that database.
I'm looking for some guidance as to how I can automatically publish/mirror/replicate the Stocks table of MSSQL database into our MySQl database.
Any ideas/help/links etc would be very much appreciated!