Azure SQL Server DBA

Data Integration & Replication

Question

Azure SQL Database transactional replication subscriber versus Managed Instance subscriber: how do their roles differ?

Answer

Azure SQL Database is a push subscriber only. Azure SQL Managed Instance supports push and pull subscriptions, subject to distributor/subscriber restrictions. Use SQL Database for one-way delivery; use Managed Instance when subscriber-side pull is required.

This is 11 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples