| Author |
Message |
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
 Posted: Wed Aug 04, 2010 8:51 pm Post subject: Alias "generator" |
 |
|
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 |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Fri Aug 06, 2010 9:59 am Post subject: |
|
|
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 |
|
|
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
| Posted: Fri Aug 06, 2010 2:34 pm Post subject: |
|
|
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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Fri Aug 06, 2010 2:36 pm Post subject: |
|
|
What is OS version?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com |
|
| Back to top |
|
|
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
| Posted: Fri Aug 06, 2010 2:44 pm Post subject: |
|
|
| Windows XP version 5.1.2600 |
|
| Back to top |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Fri Aug 06, 2010 3:00 pm Post subject: |
|
|
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 |
|
|
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
| Posted: Fri Aug 06, 2010 3:08 pm Post subject: |
|
|
| I have \Application Data\Red Gate folder but the only thing in it is SQL Refactor. |
|
| Back to top |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
|
| Back to top |
|
|
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
| Posted: Fri Aug 06, 2010 3:33 pm Post subject: |
|
|
| 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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Fri Aug 06, 2010 3:42 pm Post subject: |
|
|
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 |
|
|
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
| Posted: Fri Aug 06, 2010 4:04 pm Post subject: |
|
|
| Still don't have a SQL Prompt folder under the Red Gate folder... |
|
| Back to top |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Fri Aug 06, 2010 4:05 pm Post subject: |
|
|
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 |
|
|
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
| Posted: Fri Aug 06, 2010 4:05 pm Post subject: |
|
|
Hold on... It was further down than I thought...
It's under the Local Settings directory... |
|
| Back to top |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Fri Aug 06, 2010 4:06 pm Post subject: |
|
|
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 |
|
|
ktaylor1968
Joined: 04 Aug 2010
Posts: 9
|
| Posted: Fri Aug 06, 2010 4:07 pm Post subject: |
|
|
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 |
|
|
|
