SQL Server to Azure Search Synchronization

Play SQL Server to Azure Search Synchronization


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: https://azure.microsoft.com/blog/2014/11/10/how-to-sync-sql-server-data-with-azure-search/



Download this episode

The Discussion

  • User profile image

    Change tracking isn't supported in SQL Azure, what is the recommended approach to sync SQL Azure data to Azure Search?

  • User profile image

    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:  https://social.technet.microsoft.com/wiki/contents/articles/2976.how-to-enable-sql-azure-change-tracking.aspx


  • User profile image
    Liam Cavanagh

    Just a quick update on my last comment. Azure SQL just announced (https://blogs.technet.com/b/dataplatforminsider/archive/2014/12/11/microsoft-strengthens-data-platform-with-sql-database-and-big-data-appliance-updates-adds-new-java-sdk-for-its-nosql-service.aspx) an update and one of the features in this update is support for Integrated Change Tracking.


Conversation locked

This conversation has been locked by the site admins. No new comments can be made.