How To Sync Local And Web Database?

I am wondering if their is a strategy or tool for syncing a local
database with a web-based database? Specifically I have an application
where orders are entered via a web form and the data emailed to my
client who processes the orders. I extract the order information and
update a local "order tracking" database. There are several order
processing steps.

I want to update a web database to reflect the status
of the order as it flows through the local tracking application. I will
send an email to the "orderer" at the major steps, but my client wants
to have a web-based report shows the status of all orders for a company
that has pending orders. In other words a company will enter multiple
orders and will be able to track the status of the orders by signing on
to the web site.

This status report gets its data from the
web-database.....which I must update from the local tracking database.
A pretty long winded explation which I hope mades sense. Has anyone
found a solution to this problem? Any reference or tools you can
suggest?