Red Gate forums :: View topic - Alias "generator"
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

Alias "generator"

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Go to page 1, 2  Next
Author Message
ktaylor1968



Joined: 04 Aug 2010
Posts: 9

PostPosted: Wed Aug 04, 2010 8:51 pm    Post subject: Alias "generator" Reply with quote

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



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 06, 2010 9:59 am    Post subject: Reply with quote

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



Joined: 04 Aug 2010
Posts: 9

PostPosted: Fri Aug 06, 2010 2:34 pm    Post subject: Reply with quote

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



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 06, 2010 2:36 pm    Post subject: Reply with quote

What is OS version?
_________________
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
ktaylor1968



Joined: 04 Aug 2010
Posts: 9

PostPosted: Fri Aug 06, 2010 2:44 pm    Post subject: Reply with quote

Windows XP version 5.1.2600
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 06, 2010 3:00 pm    Post subject: Reply with quote

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



Joined: 04 Aug 2010
Posts: 9

PostPosted: Fri Aug 06, 2010 3:08 pm    Post subject: Reply with quote

I have \Application Data\Red Gate folder but the only thing in it is SQL Refactor.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 06, 2010 3:11 pm    Post subject: Reply with quote

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/viewtopic.php?t=10248
_________________
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
ktaylor1968



Joined: 04 Aug 2010
Posts: 9

PostPosted: Fri Aug 06, 2010 3:33 pm    Post subject: Reply with quote

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



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 06, 2010 3:42 pm    Post subject: Reply with quote

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



Joined: 04 Aug 2010
Posts: 9

PostPosted: Fri Aug 06, 2010 4:04 pm    Post subject: Reply with quote

Still don't have a SQL Prompt folder under the Red Gate folder...
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 06, 2010 4:05 pm    Post subject: Reply with quote

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



Joined: 04 Aug 2010
Posts: 9

PostPosted: Fri Aug 06, 2010 4:05 pm    Post subject: Reply with quote

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

It's under the Local Settings directory...
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 06, 2010 4:06 pm    Post subject: Reply with quote

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



Joined: 04 Aug 2010
Posts: 9

PostPosted: Fri Aug 06, 2010 4:07 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page 1, 2  Next
Page 1 of 2

 
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