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

2 comments

Sort by
  • 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

Add comment

Please sign in to leave a comment.