Does "Azure SQL Managed Instance" support publication distribution of transactional replication?

Question

Hi,

I want to implement transactional replication on a  database which should be on "Azure SQL Managed Instance", where entry will be done.

And the subscriber which will be read only and will be "on premises" (that is with our site offices)

Answer 1

Hi,

Does "Azure SQL Managed Instance" support publication distribution of transactional replication?

Yes

Check full demo here:

https://learn.microsoft.com/azure/azure-sql/managed-instance/replication-between-two-instances-configure-tutorial?view=azuresql&WT.mc_id=DP-MVP-5001699#8---create-publication-and-subscriber

And some inform here can help as well:

https://learn.microsoft.com/azure/azure-sql/managed-instance/replication-transactional-overview?view=azuresql&WT.mc_id=DP-MVP-5001699#overview

Answer 2

Azure SQL Managed Instance supports tranactional replication, see
https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-replication?view=sql-server-ver15