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

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.

270 results found

  1. user defined type

    I recently had to use SQL Compare to create a rather large add new and update deployment script.
    I was pleased that it picked up User Defined Types in addition to the normal tables and stored procedures.
    But it did not pick up the permissions for the User Defined Types, and that was a failure point when executing the stored procedures.
    This was my first time working with User Defined Types before, and I thought it odd they needed permissions at all. I did not apply any in the development environment, and they worked there.
    But the error was clearly…

    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

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

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

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

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

  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. For Deploy offer option to copy to clipboard

    In SQL Compare when you choose to Deploy changes and then wish to Create a deployment script it wants you to open it up in a SQL editor. Because I am using newer versions of SSMS or I am running it on a different deployment server from my local machine it would be helpful to just be able to copy it to the clipboard so it can then be run manually..

    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

  8. SQL Compare on SSMS Keep closing

    I have installed SQL Compare tool with other options. This has added some Redgate features on my SSMS. When I click on procedures and right click to filter SSMS keep closing automatically and then I have to open SSMS again. This was not happening before I installed red gate SQL compare tool.

    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

  9. SQL Compare - Importing Object Selection from Excel or External File

    Hello Redgate Team,

    I would like to suggest a feature enhancement for SQL Compare. In many deployments, object lists (tables, procedures, views, etc.) are already maintained in Excel/CSV files. Selecting hundreds of objects manually in the comparison grid is time-consuming and error-prone.

    It would be very helpful if SQL Compare could import an external file (Excel/CSV/text) containing object names and automatically select the matching objects in the results.

    This would greatly improve efficiency and reduce manual effort in large-scale deployments.

    Thank you for considering this idea.

    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

  10. SQL Compare - Importing Object Selection from Excel or External File

    Hello Redgate Team,

    I would like to suggest a feature enhancement for SQL Compare. In many deployments, object lists (tables, procedures, views, etc.) are already maintained in Excel/CSV files. Selecting hundreds of objects manually in the comparison grid is time-consuming and error-prone.

    It would be very helpful if SQL Compare could import an external file (Excel/CSV/text) containing object names and automatically select the matching objects in the results.

    This would greatly improve efficiency and reduce manual effort in large-scale deployments.

    Thank you for considering this idea.

    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
1 2 … 10 11 12 14 Next →
  • Don't see your idea?