User-Deinffed Aliases & Snippets - Where are they

[EdCarden]

ANyone know where exactly SQL Prompt stores the User-Defined Aliases and code Snippets that you can specify via the AUto Insert & Snippets Tabs in SQL Prompts OPTIONS dialog?

I neeed to setup over a thousand of the User-Defined Aliases and I'll be darned if I'm going to do it one at a time thru the interface. There's no bulk load feature in SQL Prompt that I can to setup a large number of these. I know they got to be stored somewhwere in the regiostry or some file, I just need to find where and maybe I can edit the thing directly.

This seems like it should be a no brainer ability in SQL Prompt but its not and I can't determine where its storing these things.

[EdCarden]

FYI - SQL Prompt stores User-Deifned aliases along with a few other custmizations in the xml file EngineOptions.xml which can be found (On a Windows Vista computer) at

C:\Users\John.Smith\AppData\Local\Red Gate\SQL Prompt 3

Where the 'John.Smith' is your name/Login Name.

In it is a section labled UserDefinedAliases that has 4 lines of info for each defined User-Defined Alias. I am going to test editing this with just a few items and if it works then I will use a query (in T-SQL) that pulls Table Names and aliases from a table we have setup to store this. Using concactenated string combined with CHAR(10) (for CrLf) and output to Text will produce a complete section of UserDefinedAlias items.

This section ahs at the very start a line that lists the total number of UDFs listed and so it will need to be updated to account for the new items

Hopefully this will work and save me literally hours of time.

[Anu Deshpande]

Thanks for your post and suggestion ED.

Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

[EdCarden]