On Fri, 10 Oct 2003 18:22:51 +0200, "Simon Hayes" <sq*@hayes.ch>
wrote:
"Hans Rytter" <hr*@post7.tele.dk> wrote in message
news:3f***********************@dread15.news.tele. dk... Hi !
Hi !
I'm thinking of installing a Microsoft SQL Server 2000 on a database
server, to be the db of a webapplication, but the it must be possible for the
users to copy/replicate data from the server db, to a local db on their e.g.
laptop to work even if not online. Is there a tool that can handle this
scenario. (it must be possible to update the server db from the laptop
when online again ).
And:
What have to be installed on the laptop (apart from my application running
on the replicated data) ?
Thanx
/Hans
It sounds like you're looking for merge replication. You could install MSDE
on the laptops, then use merge replication to handle the synchronization of
data. Replication is discussed in Books Online, although it's potentially a
complex area, so you might want to consider posting to
microsoft.public.sqlserver.replication for more advice.
Simon
Well for a start if it's a web app then they need a web server!
Seriously, consider doing this in dot net. You can use the same tool
to build the web app, using asp and a windows forms app. You may be
able to share a lot of the code if you design it right. The web forms
app will store it's data in XML and load it into datasets when the app
is running. MS have an example of this, the idea being salesmen taking
orders on the road and then hooking back up to the central office for
upload. The laptops would need the dot net framework, which I think is
built in to XP and def win 2003.