I have a windows 2003 server that is running a database. I then have a cpanel server with a website on it and a mysql database for that website. What i want to do is when someone places an order on the website I want to also insert this order into the mysql on the windows side. I have access to both systems so i was thinking a php script on a cron job running on the linux box. When the cron runs it checks for new orders and if one found it logs into windows box sql and inserts order. If you have a better idea let me know i am open to suggestions.
The windows server is running microsoft sql server 2005