Copy SQL History to New Machine

alphonseg

Using SQL Prompt 10.14.0.4046

I've copied C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10\SqlHistory.db to a new machine.

When I open SQL History, The 'Recent Queries' pane lists everything expected.

However, when I use Search, it only returns results that originated on the new machine.

What am I missing? Is there another file I need? How do I search all history?

Ben_P

Hi @alphonseg thank you for your post. 

In that same folder in the original machine (where you were moving the SQL History file over from) there should also be a JSON file named "sqlhistory-search" if you move that over to the other machine are you then able to search through the SQL Histroy? 

alphonseg

Thanks. That worked, although I don't understand why since the content of both files look identical.