Skip to main content

Connector Improvement: Support ApplicationIntent=ReadOnly for SQL Server Connectors

Answered

Comments

1 comment

  • Official comment
    Kevin

    Hi Anth,

    Thanks for your feedback! One of the key processes of our SQL Server replication is reading from either Change Tables or Change Data Capture.

    For Azure SQL specifically, we need to connect to the primary as AGs are not supported.

    One possibility is to read from a secondary for the import phase using the ApplicationIntent parameter, and then leverage the primary only for the change logs. This is certainly something we can discuss internally.

    We are always looking to improve performance for our connectors, and SQL Server is a priority for us. This feedback helps us make decisions for the product and is much appreciated!

    We don't have this on our roadmap at the moment, but I will bring it to the team for discussion.

Please sign in to leave a comment.