What are the challenges you face when working across database platforms? Take the survey

Copy Data Incrementally every 6 hours from source Synapse SQL Pool to Destination Synapse SQL Pool

Azure Synapse does not provide DR out of the box. Geo backup occurs every 24 hours once. I want to be able to copy only the changes from source synapse SQL Pool to destination SQL Pool in paired region.

Can Redgate do this ?



  • Options
    Hello Pramarao,

    I'm sorry to say the SQL Server architecture that SQL Compare depends upon is substantively different in Synapse, as such it's not currently on the roadmap to support.

    the only product we have that can address Synapse is flyway and the script authorship would be down to you or another tool, but flyway could then deploy those changes to a target of your choosing.
    Kind regards
    Peter Laws | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.