Database synchronization, tools for...

[BoloBaby]

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!

 

[Ken Tucker [MVP]]

Hi,

Maybe this will help.
http://msdn.microsoft.com/library/d...ry/en-us/dndotnet/html/northwindunplugged.asp


Ken
---------------
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!