We have a database on our central servers that is the backend to a web
application we have in ColdFusion. About 4 times a year, we have a user
that goes out to other locations without internet access that would need
access to this application. Once she comes back to the office, we would
like to update any changes she has made to the central server database.

What is the best course of action to do this?

To start, we thought we would install msde on the laptop, along with a
single user version of ColdFusion and IIS so she could run the application.

How would we get that new data from her laptop to our main database?

Thanks for any input.

"Member" <mcleanap (AT) REMOVETHISSPAMrogers (DOT) com> wrote

MSSQL merge replication is intended for this sort of scenario (see
Books Online), however it might be overkill for a single user.
Depending on the volume of data and the business logic you need to
apply if there are conflicts between the laptop data and the central
server data, you might find it simpler to just create a linked server
from MSDE to the central server. You can then use ordinary queries
like 'INSERT ... SELECT ... WHERE NOT EXISTS (...)' etc. to add new
data and update existing data.

You might want to post in microsoft.public.sqlserver.replication if
you have specific questions about merge replication.

Simon