How To Import Snippets From Prior Versions

EdCarden

I have a number of custom Snippets I created and when I installed the Trial of SQL Prompt 5 it installed its own Snippets.

How can I get MY SNIPPETS into SQL Prompt 5 without manually re-entering them all one at a time? In otherwords, how to iport Snippets from prior versions of SQL Prompt?

Paul Stephenson

Hi Ed,

Were your snippets created in SQL Prompt 4? The installation of SQL Prompt 5 should have migrated them across for you, so if that hasn't happened I'd be interested in further details.

Customizations are stored in "%LOCALAPPDATA%\Red Gate\SQL Prompt 4" and "SQL Prompt 5" in the same directory. These are the interesting files:

Snippets (the whole directory)
LoggingConfiguration.xml
RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml
RedGate_SqlPrompt_Engine_EngineOptions.xml
RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml

If your snippets are in the version 4 location, you can copy the files from there to the SQL Prompt 5 location to get them to work.

Please let me know how this goes.

Regards,
Paul