Skip to content

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.

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

14 results found

  1. The generated report doesn't show which database has a difference, e.g. a line of code is in DB 1 but not in DB2. Kind of a major ommissio

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  2. 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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    declined  ·  AdminTim Dalton (Product Manager, Redgate) responded

    In the ‘My Projects’ window there is a checkbox at the bottom left to always show this screen at start up. From here you can select ‘New…’ to launch a new project.

    It’s not quite launching a new project by default, but that is only a single click away.

  3. Manage indexes separately from tables

    When comparing tables, additions/changes in indexes are included as part of the differences to the table. I would like a way to separate index management from table management. In other words, it would be nice to be able to select a table for modification without including the indexes. I know we can do this from a project level with settings, but if there are many tables selected for change, I would like to be able to include the indexes for some tables and not others. Also, it would be nice to be able to select individual indexes on a given…

    192 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…)
    29 comments  ·  Admin →

  4. Version 12 UI Scaling

    Fonts displayed in comparison listing are too tiny, especially on Surface Pro 4. Menu bar also not scaled according to Windows Scaling.

    2 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  ·  Admin →

  5. Color of SQL Compare Icon after 11.5 update

    Please change SQL Compare Icon back to blue; If you use both SQL Compare and SQL Data Compare now after 11.5 update they are red.

    32 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…)
    4 comments  ·  Admin →
    declined  ·  Tugberk responded

    Thanks for providing feedback on this and sorry for the late response here. We currently have no plans to update the icon since we want keep our branding consistent across the products based on our design framework Honeycomb. You can find more information on this at http://honeycomb.red-gate.com/brand/.

  6. sql compare to format both sides

    I would love to have an option to auto-format both sides of the query in SQL Compare to really see the difference between the two regardless of formatting changes

    4 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…)
    0 comments  ·  Admin →

  7. Please do not deprecate /MigrationsFolderXML

    Hi,

    We are using SQL Compare extensively in our company department and one of the features we are enjoying is the ability to generate the scriptsfolderxml and migrationsfolderxml on the fly based on which database we want to deploy.

    In my view deprecating this feature will leave the product in a degerated state. The option is then to use the /migrationsfolder but first I will have to manually sync the migrations folder from source control and then point to it. Sure it is doable but definitely not preferable.

    4 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  ·  Admin →

  8. Too buggy

    The program crashes, hangs up and the scripts created using the Tool donot make the changes as expected. I am reverting back to version 10.7.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    declined  ·  Michelle Taylor responded

    You should have had an email from our Support people who can help you with bug-related problems – I’ve closed this request because it’s not a single specific feature request, and I hope Support can help with the problems you’re experiencing.

  9. Azure SQL Data Warehouse and PDW

    It would be nice to also support PDW databases

    247 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…)
    14 comments  ·  Admin →

  10. Support for Compact Edition (.sdf file)

    A lot of CMS packages use SQL Compact Edition databases, and it would be really useful to be able to compare those.

    11 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…)
    0 comments  ·  Admin →

  11. Views, Tables and Stored Procedures should be scripted in order of dependency

    script creator should be better aware of dependencies such that creating/altering a view or stored proc only occurs AFTER the underlying table has been updated to include the new dependencies. Currently the differences are scripted properly but just not always in order

    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…)
    1 comment  ·  Admin →
    declined  ·  Michelle Taylor responded

    This should be happening already – if you have a specific example of it going wrong, can you send email to support@red-gate.com detailing what’s happening?

    We know there are still a few cases out there where it doesn’t quite go right, but we’re trying to stamp them out where we find them!

  12. Handle triggers as separate objects from table

    229 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…)
    15 comments  ·  Admin →

  13. Mark a difference as a known difference to be ignored in future comparisons

    When I am comparing 2 DBs, there are many differences that I want to ignore - is there a way to mark some differences as known so that they can be excluded from comparison when needed

    69 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…)
    declined  ·  0 comments  ·  Admin →

  14. Migration to multiple databases

    Add ability to create a migration script and deploy to multiple databases with one button click.

    17 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  ·  Admin →
    declined  ·  Justin Caldicott responded

    Hi,

    This can be achieved using our new deployment tool, Deployment Manager:
    http://www.red-gate.com/delivery/deployment-manager/

    It uses the SQL Compare engine under the hood to do deployments of databases.

    We just added the ability to publish databases to Deployment Manager directly from Management Studio:
    http://www.red-gate.com/delivery/deployment-manager/getting-started-with-ssms-addin

    I’d be interested in your feedback on how this tool meets your needs.

    Best wishes,

    Justin

  • Don't see your idea?