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

Azure Synapse support across red-gate products

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
ben_b
0

Comments

4 comments

Sort by
  • Ben_P
    Hi 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.  


    Ben_P
    0
  • ben_b
    OK, thanks @Ben_P - useful to know :)
    ben_b
    0
  • acperkins
    Are there any plans to support Synapse for say SQL Compare or SQL Data Compare?
    acperkins
    0
  • Victoria W

    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 W
    0

Add comment

Please sign in to leave a comment.