Group: Forum Members
Posts: 386,
Visits: 2.1K
|
Hi Tim,
We used Merge Replication to good effect for a similar requirement, i.e. data collected remotely that needed to be shipped back to a central site plus receiving updates from the central site. This is an old app that used the MSDE engine on the laptops back to a SQL Server 2000 backend. However, it is my understanding that doing this now with Server 2008 and Express may not be quite so straight forward because Express doesn't come bundled with support for SQL Agent which may present problems with firing the SQL replication process. I think this is a move to encourage corporate applications to up-size to the SQL Workgroup Edition for remote users.
Cheers, Peter
|