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

mbourgon

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?!

DavidHarris

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.

mbourgon

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

bijuj

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

TimF

Hello,

it is not converting all of my snippets - no error is raised. Could you please advise?

Kind regards,

sajjan

That's awesome, worked like a charm!