Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: User interface

Categories

JUMP TO ANOTHER FORUM

(thinking…)

SQL history - Allow user to set custom SqlHistory.db save location

SQL Prompt allows users to set custom directories for various files.

It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.

I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.

The only way to do this now is via REGEDIT.

6 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Thomas Pouliot shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Eric Sabine commented  ·   ·  Report

    I got around this by creating a folder junction to a OneDrive folder. Here's how - in OneDrive's root, I created a folder called appdata_junctions. In there, I copied the entire folder "SQL Prompt 10" from \appdata\local\red gate. Then from an admin cmd prompt, I ran this

    mklink /j "%localappdata%\Red Gate\SQL Prompt 10" "C:\Users\myname\OneDrive\appdata_junctions\SQL Prompt 10"

    Now you have 100% coverage of SQL Prompt in your OneDrive.

  • Richard Green commented  ·   ·  Report

    This is similar to the idea of sharing the tab history files between machines and would do exactly the same thing as you could pointy all machines to the same location (assuming they were not all in use at the same time)