Data Synchronization


Author
Message
Tim Dol
Tim Dol
Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)
Group: Forum Members
Posts: 340, Visits: 1.4K
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

Replies
Peter Jones
Peter Jones
Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)
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
Tim Dol
Tim Dol
Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)Advanced StrataFrame User (666 reputation)
Group: Forum Members
Posts: 340, Visits: 1.4K
Thanks everyone for your input. It looks like I have a lot of work ahead of me.
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Well, let us know if you have some questions along the way! Smile
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search