Azure Synapse support across red-gate products
ben_b
Posts: 84 Silver 2
Hi All.
I've searched the forums and found a few answers (some of which were recent but some of which were a couple of years old), but I was hoping to get all the information in one place and confirmed.
Do the Red-gate SQL Server products work with Azure Synapse Dedicated SQL Pools.
I'm thinking
SQL Prompt - Yes
SQL Compare - No
SQL Data Compare - No
SQL Monitor - No
SQL Source Control - No
Flyway Desktop - ??
My company uses Synapse and the DWH team works with the DBA team to do deployments which they are struggling with somewhat (they use GitHub / AzureDevOps pipelines). I'm in a different team so don't have much access at current so can't test it out.
cheers
Ben
I've searched the forums and found a few answers (some of which were recent but some of which were a couple of years old), but I was hoping to get all the information in one place and confirmed.
Do the Red-gate SQL Server products work with Azure Synapse Dedicated SQL Pools.
I'm thinking
SQL Prompt - Yes
SQL Compare - No
SQL Data Compare - No
SQL Monitor - No
SQL Source Control - No
Flyway Desktop - ??
My company uses Synapse and the DWH team works with the DBA team to do deployments which they are struggling with somewhat (they use GitHub / AzureDevOps pipelines). I'm in a different team so don't have much access at current so can't test it out.
cheers
Ben
Tagged:
Best Answer
-
Ben_P Posts: 233 Silver 2Hi Ben, Thank you for your past.
Support for Azure synapse is limited to Flyway Desktop I'm afraid.
SQL Prompt does not support Azure Synapse either. Some functions may work but it is not officially supported unfortunately.
Answers
There aren't at present but you can add your vote to UserVoice for this feature. The more votes it receives, the more likely the development team will prioritize it for future work.
https://redgate.uservoice.com/forums/602209-redgate
Victoria Wiseman | Redgate Software
Have you visited our Help Center?