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

242 results found

  1. 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)
    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)
  2. 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)
    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)
  3. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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)
    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)
  5. 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)
    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)
  6. Ability to create a separate re-runnable script for each object being updated in SQL Compare, instead of just one big script. This is very important to our business.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  7. In Windows operation systems it is a common way to use Control+Insert keys instead of Control+C to copy selected text.
    This is necessary to support left-mouse-handed people and it's driving me crazy that it does not work within your product(s).
    At least I would love to use this option when working within the Comparison to copy code from a left or right script using Ctrl+Ins.
    For completeness you should also keep "Shift+Insert" for Paste and "Shift+Del" for Cut operations in mind.
    Thank you

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  8. For example, I would like to ignore when a column is a VARCHAR on both databases but with different lengths so I can focus on when the 2 data types are completely different eg. VARCHAR and NUMERIC.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  9. Let me change the location of the users data folders. The application creates a folder inside the Documents folder. When I change the location in the Application options dialog still a folder inside the Documents folder is being used. I want my Documents folder not to be used by this application

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  10. When running a deployment (especially for the automated DevOps part, but even for creating a deploy script) you should have the option to enter/update a new Extended Property value called like “RedGate Version #” with whatever the version number you get from the source control for that object. Ideally it would be nice to also update that in the database level Extended Property as well, but at least on whatever object you are making a change to with that deployment. That way you can self-document what the latest version control number was for that particular object (or the DB as…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  11. 1) SQL Compare has handy database snapshot ability to a folder. It would be great if rather than creating 1 database snapshot at a time you could tick each of the databases you'd like a snapshot created for.

    2) Would be cool if like SQL Multiscript tool, you can speficity multiple servers and databases and have the snapshots named and/or placed in folders with server and database names.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  13. SQL Compare 14.2.4.15334
    I have checked "Ignore permissions" and "Ignore users' permissions and role memberships", but deployment script is creating grants for existing permissions on tables being recreated (replacement table created & populated, old table dropped, & replacement table renamed). Expectation is that it obeys the ignore options.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. There should be a way to Export HTML via "Generate Comparison Results Report" using Command Shell.
    When we have a ".scp" file which contains the Information about the Databases to be compared, which is saved as a project.scp.
    In this case, if we have a ".scp" file, then is there any command to export the html.?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  15. I am trying to do a schema compare and deploy but the source database has 99k objects. Is it possible to chunk the deploy feature?

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. At the moment, extended properties that are varchar or nvarchar are scripted out by SQL Compare as literals ('value' or N'value'). Unfortunately every other data type is scripted out over three lines (plus a GO), declaring an @xp variable of the appropriate data type, SELECTing (not SETting) its value, and finally adding the property.

    With heavy use of extended properties, or even mild use of non-(n)varchar properties, change scripts (and object scripts in SQL Source Control) can become huge pretty quickly. This causes various issues, not least of which is readability during peer review/PR approval.

    I'd like to see this…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  17. (1) the ability to compare 'similar/same' objects that are name differently
    (2) the ability to compare objects in the same database that are named differently
    (3) the ability to merge specific changes that are found, in both directions

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  18. File->Create scripts folder should script index fill factor. When the created folder is compared against a DB I can optionally include/exclude the fill factor as I need

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. It would be nice to have clean powershell cmdlets (like SCA) for SQL Compare rather than having to use the old-school command line and arguments.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Currently using version 14.1.7.14336. clicking on Help, Check for updates. I get you are running the latest version. But there has been 3 updates released since. The current update is 14.1.10.14805 released 01/27/20.
    Trying to see why this happening. How long does it take for the software to see these updates.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?