How can we help you today? How can we help you today?

Table Alias Export

Is there a way to export a set of table aliases used in SQL Prompt Pro > Options > Aliases to a configuration file for others to use?
dmckay
0

Comments

2 comments

Sort by
  • Andy C S
    Your table aliases are stored in "<systemroot>:\Users\<yourusername>\AppData\Local\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Engine_EngineOptions.xml" along with a number of other options - you could just copy that XML file across, but that will also duplicate most of the options you've got set up in SQL Prompt.

    If you want, you could just copy across the value for <userdefinedaliases> in the XML, but that's quite fiddly - in short, while you can do it by messing around with config files, there's no easy way to export them automatically from within the tool. Sorry!
    Andy C S
    0
  • dmckay
    Thank you. Very helpful.
    dmckay
    0

Add comment

Please sign in to leave a comment.