SQL Compare

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

If you have any questions, need help or have found a bug in SQL Compare, please visit the forums at https://forums.red-gate.com/viewforum.php?f=200 or our support portal.

How can we improve SQL Compare?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. New SQL Compare Project on Launch

    I want to change the setting that opens up the most recent project when I launch data compare or compare. Too often I start editing the most recent compare unintentionally. On launch I want a new project open every time. The user should have control over this behavior.

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. SQL Compare to create indexes using WITH (ONLINE = ON)

    When creating indexes on large tables, it would be very beneficial to include the "WITH (ONLINE = ON)" in the create statement for the index to prevent table locking. This will need to be optional because not all server versions support it.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Remove schemabinding

    I think its not removing the 'WITH' when doing remove schema binding for dependent objects

    v 13.7.3.9483

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. SSMS integration - compare single object

    hello, i appreciate that we only need this feature because my company's processes are lacking but what I would love to have is to be able to...

    right-click an object in SSMS and click an option called something like 'compare against other environment'.

    it would then bring up a message box where you could browse an object-explorer for the corresponding object.

    the use cases I see all the time for this are

    1. when people have stored procs next to each other called

    sp_SomeProc
    sp_SomeProc_v2
    sp_SomeProc_new
    sp_SomeProc.old

    etc on the same database.

    2 when you are troubleshooting and you want…

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Generate Html report older version is better, new version has lot of scrolling.

    older version side by side comparison report better than the new version vertical comparison.

    4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. in sql compare, list of items changed should be readable from scp file

    Sql compare produces an scp file which is an xml file. However, the contents of the change is compacted and encoded, and not readable in text editor.
    I wish the list of objects to change can be directly readable from the xml. "Generate comparison results report" is bulky and cumbersome. It would be nice if we have some very short summary in the scp file itself.

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow the scripting of individual sql objects

    optionally have the ability script out all individual objects, rather having one monolithic deployment script, from the source that are unmatched or have diffs on the target. In my case I have a git repo that needs to brought up to date from a production server (a bit of a reverse of the usual workflow)

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow SQLCompare to compare and synchronize Broker Priority objects

    Most of the first-class objects for Service Broker are comparable by SQLCompare (i.e. queues, services, message types, contracts, service bindings, etc). One omission is Broker Priorities. It would be nice to have those at least comparable by the tool with an obvious next step having the ability to synchronize from source to destination

    4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. multi factor

    Support Azure AD auth using MFA

    21 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. No carriage returns when copying TRIGGERS text from SQL View

    When copying text from the SQL View panel, in the resulting clipboard text all carriage returns are missing. A trigger of a few lines of text becomes just one single long line.

    This only happens for texts in the TRIGGERS part, not in the texts of create table, constraints, permissions or functions. There are no visible differences between these texts when looking at the SQL View panel, all texts look normal so this seems like a bug.

    It's quite annoying when you quickly want to fix a small difference, or just want to copy text; you have to step through…

    18 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. With SQL Compare 13 the compare report option to look like previous versions

    Add Compare Report option to have the old format of side by side comparison of changes. This was an easier view of the changes then the +/- lines

    10 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Option to ignore preserving data when adding a NOT NULL column to a table

    SQL Compare tries to preserve data from table when adding a new NOT NULL column and adds below steps to deployment script:
    1. Create a new table B with same structure from original table A
    2. Perform INSERT INTO table B SELECT * FROM Table A
    3. DROP Table A
    4. Rename Table B to Table A

    The issue:
    For example if we add a new column to a ETL table with 1M rows. We don't need data to be preserved since table gets populated during ETL process. The deployment script without manually remove INSERT statement will take a very…

    4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Next/Previous Difference buttons to keep cursor in middle of text

    Currently, when going through differences, the highlighted line can be at the bottom of the window, so subsequent lines cannot be seen. It would be better if the view scrolled around the cursor position so that the current difference was always in the middle of the window.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Connections page

    I cannot connect to my databases on startup. The credentials are the same as I use in other programs and scripts but no dice. Some more meaningful error messages as well as options to specify the port and not clearing down the user/password fields would also be useful.

    4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Report preferences should be stored in the project

    It would be helpful if the definition for SQL Compare reports were stored in the individual projects and not as an application preference. I have 5 different databases and use the report on differences for all 5. I always have to switch the path for the reports. This change would solve that issue.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. SQL Compare - Highlight Date of newer item

    It would be extremely helpful for the compare to highlight the one that is newer. When trying to decide if server 1 or server 2 wins, we need to know which ones were updated more recently on one or the other server.

    Since the date fields are on extreme sides, it's difficult to compare dates.

    Color for the newer one or putting the date columns in the center would be two ways to help with this. Color/bold would be ideal.

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Delete custom filter confirmation

    I would like to see an option when clicking the trash can next to a custom filter rule, it would ask "Are you sure..." (I'll leave the text up to you). Too many times, I have clicked on the trash can instead of the pencil (edit) and poof--all my filters for that object type are gone.

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Fix the installer. Could not install SQL Tool belt trial as Redgate Client service could not be stopped.

    I tried to install the SQL Tool belt trial numerous times but was blocked each time saying the Redgate Client service could not be stopped. I tried to stop it manually but that did not work. I called support but they just sent an email telling me to stop the service. What part of "I can't stop the service" did they not understand?

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Option for 'Ignore Users'

    Can we have an option that allow us to ignore the database users?

    Thanks

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 22 23
  • Don't see your idea?

SQL Compare

Feedback and Knowledge Base