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

239 results found

  1. Compare already has a search filter, however it would be great if you could also search within the objects and not just by the object names.

    8 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)
  2. 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)
  3. When using script as a comparison source allow the ability to exclude one or more of the subfolders.

    4 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. We use both SQL Compare and SQL Source Control to track schema changes. When you update scripts using SQL Compare, it sets the ProjectGuid property in the RedGateDatabaseInfo.xml file. When you check in changes using SQL Source Control, it removes the ProjectGuid from the file. This creates extra work because source control indicates there are differences or conflicts when this is the only change. It would be helpful if the two tools functioned the same.

    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)
  5. I have installed the SQL Toolbelt and I would like to update all its components in one shot. Currently, It is possible only by downloading the setup of Toolbelt from Redgate site and "re-installing" the products.

    When I go to Help->Check Updates for particular component, let's say SQL Compare, only this component can be updated. And mostly I have to close All my SQL Server Management Studio (SSMS) session and Visual Studio (VS) Sessions for the
    update, which is time-consuming, but I guess makes sense.

    But after this, I start again all my SSMS and VS sessions and When I…

    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)
  6. Please add an option to "Ignore index named like nciwi%

    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.

    22 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)
  7. With a deadline looming I needed to do a comparison, but I could not see the 'to and from' database machine name until I installed the update. It was hidden underneath the ribbon.

    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)
  8. Current behaviour: the CSV file represents null as the 8-character string “<NULL>” . e.g. If I have a table with an integer primary key column id, a varchar column a, and a varchar column b, and the table has one newly-inserted row (1, NULL, “asdf”), the CSV file would look like this:

    o “Type”,”idk”,”as”,”at”,”bs”,”b_t”
    o “In1”,”1”,”<NULL>”,””,”asdf”,””

    Desired behaviour: allow the CSV file to represent null as a completely empty entry. E.g. the CSV file would look like this:

    o “Type”,”idk”,”as”,”at”,”bs”,”b_t”
    o “In1”,”1” ,, ””,”asdf”,””

    Suggested options:

    1) Command line switch toggling between…

    10 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)
  9. Save the state of the Group By drop down so that we don't have to change it with each managed project.

    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)
  10. I usually create a snapshot of the target database before each deployment so I can compare again later to see the changes or generate a reversal script on selected objects. Please add the option to the Deployment wizard alongside "Back up target before deployment"

    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)
  11. Data Compare almost always fails because of frequent (but short) network outages. If we could specify a long timeout, that would solve this problem.

    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)
  12. In the results grid, give the ability to filter the results instead of having to sort, great example is the schema column, let us filter by schema instead of having to sort and then scroll to find the schema we want to look at.

    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. For those of us working with data warehouses, using SORTINTEMPDB is the default behavior we need.

    9 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)
  14. 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.

    5 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)
  15. Downloaded the trial version then my company paid for the toolbelt but when I click on Activate I get a error so cannot activate the software.

    Can’t connect securely to this page
    This might be because the site uses outdated or unsafe TLS security settings. If this keeps happening, try contacting the website’s owner.

    So, I'm contacting 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)
  16. The source for create new snapshot defaults to database. Automatically populate Server, Authentication, Database and New Snapshot name using the Database information on the other side of the compare window.

    Customizable name tags for the new snapshot name would be perfect: [SERVER][DATABASE][DATETIME].snp

    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. I have 2 databases - production, and archive. Archive has all the indexes of production (starting with "IX") but also has some archive only ones (starting with "AIX"). Would be nice if I could add a filter to "exclude indexes starting with 'AIX-'" to my comparison - currently I have to export to a script, and manually delete all the "drop index AIX_..." sections.

    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)
  18. There is an option to ignore identity seed values but none for sequence seed values.

    9 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. As per:

    https://forum.red-gate.com/discussion/85655/feature-request-sort-objects-in-deployment-script

    When generating the sql compare deployment script - all objects are scripted in a seemingly random order.

    This could be covered by an option to enable/disable it.

    And obviously, there is a dependency order which much take priority first. But after that all objects should be scripted in alphabetical order.

    Use case for this is generating the same update script multiple times and committing it to source control. If this is done during a RC phase, the later iterations of the script will be 90% the same with minimal differences.

    Currently as it stands, objects get moved…

    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. Can you provide an option in the tool to ignore unmapped tables for comparison?

    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)
  • Don't see your idea?