Windows Azure Platform >
> 
> 
Azure Table (NoSQL)

Answered Azure Table (NoSQL)

  • Sunday, April 15, 2012 3:55 PM
     
     
    Sign In to Vote
    0

    Hi.

    I am try to build  a distributed database system, so I need replication in the system. Also I need to replicate data between local data sources and Azure databases. I am thinking about using Tables because I will always read one entity at a time. Is there a way to create a local Tables like azure tables, and also is there a way to create row filtered replication.

     

All Replies

  • Tuesday, April 17, 2012 1:25 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    Hi mhand7,

    To replicate data between SQL Azure databases or SQL Azure and SQL Server databases, you may consider SQL Azure Data Sync Service. With which, you can select tables in the database to replicate, and configure a schedule to process the replication incrementally. It is possible to filter data on rows level, but right now, it only supports table level. In your scenario, you may need to split data into different databases to replicate. For more information: Using SQL Azure Data Sync Service to provide Geo-Replication of SQL Azure databases.

    Stephanie Lv

    TechNet Community Support