I am looking for tools, components, or code that will help synchronize local
data with a database on a web server.
Basically, we have the following:
- Multiple remote sites with identical database schemas
- A single web server DB with compiled data from the remote sites -
identical schema
- The ability to define any schema I want, since this application is in the
design phase (that is, I can add synchronized y/n columns if necessary, or
whatever the tool requires)
What I need:
- A tool/component/code that monitors connectivity to the web server's DB
- Accepts local data and attempts to add it to the web server's DB AS SOON
AS IT IS RECEIVED (no batch operations - required for "real time" reporting
from the web server's DB)
- Queue's up data that failed to add as soon as the web server's DB becomes
available again
- Writes data to the local DB
Would be nice:
- If it operates with any ODBC compliant data source (planned for local MDB,
server SQL Server)
- No per site licensing fees (otherwise, I'll write my own because the
client is cost sensitive)
Thanks for any information!