Export or edit tab history
rsiem
Posts: 3 Bronze 1
in SQL Prompt
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 ?
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 ?
Tagged:
Answers
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
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center