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

• 
  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.
  
  Regards,
  David Harris.
  

  DavidHarris March 24, 2021 03:09

  - 0 +
• 
  THANK YOU!  In this case, it was a combination of a machine rebuild and having to run SSMS under different credentials.  MUCH appreciated!
  

  mbourgon March 24, 2021 14:46

  - 0 +
• 
  Didn't work for me!   It worked I just copied it to the wrong folder.

  bijuj March 30, 2021 14:38

  - 0 +
• 
  Hello,
  
  it is not converting all of my snippets - no error is raised. Could you please advise?
  
  Kind regards,
  
  

  TimF April 27, 2021 15:42

  - 0 +
• 
  That's awesome, worked like a charm!

  sajjan February 16, 2023 13:53

  - 0 +

Add comment

Please sign in to leave a comment.