Red Gate forums :: View topic - User-Deinffed Aliases & Snippets - Where are they
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

User-Deinffed Aliases & Snippets - Where are they

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Mon Aug 02, 2010 11:03 pm    Post subject: User-Deinffed Aliases & Snippets - Where are they Reply with quote

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.
Back to top
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Mon Aug 02, 2010 11:45 pm    Post subject: I figured it out thanks to Sysinternals Process Viewer Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 689
Location: Cambridge

PostPosted: Wed Aug 04, 2010 10:23 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Wed Oct 27, 2010 9:35 pm    Post subject: Re: User-Deinffed Aliases & Snippets - Where are they Reply with quote

Anu Deshpande wrote:
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.


Anu, If I wanted to suggest as a new feature in a future version the ability to more easily edit the info in this file how would I go about doing so? I imagine I'm not teh first person who wished to Bulk Load User-Defined Aliases and the like in SQL Prompt.

Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group