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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Direct/indirect access to database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-03 : 13:36:49
Lilian Odsbjerg writes "Hi there

I am working on a project (at 'school')in Denmark.

Several municipal administrations in Denmark have to 'deliver' online booking - reservations - of their public rooms on the internet for (very) different local societies. Some of these administrations do not want end users to have access to the 'original' database for different reasons.

Do you copy/replicate the database?
And - i suppose - the database on the internet (from the webserver/databaseserver) has to send updates to the original (?) How do you do this without the endusers knowing?
- and how to ensure the endusers (often private persons) that informations are new/updated and that the original database is updated too (frequent - for every new reservation or cancelling)?

Is this possible at all?
Does it require the databases at the administrations ('local-/intranet') and the one connected to/or on the webser to be equal in every way? Some is SQL Server - different versions. And other products in some administrations....

Any recommadations of litterature would be very much appreciated (thanks).

Lilian Odsbjerg"
   

- Advertisement -