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. Include new functions, views and stored procedures in "use DROP and CREATE"

    Would like to include newly defined views, functions and stored procedures when dropping objects in deployment script. Currently, if you create a new stored procedure, then do the compare, it only does a CREATE in the script even if you have "use DROP and CREATE" selected as an option. I have to manually add the drop commands to the script so that it can truly be executed multiple times if needed.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Post script bit value column auto-update

    Add an option that will run post-script to set newly added columns that are of a bit value type and that are scripted with a default value to that value after the addition of a bit column.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. monthly subscription

    I would like to start using the Red Gate Toolbox but I cannot afford the cost nor will my company pay for it. Is there an option to be billed monthly?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add an option to ignore seed value when scripting sequences.

    There is an option to ignore identity seed values but none for sequence seed values.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add an option to the behavior section to include SORT_IN_TEMPDB = ON on all of the CREATE INDEX statements.

    For those of us working with data warehouses, using SORT_IN_TEMPDB is the default behavior we need.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Option to "Ignore index named like nci_wi_%

    Please add an option to "Ignore index named like nci_wi_%

    These index are added by SQL Server (starting with Azure SQL DB), as part of optimizing the workload on a database.

    They make it impossible to compare two databases, as too many "false" differences exists.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. More in-depth documentation of how SQL Compare works

    Hello

    It would be great if there is documentation that explains how SQL Compare works. Everything I came across so far explains what it does but I didn't find the actual internals of it. I am particularly interested in how SQL Compare handles the dependencies between various objects. For example, how can it create a view before creating the tables the view is using?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. CONSTRAINT of current_timestamp generates code that will not run in SQL

    tsql source has line:
    [CreateDate] datetime default CURRENT_TIMESTAMP,
    the script that is generated:
    ALTER TABLE [dbo].[AirFlowData] ADD CONSTRAINT [DF__AirFlowDa__Creat__82DA8F3] DEFAULT (current_timestamp()) FOR [CreateDate]

    Error executing script:
    Incorrect syntax near '('.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. pin "object definition box"

    Allow for pinning of the Object Definition Box so that it is always visible.

    It would be nice if you could make the ODB (that's what I'm calling it from now on) could be pinned or made to float so that I could reference it as i type.

    The object explorer does provide the same functionality... technically but its nice have the "source" immediately visible as opposed to the multiple folders in the Object Explorer.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Status Messages Covering Server Names

    Currently the status messages in the UI for things like Updates to the application show up as blue ribbons that COVER THE SERVER NAMES. That's annoying. The choice are to be reminded again later or skip the message or whatever. But the location for the status message should not cover the server names. Could you kindly move it someplace else? Thanks.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. multi factor

    Support Azure AD auth using MFA

    70 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7 8
  • Don't see your idea?

SQL Compare

Feedback and Knowledge Base