Skip to content

SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums or our support portal.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

10 results found

  1. SQL History sorts files by modified date ASCENDING. Its needs to be DATE DESCENDING. Need options to sort by name or date, ASC or DESC. Like how TAB HISTORY used to.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. SQL history. Recently this has become more indepth with greater search and history detail available. However it has lost some features which I found to be invaluable and which now make SQL history less useful to me.

    Find Starred items doesn't work as well now. It uses the advanced search which does not actually show if items are starred. Please correct that.

    Also there is now no ability to sort items found (in either normal or search view) by name / date etc.

    Can these features be re-implemented please.

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 'History for SQL Queryxxx' pane - there are too many versions. I don't need a version for every minor change. How about adding an option for how often to save versions?

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Over the years my Tab/Sql History became huge, and it is working very slow. I am looking for a way to clean up.
    1. There is no way to select multiple lines to delete. Delete is available only for one row. For example, every ALTER PROCEDURE creates history. I don’t need it at all. I would like to find all of them and delete.
    2. There is no functionality to compress and reindex Sql History database.
    3. Ironically “Send Feedback” link on a bottom of screen leads to nowhere.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Bring back TAB History!!! In the meantime, in SQL History, show the query/tab on the preview right side pane while hovering over the query on the left side.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. At the moment to purge old tabs you need to open the tab history window and scroll to a certain point and right click and choose "Remove tabs older than this"

    This can be a bit tricky so instead could we have a button (perhaps in options?) that will prompt you for a date and purge items last closed before that date.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Add the ability to define groups of tabs that are used regularly for different jobs. For instance--there is a group of scripts I use for month end processing and a completely different set of scripts I typically have open for daily processing. Monthly statement preparation and troubleshooting comprise another set of scripts. I'd like to be able to name groups of tabs and retrieve them based on that named grouping, while still being able to go back to what I was doing before the "interruption" that caused me to need a different set of tabs open.

    39 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Enhance Smart Rename to accept a list of name changes.

    Even if it runs the existing smart rename and concatenates the scripts it would save a lot of data entry time versus doing each change one at a time.

    You should require fully qualified names in the import data to avoid ambiguity errors.

    58 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’re going to be reviewing this over the next couple of months, which would be released via the SQL Prompt for Teams EAP (get in touch if you want to know more).

    In the meantime please add any other information that you think would be useful.

  9. If I am running an "ALTER" or "CREATE" or "DROP", etc. Have SQL Prompt automatically refresh suggestions after my call.

    17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. I think having an API to format generated SQL scripts, whether it be from the SQL Compare API or another process like SMO objects, to able to apply the formats saved in SQL Prompt.

    34 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    It would be great if you could let us know more about how you’d use a Prompt API / command line version of Prompt.

    What problems are you having without it?
    How are you getting around those?
    How would this make your work better?

  • Don't see your idea?