none
sync Architecture Guidance RRS feed

  • Question

  • Hi,

    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.

    Thank you.


    ess

    Tuesday, October 23, 2012 1:56 PM

All replies

  • 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

    Wednesday, October 24, 2012 2:23 AM
    Moderator
  • Hi JuneT,

    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.

    http://code.msdn.microsoft.com/Database-Sync-SQL-Server-7e88adab

    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.

    


    ess


    • Edited by saitrips Friday, November 16, 2012 7:14 PM
    Friday, November 16, 2012 7:11 PM
  • 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 1:37 AM
    Moderator
  • Sure sir. I will go through the article in the link. 

    Thx q


    ess

    Saturday, November 17, 2012 4:49 AM