SQL Server to Azure Search Synchronization | Data Exposed

[Scott Klein]

This week on Data Exposed, Scott welcomes back an old friend, Liam Cavanagh, Senior Program Manager for Azure Search, to discuss some of the new features added to Azure Search as well as look at how to keep an Azure SQL Database in sync with Azure Search, enabling you to provide near-real time updates to your search index. Liam begins by explaining many of the reasons why people choose to leverage Azure Search to provide full-text search over their SQL Server data and how to leverage a capability in SQL Server called Integrated Change Tracking to efficiently find changes in your SQL Server tables to uploaded to Azure Search. The source code for the sample in this video as well as more details about this topic can be found here: http://azure.microsoft.com/blog/2014/11/10/how-to-sync-sql-server-data-with-azure-search/

[Broken External Image]:http://m.webtrends.com/dcs1wotjh100...ntry:RSSView:b786a989c96047599e59a3ee01346852

Continue reading...