Alias "generator"

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Alias "generator"

Postby ktaylor1968 » Wed Aug 04, 2010 8:51 pm

I just purchased SQL Prompt and would love to set up some aliases for our database tables. We have a 3rd party app that really used some pretty intuitive table and column naming structures.

Our Customer table is named co_customer and all of it's column names begin with cst_. cst_key, cst_id, cst_recno.

Our Invoice table is name ac_invoice and all of it's column names begin with inv_. inv_key, inv_code, inv_trx_date and even an inv_cst_key.

I would love to import a list of 1200 table names and aliases without pressing the "add" button and typing in each one. I can easily query these table name's and prefixes from our database.

Any ideas? I literally downloaded the program today, so I'm very new to it. Looks absolutely great so far. I'm just hoping there's some sort of import for the Aliases.

Thanks all!
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Postby Anu Deshpande » Fri Aug 06, 2010 9:59 am

Many thanks for your post Keith.

I really don't know how you like to achieve this but I will like to share another way of inserting Aliases other than UI which I think can help you or give you an idea how Aliases in SQL Prompt works.

As soon as you define an alias in UI the XML file RedGate_SqlPrompt_Engine_EngineOptions.xml under the node <UserDefinedAliases>.
You can find the file here: %USERPROFILE%\\AppData\\Local\\Red Gate\\SQL Prompt 4\\RedGate_SqlPrompt_Engine_EngineOptions.xml.

This is the only way to add Aliases if you do not want to do it through UI.

Kindly let me know if you need more information on this.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ktaylor1968 » Fri Aug 06, 2010 2:34 pm

I'm having a problem locating that file. I installed the toolbelt on my local machine. I've done searches on every portion of the filename you specified. The only mention I can find of RedGate is in my C:\\Program Files\\Red Gate.

The only thing I did differently from a "default" install was to install each tool in their own directory, through that option on the install utility.
Last edited by ktaylor1968 on Fri Aug 06, 2010 2:42 pm, edited 1 time in total.
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Postby Anu Deshpande » Fri Aug 06, 2010 2:36 pm

What is OS version?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ktaylor1968 » Fri Aug 06, 2010 2:44 pm

Windows XP version 5.1.2600
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Postby Anu Deshpande » Fri Aug 06, 2010 3:00 pm

Can you change your folder settings to show hidden folders and look for

%USERPROFILE%\\Application Data\\Red Gate\\SQL Prompt 4?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ktaylor1968 » Fri Aug 06, 2010 3:08 pm

I have \\Application Data\\Red Gate folder but the only thing in it is SQL Refactor.
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Postby Anu Deshpande » Fri Aug 06, 2010 3:11 pm

Can you confirm you have SQL Prompt 4 installed?

Check in your Add/Remove Program for SQL Prompt 4 and if not install it from here:

http://www.red-gate.com/MessageBoard/vi ... hp?t=10248
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ktaylor1968 » Fri Aug 06, 2010 3:33 pm

I've been using it... I had not done the Activiation key yet, so I just finished with that and rebooted my system. It's still not out there. Should I do the uninstall/reinstall? Thanks for your help on this!
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Postby Anu Deshpande » Fri Aug 06, 2010 3:42 pm

No problem!

Can you kindly uninstall the existing SQL Prompt and install the latest version?

Link is enclosed in previous post.

Kindly let me know this helps or not.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ktaylor1968 » Fri Aug 06, 2010 4:04 pm

Still don't have a SQL Prompt folder under the Red Gate folder...
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Postby Anu Deshpande » Fri Aug 06, 2010 4:05 pm

Can we have a remote session?

I will email you the steps you need to follow to initiate live chat with me.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ktaylor1968 » Fri Aug 06, 2010 4:05 pm

Hold on... It was further down than I thought...

It's under the Local Settings directory...
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Postby Anu Deshpande » Fri Aug 06, 2010 4:06 pm

Oops!! good you found it :)

Does it have the XML file I asked to look into?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ktaylor1968 » Fri Aug 06, 2010 4:07 pm

Yeah, there's a "Application Data" under my username and then there's a "Local Settings" with another "Application Data" under there.

Sorry about that... It does have that XML file!

I really appreciate your time!


Thanks!
ktaylor1968
 
Posts: 9
Joined: Wed Aug 04, 2010 8:42 pm

Next

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests