Database Synchronizer

[upcomtech]

I am seeking an Add-on to monitor customer originated changes in an on-line V2.3.1 database and format the changes into valid Msql queries and e-mail then to me so I can run the queries on my local machine copy of my store.

I am running a WAMP server as a development base so I maintain identical sites on my remote and local servers.

 

I am doing significant product development with a dodgy Internet Provider. Sometimes there sometimes not.

Since the store is Live, changes to the online database, while the file is changing on my local machine, conflict. I have already manually added a new customers details before I uploaded and restored a large change since the customer registration occurred while I had the file and would have been lost during restore.

 

I would like to receive e-mailed queries which I can run in PhpMyAdmin to update the local database with the online changes.

 

Anybody gone down this path yet? (Usually when I get an idea, someone has already been developing it for several years.

My search turned up nothing.

 

I have mysql and php skills (sort of)

 

Any direction on how to go about designing such a beast would be appreciated. Or even better if one already exists.

 

Thanks

 

Don

Edited May 11, 2011 by upcomtech