Synchronisation wit local database

[pipipi]

Hello,

 

Did anyone already solve this task? How is this done best?

 

I have an OsCommerce Webshop. The products are maintained in a local MSSQL database in the office of my customer. How do I move the products automatically from the MSSQL database to the OsCommerce database at my webhoster? I’d like this to be done automatically with a script every day.

 

Thanks for any answers!

[lapaz]

For copying and synchronising databases I use SyncTables (http://SyncTables.com). The SW can copy and synchronise between MySQL, MSSQL and Access. Databases at webhosters can be reached with an http-tunnel.

 

I find SyncTables great, maybe it is what you are searching?