locked
SQL Azure Data Sync (DW and Data Marts) RRS feed

  • Question

  • We have a project that requires deployment of a Data Warehouse in the customer's HQ and datamarts in every geographical branch location across the world. Being new to SQL Azure, we are wondering if SQL Azure Data Sync as a possible component of our DW Architecture.  SQL Azure Data Sync, according to a few readings can geo-synchronize data whether on premise or on any one of the SQL Azure data centers.  I’m still reading up on what exactly it can and can’t support (in comparison with traditional peer to peer or transactional replication) – like say how it handles conflict resolution.

    Would like to know beforehand what’s good and what’s bad.  Would like to know how reliable it is?

    Thanks in advance.

    Wednesday, July 18, 2012 12:27 PM

Answers

  • the Data Sync service is in Preview mode, so there are mix experiences around its reliability.

    the service also requires that the hub database reside in SQL Azure.

    if your customers HQ and Branch databases are on-premise, that means, they will need to pass thru the service and the hub database when synching.

    consider you want to sync HQ to Branch A, the sync will be:

    on-premise HQ => SQL Azure Hub => on-premise Branch A.

    assuming Branches are on SQL Azure as well, it still goes thru the same path:

    on-premise HQ to SQL Azure Hub to SQL Azure Branch DB.

    The built-in conflict resolution resolution policy is a basic Hub Wins or Client Wins.

    Here's some good reading on the service: Appendix A - Replicating, Distributing, and Synchronizing Data

    • Proposed as answer by amber zhang Thursday, July 19, 2012 2:35 AM
    • Marked as answer by DJose Thursday, July 19, 2012 4:58 AM
    Thursday, July 19, 2012 2:02 AM
    Answerer