What are the challenges you face when working across database platforms? Take the survey

convert old-style SQL Prompt snippets (the XML version) to the new JSON format?

I don't seem to find anything.  I have a couple dozen snippets that obviously won't work in the new style, and I don't see a way to migrate them.  Help?!

Best Answer

  • Options
    DavidHarrisDavidHarris Posts: 11 Bronze 1
    Hi Michael,

    Thank you for your forum post. 

    When upgrading SQL Prompt to a version above 10.5, both the Snippets and Styles will be converted to JSON format automatically.  For Snippets, if they are located under the 
    %localappdata%\Red Gate\SQL Prompt 10\Snippets folder (or the custom folder you specified), then once you start MS SMS or Visual Studio, they will be converted into JSON format.  If you have already upgraded the SQL Prompt version, but not the Snippets, you can copy the existing snippet files (*.sqlpromptsnippet) into the above Snippets folder.  Once you start MSSMS or Visual Studio again, they will be converted to the new format.  

    Please let me know if this provides a solution for you, or if we can look into the issue further.

    David Harris.
    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?


Sign In or Register to comment.