Synchronizing with SQL Azure Data Sync RRS feed

  • Question

  • Hi,

    I am currently studying several possibilities to synchronize SQL Server databases on premises to an SQL Azure database.

    The scenario is more or less like this:

    - Each of our customer has its own database.

    - Each of our customer would like to publish some of their data to a centralized database in the cloud.

    - We want to host that data in SQL Azure.

    - Customers must be able to update their data on their local database and have it reflected on the SQL Azure database.

    - Customers can't change data from other customers.


    We plan to export some data of the SQL Server on premises database to new tables (containing less columns, etc) of a different schema in the same database because I've seen that SQL Azure Data Sync creates some tables and columns for data versioning on the synchronized databases.

    Is SQL Azure Data Sync a good candidate to implement this? Has anyone done anything similar with SQL Azure Data Sync??


    Best regards,

    Manuel Felício.

    Tuesday, June 14, 2011 11:05 AM


All replies