Options
How To Import Snippets From Prior Versions
EdCarden
Posts: 137 Silver 2
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?
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?
Comments
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
Project Manager, Red Gate