By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,672 Members | 1,306 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,672 IT Pros & Developers. It's quick & easy.

Database synchronization, tools for...

P: n/a
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!

Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Hi,

Maybe this will help.
http://msdn.microsoft.com/library/de...dunplugged.asp
Ken
---------------
"BoloBaby" <bo******@hotmail.com> wrote in message
news:Iq********************@comcast.com...
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!


Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.