On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

Synapse Serverless SQL Support

Hi,

Anyone know if SQL Prompt can crawl and register Serverless SQL Databases?  It seems like it can't but I can't find any documentation anywhere suggesting one way or another.
Tagged:

Answers

  • Jon_KirkwoodJon_Kirkwood Brisbane, Australia Posts: 25 Bronze 1

    Hi and Thanks for reaching out on the Redgate forums.

    Regarding your query around Azure Synapse Serverless db's. 

    Yes, it should certainly be possible to connect to these instances and have SQL Prompt register them to provide functionality. 

    To test this; I connected to my Azure instance and spun up a new sample DB on a serverless compute instance and connected it to my local SMSS instance to access SQL Prompt functionality.



    Have you tried connecting to an instance and are experiencing any issues in getting our tools to work? 

    If so please provide some further details so we can assist further

    Jon Kirkwood | Technical Support Engineer | Redgate Software
Sign In or Register to comment.