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.

239 results found

  1. SQL Compare Timeout for batch jobs

    We really need the ability to specify big timeout periods as we're dealing with large tables with breaking changes (adding constraints) which require rebuilding the table, and we have no luck completing the task due to short timeout in SQL Compare.

    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 →
    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. Excluding a role in v. 14 should exclude its permissions as was the case for v. 13

    Using the SQL Compare v. 13 CLI to exclude a role that exists only in the target database used to also skip permissions granted to that role. The resulting script did not revoke the role's permissions in the target. Now, in v. 14 (14.4.11.17350), excluding the role only keeps the role from being dropped. The resulting script revokes all permissions granted to that role in the target. We think this new behavior represents a defect that should be fixed. See my support request 225533. I am told there is a bug report that addresses this issue: SC-10183. However, I don't…

    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

  3. Open only once MS SQL Server Management Studio

    Instead of opening SSMS every time I create a new script with the DEPLOY button, it would be nice to check if SSMS is already openned and then switch to it instead of opening a new SSMS each time, at the end of the day I have 20 SSMS open.

    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

  4. Enhance support for default constraints

    I need to replicate a database for read-only reporting purposes and the production database is littered with all sorts of default constraints.

    For example:
    ALTER TABLE [schema].[table] ADD CONSTRAINT [DFtablecolumn] DEFAULT ('Unknown') FOR [column].
    This is what the definition is in SSMS.

    In SQL Compare:

    [column] [varchar] (15) COLLATE SQLLatin1GeneralCP1CIAS NOT NULL CONSTRAINT [DFtable_column] DEFAULT -- No text is available,

    Now the constraint fails AND the comma separator for the next line is missing.

    Another fun one:

    [SCD Surrogate Hash Key] AS (CONVERT([varbinary](64),hashbytes('SHA2_512',coalesce(CONVERT([varbinary](50),[column]),0x00)+0x0001))) PERSISTED NOT NULL,

    And SQL Compare loses all track…

    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 →
    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. Ability to turn off SQL formatting or change the formatting

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

  7. Support for Module Signing Comparison

    Please could you consider adding support for the comparison of signatures between databases. Currently SQL Compare doesn't check for differences between module signatures, please refer to this forum post:

    https://forum.red-gate.com/discussion/87404/module-signing-support

    The consequence of this is that during deployment by SQL Compare, module signatures will be ignored, therefore causing deployed modules that depend on the signatures to fail during execution.

    Additionally, should signatures be removed from a database using a command such as sp_refreshsqlmodule (which implicitly removes signatures), SQL Compare will not identify that the signatures have been removed.

    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. Tab size should be configurable

    The comparison window seems to use a hard-coded value of 8 spaces for tab characters. The SSMS default value is currently 4 spaces per tab. So things that align just fine in SSMS are always wacky when displayed in SQL Compare. Couldn't you make this a user-configurable 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…)
    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. amazon

    Should work on:

    how to simply install SQL Compare/SQLToolbelt on AWS EC2 instance (Windows/Linux based)?

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

    SQL compare regularly identifies a difference between the same index between the same table stored on 2 different databases as it seems to get confused with a different index then says the the same index underneath the 'different' one, should be deleted! It must not compare on the name of the index but maybe an order? Is this a bug?

    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

  11. SQL Search Right Click Modify

    If would be handy in SQL Search to be able to right click/Modify instead of double clicking, waiting for what could be a last treeview list in SSMS to open, then having to right click/modify.

    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

  12. Option to ignore stats based on name

    When recreating statistics that were "Auto Created" they now become non "Auto Created".

    This means when comparing the database against the original, because SQL Compare doesn't display "Auto Created" statistics, it looks like there are loads of new statistics

    I found this as I am trying to change collation of everything in a database and have to recreate the statistics.

    Please can there be an option to ignore statistics if they match based on name and the only difference is "Auto Created"?

    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. Add a keyboard shortcut to Next/Previous diff.

    It would be nice to be able to navigate to the next diff (or previous) using a keyboard shortcut (e.g.: CTRL-N, F8, etc...)

    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. Don't use "Added" and "Removed" in the Comparison Results report

    I just want to share the differences between two databases with the developer and will have to explain that added or removed does not mean that anything was actually added or removed yet.

    7 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

  15. Make script file an editable text file so we review, edit or programmatically generate the file.

    Make script file an editable plain text file so we review, edit or programmatically generate the file.

    Once the script file is used, there is no good way to retrieve what were included in that file, especially if the included objects have been removed.

    It will help us keep track of changes across multiple scripts (SCP) over time.

    Make it an option to compress it in case it is a large deployment.

    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. Page Not Found error when I try to get details on updates

    Getting page not found error again when I try to get full details for updates to SQL Compare. URL being hit is https://documentation.red-gate.com/display/SC14/SQL+Compare+14.3+release+notes.

    I get the feeling that this needs to be added to the "new version number" checklist or something alone those lines. Had similar issue a few builds back.

    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

  17. Refresh clears the details at the bottom. Clicking on highlighted object does not bring up details.

    SQL Compare ver 14.2.16.16006 Professional. When I select an object that is different, the details pane is brought up from the bottom. If I click on Refresh, a re-compare is performed and the detail pane goes away. The object that was previously highlighted, is still highlighted. When I click on that object, the detail pane does not come up. I need to click on another object to bring up the detail pane, then click on the original object.

    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. Ability to safely edit the previous server lists

    Please see this thread

    https://forum.red-gate.com/discussion/comment/162865#Comment_162865

    I would suggest that because the proposed solution requires knowledge and access to the Registry this should be a feature to edit the list.

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

    Please support Unicode. The current version can not display my descriptions of fields with Unicode.

    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

  20. Attempt to detect table renames

    SQL Compare should try to detect renamed tables and use sp_rename. At the moment, the existing table is dropped and a new table is created with the new name. To avoid data loss, it is necessary to create a migration script but SQL Compare should be able to detect this in a similar way to how it detects column renames.

    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 3 5 … 11 12
  • Don't see your idea?