How To Import Snippets From Prior Versions

EdCardenEdCarden Posts: 138 Silver 2
edited February 8, 2011 8:55AM in SQL Prompt Previous Versions
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?

Comments

  • 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
    Paul Stephenson
    Project Manager, Red Gate
Sign In or Register to comment.