Skip to content
← Customer Feedback for Redgate

Settings and activity

31 results found

  1. Copy a row selection and format into a into a 2 column output (column, value)

    3 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

    3 comments  ·  SQL Prompt  ·  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
    ben b supported this idea  · 
    An error occurred while saving the comment
    ben b commented  · 

    I agree...

    often, when exploring databases I do the following

    #1: SELECT 1 * FROM [wide table]

    #2: sql prompt-> export to excel

    #3: copy the data in Excel and paste-transpose

    #4: add column names to the excel table (column_name, example_value)

    I do this fairly often and its quite tedious/slow

  2. Multiple server search

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Search » Data search  ·  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
    An error occurred while saving the comment
    ben b commented  · 

    this

    https://forum.red-gate.com/discussion/89801/search-across-multiple-servers#latest

    plus the ability to put "descriptions" against servers and databases would be epic.

    We have 4.5K databases and people spend hours trying to hunt down servers and DBs.

    ben b supported this idea  · 

  3. Change branches from SSMS.

    207 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    under review  ·  21 comments  ·  SQL Source Control  ·  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
    An error occurred while saving the comment
    ben b commented  · 

    Yep - this one is so key. You have it for git in SCA so would love to see it in SQL Source Control within SSMS.

    ben b supported this idea  · 

  4. Custom Formatting

    131 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  SQL Source Control » Initial Setup  ·  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
    An error occurred while saving the comment
    ben b commented  · 

    yep, really good idea

    ben b supported this idea  · 

  5. simple tabs (brent ozar)

    4 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

    0 comments  ·  SQL Prompt » User interface  ·  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
    ben b shared this idea  · 

  6. syntax highlight double quoted column aliases

    1 vote

    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

    0 comments  ·  SQL Prompt  ·  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
    ben b shared this idea  · 

  7. Optional column alias when expanding wildcards

    8 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

    0 comments  ·  SQL Prompt » Expand wildcards  ·  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
    ben b supported this idea  · 

  8. column alias by column name

    8 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

    0 comments  ·  SQL Prompt » Format SQL  ·  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
    ben b supported this idea  · 

  9. materialise temp table (from SELECT INTO)

    2 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

    0 comments  ·  SQL Prompt  ·  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
    ben b shared this idea  · 

  10. Highlight a SELECT stmt and create a temp table definition from it.

    31 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

    5 comments  ·  SQL Prompt » Script object as alter  ·  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
    ben b supported this idea  · 

  11. Automatically add DROP TABLE IF EXISTS for #temp tables

    11 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

    1 comment  ·  SQL Prompt » Format SQL  ·  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
    ben b supported this idea  · 

  12. Summarize Script by Comments

    10 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

    3 comments  ·  SQL Prompt » Summarize script  ·  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
    ben b supported this idea  · 

  13. Allow git clones from the SQL Source Control UI

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control » Initial Setup  ·  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
    ben b shared this idea  · 

  14. Create new Setting to only enclose SQL Keywords in square brackets

    54 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

    2 comments  ·  SQL Prompt » Format SQL  ·  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
    An error occurred while saving the comment
    ben b commented  · 

    this would be a really useful one please.

    we've got SonarQube doing code smells atm and it picks up situations where this happens which is a bit annoying... would be great if SQL prompt just did it for me please!

    ben b supported this idea  · 

  15. Compare the contents of two tabs as text

    49 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

    3 comments  ·  SQL Prompt  ·  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
    ben b supported this idea  · 

  16. SSMS integration - compare single object

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Compare  ·  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
    An error occurred while saving the comment
    ben b commented  · 

    Hello - this was raised and discussed in this forum post. I would personally love this feature.

    https://forum.red-gate.com/discussion/85780/quickly-compare-two-objects#latest

    ben b shared this idea  · 

  17. Generate a meaningful filename when clicking 'Save' in SSMS

    3 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

    0 comments  ·  SQL Prompt  ·  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
    ben b shared this idea  · 

  18. Compare on object

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Compare  ·  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
    ben b supported this idea  · 

  19. Create an option to use MERGE INTO versus insert, update, delete

    37 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Data Compare  ·  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
    An error occurred while saving the comment
    ben b commented  · 

    this is an interesting one.

    I'm having to write loads of merge statements for static data in a small application. they are going to be included as post-deployment scripts in a visual studio database project.

    I'm using the method below

    https://blogs.msdn.microsoft.com/ssdt/2012/02/02/including-data-in-a-sql-server-database-project/

    I was thinking if you could generate the MERGE using the key columns selected in Data Compare to join the source and target - and then compare all the other columns for differences?

    ben b supported this idea  · 

  20. Highlight Implicit Conversions due to Data Type mismatch

    74 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

    5 comments  ·  SQL Prompt » Code Analysis  ·  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
    ben b supported this idea  · 
← Previous 1