Copy Data Incrementally every 6 hours from source Synapse SQL Pool to Destination Synapse SQL Pool
Pramarao
Posts: 2 New member
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 ?
Can Redgate do this ?
Tagged:
Answers
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.