Greetings!

We use a web-based, Cold Fusion shopping cart system for a specialty mail order bookstore and need to start showing accurate stock levels for all of our 12,000 titles. The online data is stored using a shared SQL server. Since it is a shared server, we do not have admin rights to SQL.

Our mail order business is run locally using Mail Order Manager (MOM for short). MOM uses VFP free tables to store its data. We do not have access to its code. To further complicate matters, the MOM inventory table does not have a datetime stamp that indicates when data is changed.

Initially we need to sync the remote SQL levels with the local VFP inventory levels. Later, we will be automating order entry of all web orders by importing them into MOM and having MOM process the orders. We will probably write a routine that will update the web inventory level for orders placed online, prior to their being imported into MOM.

What is the best way to accomplish the goal of syncing our remote SQL inventory table using our local VFP inventory data?

Thanks in advance.