moving the SQL Prompt Tab History database

Aaron L

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.

AdamWenger

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

FabiolaB

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

AdamWenger

Thanks Fabiola, this did the trick!

AdamWenger

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,

FabiolaB

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

AdamWenger

That was it Fabiola, Thank you.