John,
and it's complicated to set it up correctly.
Even as an experience programmer, I still think it a complicated setup for
basically transferring data from one database to another.
Unfortunatetly, we will not have access to any internet connections while
in the field. So, all field data (computers) will return to the office by
the end of the day.



"John W. Vinson" wrote in message
...
On Thu, 27 May 2010 08:39:46 -0400, "Thomas Kroljic"
wrote:

John and Pieter,

Thanks for the tip. Is Replication stable? The last time attemtpted to
use it was 8 years ago. At that time it seem like a pain-in-the-butt...in
the end, we ended up using Terminal Services. Unfortunately, I don't have
that option at the moment.
I'll check on David Fenton in the group you listed below.

It's stable, it does the job, it's a pain in the butt, and it's
complicated to
set it up correctly. I've used it with two clients and they both ended up
using Citrix (terminal services basically).

It is possible to "roll your own" replication as you suggest, but it's a
VERY
complicated and difficult process; you wouldn't be reinventing the wheel,
more
like reinventing an automatic transmission!
--

John W. Vinson [MVP]