Skip to content

SQL Compare

That idea has been deleted

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.

262 results found

  1. Allow Connections to Microsoft Fabric SQL Databases

    I would love to be able to use the tools I know and love to access Microsoft Fabric SQL Databases.

    Currently when connecting to Fabric SQL Databases the following error is displayed: "Fabric is not currently supported."

    I ask that Fabric be supported by all products in the SQL Toolbelt, but specifically, SQL Prompt, SQL Compare and SQL Data Compare.

    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 →
    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. Release the Ability to Buy the Professional Version?

    I was about to release my project and purchased SQL Compare, only to discover that it is no longer the Professional version I expected. I couldn’t find any way to acquire the Pro license, which cost me valuable production time and caused me to miss my release window.

    In desperation, I even tried installing legacy versions where I already had Pro licenses, but that only highlighted how frustrating and broken this experience feels.

    If Redgate no longer wants to sell its Professional product, why confuse existing customers by quietly removing it? Why push us into a downgraded version without making…

    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 →
    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. auto-map identical schema

    auto-mapping tables that have identical schema but different names

    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 →
    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. Include *.snp filenames in SQL Compare reports

    The DatabaseName/ServerName included in some SQL Compare report headers is completely worthless.

    A value-added proposition would be to include the actual *.snp names in the header.

    This is Red Gate SQL Compare *.html code:

    var datasource1type = "snapshot";var datasource1server = "thisinfoisIDENTICALandworthless";var datasource1database = "IT";var datasource2type = "snapshot";var datasource2server = "thisinfoisIDENTICALandworthless";var datasource2database = "IT";

    This does not appear to be rocket surgery...

    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 →
    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. Allow comparison of system stored procedures in master database

    We have a handful of system stored procedures in the master database that SQL Compare effectively ignores when doing comparisons. Since all MS system stored procedures are in the 'sys' schema, allow for comparison of system SPs that are not in the 'sys' schema. Seems pretty simple and very useful.

    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 →
    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. case insensitive built-in keywords and function names

    We need an option to ignore the difference when the same keywords or built-in functions have different cases, since those differences do not matter even for binary collation databases.
    Example of irrelevant differences is attached

    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 →
    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. Tag updated function

    Quite simple really... on the "Actions" menu include a new option: "Include updated". This would select every change that is newer on the source that is either not present or older on the destination.

    This would save a lot of time picking through things where there are a lot of changes, especially with multiple developers working on the same database.

    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 →
    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. Allow Ignore for OPTIMIZE FOR clauses

    In single-tenant database environments with multiple databases sharing similar schemas, OPTIMIZE FOR clauses can be used to prevent query plan regressions. However, database object comparison tools should include an option to ignore these clauses, since optimisation parameters that work for one database may not be suitable for other single-tenant databases.

    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 →
    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. Do not start a trial in applications with existing licenses

    I tried the "SQL Data Compare". It also upgraded my existing LICENSED "sql compare standard" to the "sql compare pro" trial edition. Now SQL compare is nagging me with timers and buy options. Very annoying

    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 →
    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. Select specific changes within an object

    Allow the selection of what changes you want instead of updating the whole object. For example, a table may have column changes that you don't want to promote but indexes that you do want to promote.

    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…)
    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

  11. Remote Git repository as the source of a comparison

    Allow SQL Compare to use a remote Git repository as the source of a comparison.

    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 →
    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. debug logging

    I've recently hit a problem when using SQL Compare (which was logged as request #322451).

    I am reasonably sure the issue is with the database, not the tool, but when using debug logging, there's just not enough information to understand why it gets stuck on "reading object text (99%)" for over 20 minutes for a specific database, yet is very fast on other similarly sized databases.

    Some additional logging during the comparison phase might help to work out why this is happening.

    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 →
    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. Use the SQL Prompt setting when generating a new compare

    When I generate the HTML report that it defaults back to the old view. Then simple formatting differences is shown, which were not part of the interactive view when using the SQL Prompt setting.

    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 →
    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. Suppress Ignored Statement Warning

    When using SQL Change Automation command line, it would be helpful to suppress warnings for ignored statements. Since these scripts are checked into source control, these warnings will get long over time with addition of more scripts.

    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 →
    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. Add default collation to match source database when you create a new target database in SQL Compare

    When I schema compare in order to copy a database, I often want to create a new database as target. Could it be possible to default the collation of the new database to the one of the already selected source? Or at least make it possible to see the collation of the source database right there in the tool? There are hundreds of collations to choose from, and mostly I get it wrong and then I have to await the compare process and go back and delete the new database and do it all over. Seems like an easy fix.…

    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 →
    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. Read from SQL Native Compressed Backups

    Similar to the idea from Steve Hall for SQL Data Compare, SQL Compare should also get the ability to read backups compress by SQL Server.
    There is a feature for compressed backups, but unfortunately "this compression is not supported" if you try to read from a BAK with the standard compression of MSSQL.
    That would be very important to make partial restores and to have an efficient way to deal with the day-to-day tasks, because bih DBs cannot be handled without compression.

    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…)
    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. Add support for SQL Server Management Studio 20.

    If I open up Tools --> Application Options in SQL Compare, I see SQL Server Management Studio 19, but not 20 which has been out for months now. And I believe it is the same in SQL Data Compare as well.

    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 →
    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. Highlight newer last modified date.

    Highlight newer last modified date.

    In SQL Compare, highlight somehow the Last Modified date that is newer/more recent especially in the "in both, but different" category of SQL object comparisons.

    Thinking it would help pick the appropriate object that was worked on most recently.

    8 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. Allow me to exclude users in DB compares.

    I use something like domain\UserDEV for development and domain\UserPRD for production.

    I can ignore a users permissions but I don't need a list of users that I know won't exist in different environments.

    This confuses business users when I try to show/demonstrate the exported report.

    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 →
    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. SQL Data Compare\SQL Compare between SQL database tables and Azure Synapse Serverless database external tables

    It would be great if SQL Data Compare/SQL Compare work with External Tables in Azure Synapse Serverless database.

    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 →
    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
← Previous 1 3 4 5 … 13 14
  • Don't see your idea?