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

Export or edit tab history

I have a build up of SQL Prompt (Version 10.8.4.24201)  tab history where the SavedTabs.db  is about 134 megs in size. In addition I have lots of SQLQuery1.sql and SQLQueryxx.sql entries

While I can scroll up/down thru all the entries it is time consuming. Is there a method to export the entire tab history with the dates/times and sql code to a text or csv file so I can review which entries I need to rename or keep and which I can delete thru the SQL Prompt GUI ?
rsiem
0

Comments

2 comments

Sort by
  • Kurt_M
    Hi @rsiem,

    Unfortunately, there is no way to export to an excel or CSV file, but there is a database located in the following directory that you could backup. This could be copied to another machine for example, but reviewing it would still remain in the SQL Prompt GUI.

    %localappdata%\Red Gate\SQL Prompt 10\SavedTabs.db
    Kurt_M
    0
  • gwalkeyPF
    can the Tab History DB be pruned at all? thanks
    gwalkeyPF
    0

Add comment

Please sign in to leave a comment.