moving the SQL Prompt Tab History database

• 
  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

  AdamWenger December 12, 2017 22:34

  - 0 +
• 
  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

  FabiolaB December 13, 2017 09:27

  - 0 +
• 
  Thanks Fabiola, this did the trick!

  AdamWenger December 13, 2017 21:35

  - 0 +
• 
  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,

  AdamWenger January 09, 2018 11:28

  - 0 +
• 
  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

  FabiolaB January 12, 2018 12:50

  - 0 +
• 
  That was it Fabiola, Thank you.

  AdamWenger January 26, 2018 16:33

  - 0 +

Add comment

Please sign in to leave a comment.