Friday, March 15, 2013 7:25 AM
I am designing a system where I have to keep in-sync Client databases with the Server database. There is one central Server (SQL Server 2008 with 20 tables) and around 30 Clients (SQL Server or SQL Server CE). Client won't need all the 20 tables but 10 would be a fair guess. This is a medical system in nature and it would be dealing with maximum 1200 patients so it's not a huge system. System is going to be deployed in very remote areas where internet won't be always available so I need some DB sync technology. Client DB will be synced with the Server once internet becomes available. After reading about available technologies I am inclined towards using Microsoft Sync.
My question is regarding the connection speed requirements for Microsoft Sync Framework. Client will be deployed in very remote areas. Internet will be available for short durations and internet speed will be very slow (Let's say download would be 20KB/sec Max).
I am concerned regarding the performance of Sync Framework in this kind of Internet speed. Are there any benchmarks which can give me an idea about estimated time of Sync with different connection speed values? Does it make sense to use Sync Framework when internet speed is this slow (for example 20KB/Sec). Will slow speed only effect in terms of time it takes to complete the sync or are there any other drawbacks as well?
I have no prior experience with DB sync technologies. This is first time I am doing something of this nature. If I am missing something major or this is not the right way to go in this kind of scenario, feel free to share your thoughts and ideas.
Friday, March 15, 2013 10:41 AMModerator
the performance of sync will be largely affected by the connection speed and the amount of data you're synching. but there are other factors as well like the performance of your databases, number of rows, frequency of changes, etc...