Cancelled

Insert order from cpanel mysql to windows server mysql

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

Skills: MySQL, PHP, Windows Server

See more: cpanel mysql database, new windows server, cpanel windows, mysql to sql, job order, insert, access order, windows order, mysql running, found server, php server cron job, linux cron job php, insert sql, sql script mysql, cron mysql, php cpanel script, mysql logs, php windows 2003 server, linux php cron job, open access linux php, access mysql php linux, php open access database linux, cpanel cron, order windows, server found

About the Employer:
( 27 reviews ) Brantford, Canada

Project ID: #1261352