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

69 results found

  1. 46 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 →
  2. Currently, SQL Compare seems to map columns are they are listed in the table which results in incorrect mapping when new columns are added in between of existing columns.
    SQL Compare should attempt to map using the column name first.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  3. Our indexes are tuned and maintained in production. Database development is done elsewhere and moved using SQL Compare. Therefore we don't want to compare indexes. However, if we don't compare indexes, then the primary keys are not created. If we do compare indexes, there is a real risk that production will be damaged.
    This problem could be prevented by treating primary key indexes differently from other indexes. That this is even necessary is an implementation quirk of SQL Server.

    126 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Andrew Farries responded

    In SQL Compare 12.2.3.4239, released today, we have made a start on giving users more fine grained control over exactly which indexes are deployed.

    We have added a new `Ignore performance indexes’ option which will ignore all indexes except primary keys and unique constraints.

    We realise that there is more we can do in this area, so we would like to hear your feedback about whether this new option is helpful and how we can do more.

    Feedback on this feature can be posted on the forum thread:

    https://forum.red-gate.com/discussion/80770/new-feature-ignore-performance-indexes

  4. I'm documenting my databases using extended properties on the database level, and I've tried various options, but I can't find how to compare the database extended properties. We have dev, test, and production environments, so I need to sync these properties between the environments so they don't get lost when restoring dbs between them.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  5. Deal With Schema Bound Objects. SQL Compare 10.4.8 fails to deal with objects that are schema bound, so attempts to drop objects that have schema-bound dependencies causing an error.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  6. When applying a filter with "Starts with underscore" it removes all entries with underscore in the name, even when they underscore is not at the beginning of the name. Please fix. My upgrade scripts missed important stored procedures because of this apparent bug.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    This problem has been fixed in version 11.2 (currently only available via frequent updates). We have added new ‘Like’ and ‘Not like’ filter match operators which honour all SQL LIKE wildcards, and changed the previous ‘Begins with’, ‘Ends with’, and ‘Contains’ to stop treating them as wildcards.

    You may need to edit existing filters to take advantage of the new behaviour.

  7. This step is often skipped when I click on Next from Step 1. The Deployment Wizard will skip straight to '4 - Review Deployment Script'. This behavior is inconsistent: sometimes '3 - Review Dependencies' IS enforced even though it is skipped and other times it is not. In our situation, the rule is to NOT enforce dependency changes.

    This has bitten me several times in the past, so I now always click on Back when on Step 4 to see if Step 3 was enforced or not. Of three deployments today requiring SQL Commpare, two of them exhibited this behavior.…

    4 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 →
    completed  ·  Michelle Taylor responded

    We’ve seen this behaviour occasionally and believe we have fixed the problem in 10.7 – could you try upgrading, and email support@red-gate.com if you are still experiencing this problem?

  8. Simple really, allow an option to ignore the change tracking options on tables

    111 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Michelle Taylor responded

    We’ve added an Ignore Change Tracking option in Frequent Update 13.4.2.6669 (now available on the main update channel in 13.4.8.7337).

    You should be able to get this version now with Check for Updates if you have a valid support and upgrades contract.

  9. Don't offer upgrades that remove your license. I have a licensed version of the product, it asked me to upgrade and now it's asking me to enter my serial number. I didn't realize that the upgrade would take away my licence. I want my original licence back, these kind of ninja money grabs are just plain awful.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  10. xml, html and excel reports for database differences (using options) include everything similarities as well as differences. Since, xml is excellent way to import data to SQL, it would be great if those reports included only differences (so that the file size is smaller). Right now the differences can only be output to text file if I am not mistaken.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Michelle Taylor responded

    When you generate a report, there is a check box just above the last line in the dialog ‘Also include identical objects’ – if you uncheck this, then only differences will be output in your report.

  11. I have a server that I have to change the password on a lot, and can never (rarely) remember if I have changed the compare tool for the new password. I guess I could switch the servers around so that was the first it tries to get objects from. BUT it would be a nice feature to have it fail before doing any actual work.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    Hi,

    In SQL Compare 12 we have changed the comparison workflow so that we register both databases in parallel. This will allow the comparison to show you errors connecting to your target database before all the objects in the source have been registered.

  12. In previous versions of sql compare you were able to use the underscore character as part of your filters (exclude if object name begins with _)

    This no longer works and as underscores are fairly common when creating sample objects (at least in my company this makes it impossible for us to use.

    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 →

    This problem has been fixed in version 11.2 (currently only available via frequent updates). We have added new ‘Like’ and ‘Not like’ filter match operators which honour all SQL LIKE wildcards, and changed the previous ‘Begins with’, ‘Ends with’, and ‘Contains’ to stop treating them as wildcards.

    You may need to edit existing filters to take advantage of the new behaviour.

  13. (This is actually relevant to both SQL Compare and SQL Source Control.)

    We really need to be able to distinguish between unique and non-unique indexes when comparing, checking in, and deploying database schema changes. ("Unique indexes" include primary keys, unique constraints, and unique indexes on tables and unique indexes on views; "non-unique indexes" include non-unique indexes on tables and views.)

    Unique indexes are essential to the database development process. They make a significant functional difference to the behavior of the database: they enforce business rules and referential integrity; they limit the data that can be entered into the database; foreign…

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  14. Along the lines of this post: http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions/suggestions/2893526-the-integration-into-ssms-is-far-worse-then-previo
    Before we could right click and choose a database to be the source or the target of the comparison. Now I find myself having to choose the target as the source then press switch and then choose another source using the "compre to" option - it's quite a step backward from the previous integration.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  15. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  16. I've asked for this many times since SQL Compare 7.

    Please allow us to see the Last Modified Date on the objects. The information is VERY easily obtained.

    select objectid, Modifydate from sys.objects where type='P'

    It would be very useful and beneficial to see.

    105 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Andrew Farries responded

    We have just released an update to SQL Compare V12 on the Frequent Updates channel containing this feature. For tables, views, functions and stored procedures the comparison grid will show an extra column indicating when the object’s schema last changed.

    Feedback on this is best posted on the forums:

    https://forums.red-gate.com/viewtopic.php?f=200&t=80289

    We are interested in hearing whether this solves your problems and about any further improvements we can make.

  17. The ability to include an option for 'IF EXISTS' based on the object type. The IF EXISTS would need to be generated per database object. This would greatly assist in cases where you have 'similar' yet slightly different environments that you expect to be the same, yet may have had a patch applied early etc.

    You would need to be able to specify whether you drop and recreate, leave alone, or anything else that might make sense.

    Thanks,

    Nick

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. The integration into SSMS is far worse then previous version. Prior versions allowed selecting the second DB for the comparision by dragging onto the search pane from the object explorer. This took care of selection and login. Now we have to select the server, database and login as descreet tasks instead of just dropping and dragging. This was not an improvement.

    4 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 →
  19. When in the project window (showing you your recent projects you have loaded) it would be nice if you could just double click on an item to get it to load. Currently you have to click on a line to highlight it, then double click on it to load. It would be very nice if you didn't require the highlight step and part of the double-click would also highlight and open the item clicked on.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  20. I have have set "My Default" options then these should always be used, regardless of how I come to the project (but especially for any new projects). Currently if I launch SQL Compare from SSMS integration the Red Gate Default options are used.

    Steps to reproduce:
    Select a database, right click > Schema Compare / Deploy
    Drag a database over for the Target
    Compare/Deploy with SQL Compare

    Expected:
    SQL Compare uses "My Default" options
    (I have Ignore > Permissions)

    Actual:
    SQL Compare uses Red Gate Default options

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  • Don't see your idea?