Azure SQL DB Transactional Replication
In this episode of Data Exposed, Scott Welcomes Jean-Yves Devant (commonly known around these parts as JY), a Senior Program Manager in the SQL Server team. In this video JY introduces to an awesome technology that allow you to move data between on-premises SQL Server and Azure SQL Database called Azure DB Transactional Replication. This is simply the ability to set Azure SQL DB as a subscriber of SQL Server Transactional Replication.
JY begins by explaining the why, what, and then the how; why they build this awesome technology and the use case scenarios you would want this technology, the architecture and characteristics of SQL DB Transactional Replication, and then jumps into a great demo that shows how to setup, configure, and replicate data between on-premises SQL Server and Azure SQL Database using Azure SQL DB Transactional Replication.