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.
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.