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.

261 results found

  1. Make SQL Compare Three-part identifiers aware and filterable

    Not always a deployed database has the same name of the source database due to customers' naming conventions. So it'd be great if SQL Compare will be three-part identifiers aware, so that if you compare the same table from different named databases as following:

    SELECT *
    FROM MyDatabaseA.MyTable

    SELECT *
    FROM MyDatabaseB.MyTable

    SQL Compare will not show them as different if you want a three-part identifiers insensitive comparison.

    18 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 →
    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

  2. Allow resizing the window from a remote desktop

    When remote using Windows Remote Desktop, the main application window is not resizable. The resize cursor does not show when hovering over the edges or corners, and I cannot click and drag to change the size.

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

  3. Compare (and migrate) Database Diagrams

    I'd love to see a function in SQL Compare to compare and migrate Database Diagrams. Especially between servers, but certainly on the same server.

    We use them all the time to work on the structure of the of our databases and I'd love to be able to see the same diagram when I'm working in Prod and Test as I do in Dev without having to bring the changes across manually.

    The code (for the easy case) is pretty simple.

    UPDATE MyDB.dbo.sysdiagrams
    SET definition = (
    SELECT definition
    from MyOtherDB.dbo.sysdiagrams
    WHERE name = MyDB')
    WHERE name = 'MyDB'

    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 →
    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

  4. ignore constraints

    Option to ignore missing default constraints. Often when comparing two table defs, I want to see if columns or data types have changed but am not concerned at that moment about default constraints. Would like to see an option to ignore missing contraints.

    16 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 →
    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

  5. Avoid creation of Recovery tables

    Please give an option to ignore Recore tables creation. I am trying to use SQLCompare in DevOps model to avoid long release timings. But if there is any data type change to a huge table then current concept of creation of recovery tables is disabling all the FK's, removing indexes and eventually creating a new table. This is very long process and not benefitting the projects. There should be an option to avoid the creation of Recovery tables. Please think in that perspective.

    16 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 →
    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

  6. compare two different commits from GIT

    Add support for comparing two source control commits through the UI.

    Currently this requires cloning a second repository to perform the compare.

    16 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 →
    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

  7. Drop

    Add an option to DO NOT DROP missing fields in the target, this way I'm just adding missing fields from the source.

    16 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 →
    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

  8. New Option to Ignore Statistics_Incremental

    I would love to have the option to ignore the StatisticsIncremental setting on indexes much the way "Ignore StatisticsNoRecompute" works. I currently have two DBs - one has this option on all indexes and one has it on none. Currently SQL Compare flags all indexes as different even with "Ignore Statistics" turned on. The only option is to ignore Indexes entirely which isn't practical because those are the most frequently changing objects between the DBs. I'm currently still using SQL Compare 10 because it does not pick up the Statistics_Incremental option but I would love to be able…

    16 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 →
    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

  9. Igonre create proc / create procedure commands

    I have some stored procedures created in database A with the statement 'create proc' and in databse B with the statement 'create procedure'.
    An option to allow me to ignore this case will very useful.
    Thanks, Ésio

    15 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 →
    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

  10. Synapse Compatibility

    Can the compare engine be enhanced to work with Azure Synapse?

    15 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 →
    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

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

    14 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 →
    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

  12. SSIS package compare

    I would like to suggest that SQL compare tool also have to support SSIS package compare. Currently I am at the position that I have to compare SSIS packages between two servers and find out if any SSIS packages missing plus if any SSIS packages on old version etc. Currently I am talking about SSIS packages reside in MSDB but even if it can be compare between file system, that will be great.

    14 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 →
    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

  13. Ignore Database Name in Stored Procedures, Views, and Functions

    We have 3 environments for one of our core applications. Each environment has a different database name: dbproto, dbuat, and db_live for an example.

    We keep all the SP, Views, and Functions we develop in a separate database so at no time do we alter the database supplied by the vendor. This database name is the same in all three environments.

    Because of the name difference for the vendor database all the SP, Views, and Functions are flagged as different. The only difference for 95%+ of them have is the database name (eg dbproto vs dbuat).

    …

    14 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 →
    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

  14. Similar to other ideas, any project option to ignore should give ability not to display ignored option finds in comparison result

    The project option gives you the ability to ignore based on certain filters e.g. white space. However, if any other difference is found, when you display the comparison it highlights the things you told it to ignore. If in the case of white space, every line shows a highlighted difference for a white space difference, but the one actual difference you are looking for is impossible to find without scanning the whole comparison. Ignore should give you the ability to ignore in the comparison view also (for any ignore project option).

    13 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 →
    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

  15. Colors and screen format need help

    Main window which displays comparison results needs more color so differences standout. Little black boxes to indicate same, differences, left, right are not easy to quickly focus on. Must be a bug with the window sizing. Cannot size comparison results screen which spreads all content out and server/db for source and target at opposite sides of my 24' monitor. Can't size columns either.

    13 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 →
    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

  16. Excluding a user should also exclude their mappings to roles

    Using SQL Compare version 11 for Microsoft SQL Server, I can exclude a user from the schema comparison:

    <exclude>Role:MyCustomUser</exclude>

    This works fine for excluding the user.

    However, the comparison engine does not exclude the user's mapping to roles. The script includes sp_addrolemember commands for the excluded user.

    When excluding a user, I expect their role assignments to also be excluded.

    I suspect this behavior may exist with object exclusions for other object dependencies. Have not tested other scenarios.

    13 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 →
    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

  17. Compare database settings such as snapshot isolation

    Have SQL Compare be able to compare database level settings in sys.databases such as isolation level

    12 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 →
    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

  18. No error should be reported when two databases are identical

    While using command line to generate a difference report (in html format), if the two databases are identical, the console output says:

    Error: The selected objects are identical or no objects have been selected in the comparison. Use /include:Identical to suppress this error.

    If I include the /include:Identical switch, then the error is not reported on the console, but the output html file has all the objects in it.

    I don't want the console error as well as don't want the identical objects in the html file. This is what I want:

    1. Don't want to use the /include:Identical switch
    2. If…
    12 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 →
    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

  19. Let SQL Compare adopt the Comparison Options of Source Control Source

    Unfortunately SQL Compare does not adopt the Comparison Options specified by the Source (here git repository created by SQL Source Control) which are saved in "ComparisonOptions.xml" in the git repository. Instead in SQL Compare I have to click on "Edit project" -> "Options" and check again "Ignore users' permissions and role memberships". This feels somehow not intuitive. During setup of the SQL Compare project a checkbox "adopt comparison options from source" would be nice - or maybe an "adopt" button just after setup.

    I saved the SQL Compare project as an .scp file which in fact is an XML file.…

    12 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 →
    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

  20. In SQL Compare, have "SQL Prompt view tab" with SQL Prompt Professional licence, not just the SQL Toolbelt licence

    We want to use the SQL Prompt view tab in SQL Compare, but you apparently specifically need the SQL Toolbelt or SQL Toolbelt Essential licence.

    We don't have SQL Toolbelt (anymore), but we have both Redgate Deploy and SQL Prompt Professional, and i believe we also have all the tools shipped with SQL Toolbelt.

    Can't this tab also be made available for people using Redgate Deploy and/or SQL Prompt Professional, as we have all the tools/software of the Toolbelt already (i guess), but the bundle is named different...?

    12 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  ·  1 comment  ·  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
1 3 5 … 13 14
  • Don't see your idea?