Dear netters,
I'm trying to set up a db architecture for a community school environment with the following restrictions:
- each school uses a simple application, storing data in an an .mdb file
- school data must asynchronously update a central server (SQL server) that stores data from all the school files and publishes them on the www
- no permanent interner connection is guaranteed (schools work offline and update the server periodically)
I'm checking MS solutions for the above requirements. Is "replication" the right place to start? Should I look into some other capability of Ms products (wharehousing?)?
I would appreciate some guidelines on how to organise my search for solutions.
Thanx in advance,
Vas.Mail the req's and I'd be glad to consult...cheap rates!
No replication is not the place to start..
A entity relationship model is...
Actually a process model diagram is...|||come on, we're talking about school system here! they can't afford to pay teachers the rate that they deserve! ...and what are your rates? :)
but you're right, - process model combined with the erd will give us an idea here on how to tackle this.
Sunday, February 12, 2012
collecting data from different mdbs
Labels:
architecture,
collecting,
community,
database,
dear,
environment,
following,
mdbs,
microsoft,
mysql,
netters,
oracle,
restrictions-,
school,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment