question

rajeshyadav-0048 avatar image
0 Votes"
rajeshyadav-0048 asked Cathyji-msft edited

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

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)

sql-server-transact-sqlazure-sql-databaseazure-sqldatabase-edge
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

pituach avatar image
0 Votes"
pituach answered pituach edited

Hi,

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

Yes

Check full demo here:

https://docs.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://docs.microsoft.com/azure/azure-sql/managed-instance/replication-transactional-overview?view=azuresql&WT.mc_id=DP-MVP-5001699#overview

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.