Migrate SQL History records to new computer

eagle

I received a new computer and need to migrate the SQL History records over to my new computer.  How can I accomplish this?

I did try copying the files at [%AppData\Local\Red Gate\SQL Prompt 10\SqlHistoryIndex], but the records aren't showing up on the new computer.  Is there a way to maintain access to this data?

Old computer records


New computer records


Appreciate any insights on how I can access these records!

chrisqtran

Hi there,

Thank you for reaching out.

Can you try copying the whole folder from your old computer to your new one? The folder you need to copy is:

C:\Users\<username>\AppData\Local\Red Gate\SQL Prompt 10

eagle

Yes, that worked, thank you.


For anyone else reading this in the future, deleting the new computer SQL Prompt folder then dropping in the old computer SQL Prompt folder doesn't seem to have any adverse consequences, rather pulls over all SQL Prompt settings (including Preferences and Code Snippets, etc) in the process. 
Yes, now that I say it, that seems obvious, but I at least was a little hesitant to go all in with it initially.