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

Transferring SQL History not working correctly

I have attempted to transfer the SQL History from SQL Prompt 10 on one machine to another running SQL Prompt 11. I have closed both instances and replaced the destination file with SqlHistory.db under AppData>Local.

When I open SSMS on the new machine. The history appears to have results, but when I search for something which I know returns tons of results on the old machine, the same search doesn't return anything on the new machine.

rvernals
0

Comments

4 comments

  • Ben Patel

    Hi rvernals on the machine where you transferred the the SQL History to, can you navigate to %localappdata%\Red Gate\SQL Prompt 11\SqlHistoryIndex and delete the contents of that folder. Then open SSMS and try searching SQL History again. Are the expected results now found? 

    Ben Patel
    0
  • rvernals

    Hi Ben, I did this and now it works, thank you so much!

    rvernals
    0
  • Jon

    Is there a way to combine two SQLHistory.db files?

    Jon
    0
  • Blockblast1

    I’ve run into similar issues when trying to transfer SQL history between machines — sometimes the problem comes from version mismatches or missing config files rather than the history itself. Double-check whether your SQL client stores history in a local file (like .sqlhistory) or in its own settings directory. Copying just the file often isn’t enough if there are permission differences. I found a helpful breakdown of troubleshooting steps on this site: https://www.blockblastmod.com/ — might be worth a look if you’re still stuck.

    Blockblast1
    0

Add comment

Please sign in to leave a comment.