Share via

Replication from on premises to SQL Managed Instance

Saikumar Goud Gaddam 1 Reputation point
2020-07-30T18:09:28.737+00:00

Hi,

Will transaction replication work from On premises to SQL Managed Instance. If yes, what are the terms and conditions and What ports should be open from both sides.

Thanks,
Saikumar Gaddam

Azure Database Migration service
Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2020-07-31T10:04:46.177+00:00

    Hello @Saikumar Goud Gaddam Thank you for reaching out.

    Yes, Transactional replication between an OnPrem SQL Server to Azure SQL Managed Instance is supported.
    All firewall configuration requirements are provided here

    By terms and conditions did you mean limitations?
    Azure SQL MI can support being a Subscriber from the following versions of SQL Server:

    • SQL Server 2016 and later
    • SQL Server 2014 RTM CU10 (12.0.4427.24) or SP1 CU3 (12.0.2556.4)
    • SQL Server 2012 SP2 CU8 (11.0.5634.1) or SP3 (11.0.6020.0)

    Please let us know if you have any further questions

    --

    If an answer is helpful, please "Accept Answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    0 comments