Move SQL Tab History to a new computer

brownrobm

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?

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.

brownrobm

That worked, Thanks!

james.elmer@live.com

Thanks for this answer! Helps when moving to a new machine!

CarlosB

Can that SavedTabs.db be placed somewhere else?

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.

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.