Options

moving the SQL Prompt Tab History database

Aaron LAaron L Posts: 596 New member
edited September 27, 2013 4:12AM in SQL Prompt
I’ve added an option to the tab history xml file in 6.1.0.71, you can set the location of the database file by editing the file:
%localappdata%\Red Gate\SQL Prompt 6\RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml
And setting the DatabaseFilePath variable eg. <DatabaseFilePath>D:\tabhistory\savedtabs.db</DatabaseFilePath>

A network path isn’t officially supported but if it's mapped it to a drive and it’s fast/reliable it should work.
Tagged:
· Share on Twitter

Comments

  • Options
    AdamWengerAdamWenger Posts: 4 New member
    Good afternoon,

    Will this work the same for SQL Prompt 9? I'd like to get my tab history folder moved in the current version as well.

    Thank you,
    ~Adam
    · Share on Twitter
  • Options
    FabiolaBFabiolaB Posts: 54 Silver 3
    Hi @AdamWenger,

    I've done the test, and it works the same as in v6, so you should be able to do that.

    Also, a network path isn't officially supported but if it's mapped it to a drive and it's fast/reliable it should work.

    Regards,
    Fabiola
    · Share on Twitter
  • Options
    AdamWengerAdamWenger Posts: 4 New member
    Thanks Fabiola, this did the trick!
    · Share on Twitter
  • Options
    AdamWengerAdamWenger Posts: 4 New member
    Thanks FabiolaB,
    I Added the node as you mentioned to <%localappdata%\Red Gate\SQL Prompt 9\RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml>, then restarted SSMS 17.4, but it didn't work, it still appears to be using the original location. My file looks like this:

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <!---->
    <TabMagicOptions version="1" type="TabMagicOptions">
    <Enabled>True</Enabled>
    <OpenTabsOnStartup>True</OpenTabsOnStartup>
    <ReconnectTabs>True</ReconnectTabs>
    <UseKeyboardShortcut>True</UseKeyboardShortcut>
    <RecentlyClosedTabsWidth>1104</RecentlyClosedTabsWidth>
    <RecentlyClosedTabsHeight>974</RecentlyClosedTabsHeight>
    <GridSplitterLeftWidth>280</GridSplitterLeftWidth>
    <LastRunWasLicensed>True</LastRunWasLicensed>
    <SelectedFilterType>0</SelectedFilterType>
    <SelectedFilterTypeForKeyboardShortcut>0</SelectedFilterTypeForKeyboardShortcut>
    <KeyboardShortcut>Ctrl+Q</KeyboardShortcut>
    <DatabaseFilePath />
    <MaximumQuerySize>2147483647</MaximumQuerySize>
    <MaximumNumberOfTabsToRestore>100</MaximumNumberOfTabsToRestore>
    <MaximumNumberOfConnectionsToRestorePerTab>1</MaximumNumberOfConnectionsToRestorePerTab>
    <ShownRedGateToolbar>True</ShownRedGateToolbar>
    <DatabaseFilePath>C:\MyPath\Redgate\savedtabs.db</DatabaseFilePath>
    </TabMagicOptions>

    Thanks,
    · Share on Twitter
  • Options
    FabiolaBFabiolaB Posts: 54 Silver 3
    Hi @AdamWenger,

    I haven't tried it with your file, but, I think you have 2 
    DatabaseFilePath
    tags inside:
    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<TabMagicOptions version="1" type="TabMagicOptions">
<Enabled>True</Enabled>
<OpenTabsOnStartup>True</OpenTabsOnStartup>
<ReconnectTabs>True</ReconnectTabs>
<UseKeyboardShortcut>True</UseKeyboardShortcut>
<RecentlyClosedTabsWidth>1104</RecentlyClosedTabsWidth>
<RecentlyClosedTabsHeight>974</RecentlyClosedTabsHeight>
<GridSplitterLeftWidth>280</GridSplitterLeftWidth>
<LastRunWasLicensed>True</LastRunWasLicensed>
<SelectedFilterType>0</SelectedFilterType>
<SelectedFilterTypeForKeyboardShortcut>0</SelectedFilterTypeForKeyboardShortcut>
<KeyboardShortcut>Ctrl+Q</KeyboardShortcut>
[b]<DatabaseFilePath />[/b]
<MaximumQuerySize>2147483647</MaximumQuerySize>
<MaximumNumberOfTabsToRestore>100</MaximumNumberOfTabsToRestore>
<MaximumNumberOfConnectionsToRestorePerTab>1</MaximumNumberOfConnectionsToRestorePerTab>
<ShownRedGateToolbar>True</ShownRedGateToolbar>
[b]<DatabaseFilePath>C:\MyPath\Redgate\savedtabs.db</DatabaseFilePath>[/b]
</TabMagicOptions>

    Can you try to :
    - Close SSMS
    - Edit the file
    - Remove <DatabaseFilePath /> (the first in your file). Save the file.
    - Open SSMS

    Please let me know if it works,
    Regards,
    Fabiola
    · Share on Twitter
  • Options
    AdamWengerAdamWenger Posts: 4 New member
    That was it Fabiola, Thank you.
    · Share on Twitter
Sign In or Register to comment.