Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-30 : 08:53:16
|
| Phil writes "Hello,You will have to excuse my lack of knowledge of the subjects I'm asking about. I work at a major University and we are taking on the task of writing a "dining access" system that allows students to swipe meals, using their student ID card, on a "pay as you enter" basis. This idea we want to implement, hopefully, is MDSE (Microsoft data engine) on all the local stations the students go to at the different halls. My question is about MDSE.From my understanding of MDSE, your workstation acts as a local database that you use that can either be networked or stand alone. If I am wrong please correct me. In all of our transactions we will have many workstations that hopefully will all be running MDSE and doing some form of replication to a server. The type of replication we will use is yet to be determined, but because the data we have needs to be up to date pretty much instantly I think we may use transactional replication. Is doing replication and using MDSE in this type of environment feasible? Can we only replicate certain tables, stored procedures or database(s) to those local machines? If the network goes down will the local machines keep writing to their local databases so that when the network comes up again, the transactions will be "pulled" up to the server? How hard is MDSE and replication to set up?I would really appreciate any of you guys who have done this type of thing before or know about it, to post to this question. Your help would be greatly appreciated.Thanks,Phil" |
|
|
|
|
|
MDSE and replication