How can we help you today? How can we help you today?

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 ?

Poornima T Ramarao
0

Comments

1 comment

Sort by
  • Peter_Laws
    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.
    Peter_Laws
    0

Add comment

Please sign in to leave a comment.