Skip to main content

Community

Replication from contained availability groups for High-Volume Agent SQL Server

Answered

Please sign in to leave a comment.

Comments

2 comments

  • Official comment

    Hi Aditya,

    Thanks for reaching out and for sharing details on your SQL Server configuration. HVA SQL Server is slated to reach EoL by March 2027; I'd suggest using the Binary Log Reader update method in the SQL Server connection instead.

    That said, we do not currently officially support Contained Availability Groups when reading from the online transaction log. Our initial analysis suggests it's likely to work, and we're working on validating this to give you a definitive answer.

    In the meantime, if your database is in full recovery mode and backups are available in native SQL Server format, I'd suggest using Backup mode with the SQL Server Binary Log Reader as your path forward.

    Thank you again for sharing valuable feedback with us!

    Best, 
    Rean Rodrigues, Product Manager - Databases

    Hi Rean,

    We are reviewing the Fivetran Binary Log Reader setup methods and understand that it supports two options: Online Transaction Log and Backup Transaction Log.

    Our primary objective is to reduce data replication latency and achieve near-real-time data synchronization. We understand that using the Backup Transaction Log method may introduce additional latency due to the transaction log backup schedule and processing.

    Therefore, we are considering the Online Transaction Log method to minimize latency.

    Could you please confirm whether the Online Transaction Log method would help us achieve near-real-time data replication and meet our latency requirements? Additionally, are there any prerequisites or limitations we should consider before choosing this method?