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

Move SQL Tab History to a new computer

I am getting my computer refreshed at work. Is there a way for me to move all of the history from SQL TAB History to a new computer?
brownrobm
0

Comments

6 comments

Sort by
  • Aaron L
    Hi,

    All of tab history is kept in a database file located at: 
    %localappdata%Red GateSQL Prompt 7SavedTabs.db
    Copying across that file to the same directory on the new PC should move all of your saved tabs across.

    Thanks,
    Aaron.
    Aaron L
    0
  • brownrobm
    That worked, Thanks!
    brownrobm
    0
  • james.elmer
    Thanks for this answer! Helps when moving to a new machine!
    james.elmer
    0
  • CarlosB
    Can that SavedTabs.db be placed somewhere else?
    CarlosB
    0
  • bermudaLamb
    Is there an update for this? I'm working with SQL Prompt 10 and SMSS v19.3, and tried this out. However, none of my existing sql history is showing up when I open the SQL History window.
    bermudaLamb
    0
  • Victoria W
    Hi bermudaLamb

    Please can you try the following:
    1. Close down SSMS, browse to %localappdata%\Red Gate\SQL Prompt 10\ and rename the file "SqlHistory.db" to something like "SqlHistoryOLD.db" and then relaunch SSMS
    2. Update SQL Prompt to the latest version (If not already): https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.8.6563.exe
    After this, try and run some queries, close SSMS, reopen it again and then check to see if it has saved the queries.
    Victoria W
    0

Add comment

Please sign in to leave a comment.