Episode 19: Azure Search with Liam Cavanagh
Liam Cavanagh
LiamCavanagh
Check me out on the web at SQL Azure Datasync | Windows Azure Products | Windows Azure Platform or at my blog.
LiamCavanagh
LiamCavanagh
Comments
SQL Server to Azure Search Synchronization
Hi Carl,
There are a number of ways that you can do this with SQL Azure including using datetime (last modified columns) or rowversion style columns. There is also an article that talks about adding change tracking to Azure SQL here: http://social.technet.microsoft.com/wiki/contents/articles/2976.how-to-enable-sql-azure-change-tracking.aspx
Liam
Using SQL Azure Data Sync Service to provide Geo-Replication of SQL Azure databases
Yes, SQL Azure Data Sync does support conflict handling and automatically resolves any conflicts for you. As for filtering the only level of filtering currently available is at a table level (meaning you can choose to sync only specific tables). Over time we will add more filtering down to the level of rows and columns.
Liam