moving the SQL Prompt Tab History database

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.
%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:
Comments
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
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
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,
I haven't tried it with your file, but, I think you have 2 tags inside:
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