We have a StrataFrame CRM application running on a central db server. All clients are connected to the main database. We have a requirement to allow sales reps the ability to enter new contacts, notes etc... on a laptop disconnected from the main server. When they reconnect, the contact and note changes synchronize to the main server and any changes on the server update back to the laptop.

Just wondering if anyone has successfully done this before with StrataFrame or any other technology.

Thanks,

Tim

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

Thanks everyone for your input. It looks like I have a lot of work ahead of me.

Well, let us know if you have some questions along the way!