Tuesday, October 23, 2012 1:56 PM
I have multiple database on LAN network at different location and each LAN database has corresponding database on cloud. plz refer my attachment.
Now I am working on designing good sync architecture that handles this scenario effectively and request your suggestions/gudiance.
Right now I am working on N-tier sync api (WCF) that synchronize one database (lan-cloud) and code working with few errors.
could anyone suggest me how I can extend this N-tier sync api (WCF) to all databases on LAN-CLOUD effectively without connection throtling problems and performance problems.
Wednesday, October 24, 2012 2:23 AMModerator
have you looked at the Azure SQL Data Sync Service?
have a look at this article as well: How to Sync Large SQL Server Databases to SQL Azure
other performance tips:
- set the ApplicationTransactionSize
- plan you scopes well (see: Sync Framework Scope and SQL Azure Data Sync Dataset Considerations )
- locate your WCF service nearest to your Azure SQL Database
- sync frequent with fewer changes rather than accumulating large chunks of changes and synching in one go
Friday, November 16, 2012 7:11 PM
Sorry for responding u back after long time on this thread.
Actually in my case, its not Azure Cloud. It some private cloud. So I am trying use following example.
Can I design my architecture as attached
As multiple window service clients accessing single WCF service. will there be any performance over head.expecially on all clients Batching is enabled. So the machine with IIS installed will be flooded with batch files from multiple clients.
Or shuld I create a WCF service to each Window service client.
- Edited by saitrips Friday, November 16, 2012 7:14 PM
Saturday, November 17, 2012 1:37 AMModerator
the Azure SQL Data Sync service architecture is almost like that :)
I suggest you have a look at this as well, just ignore the part where it interacts with SQL Azure and blobs... this should give you a good starting point on how to build the services part: Walkthrough of Windows Azure Sync Service Sample
Saturday, November 17, 2012 4:49 AM
Sure sir. I will go through the article in the link.