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.

70 results found

  1. need ignoreMaterialziedViews option in flyway.toml

    need ignoreMaterialziedViews option in flyway.toml
    we want to ignore materialziedViews when performing drift checks and also while generating the baseline script itself.
    Having an option in flyway.toml will help

    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 →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    Hi, We just noticed this was in our SQL Compare forum, but it seems related to Flyway - https://redgate.uservoice.com/forums/949477-flyway.


    Is this an Oracle database? Our Oracle technology has the ability to ignore materialized views -

    https://documentation.red-gate.com/sco/using-ignore-rules-148079203.html. There's no GUI to create the ignore rules file yet, but I hope these docs help - https://documentation.red-gate.com/fd/oracle-filters-ignore-rules-138347101.html.


    If you need help with this, please get in touch with support@red-gate.com.


    Thank you!



  2. Make tool available for MySQL

    Make tool available for MySQL

    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…)
    1 comment  ·  Admin →

  3. Option to set 'Encrypt' off by default in the project screen.

    I have to click this off EVERY time I use SQL Compare or I can't connect to my databases. Can we please have an option to set this 'off' rather than 'on' by default?

    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…)
    4 comments  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    If you are using connection details that were first used with older versions of SQL Compare that did not have the checkboxes, then you will have to clear the previously saved credentials in order to be able to save the new desired ones with the checkbox values.  


    In order to do this you need to go into the windows credentials manger in the windows control panel and remove the saved credentials for the desired connection.  Thank you!

  4. Fix version 14.8+ so we don't have to type in ";Trust Server Certificate = true" for every server name

    Fix version 14.8+ so we don't have to type in ";Trust Server Certificate = true" for every server name. We don't have to do this for other tools from Idera, Solarwinds, Orion, Microsoft, or any others. This is a bug in SQL Compare and SQL Data Compare newer than v14.7.7.21053

    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 →

  5. Add a button to copy Database name from one side to the other in New Project

    Most times when comparing environments, the Database name is the same. It would save time to be able to copy over the Database name from the Source to the Target, rather than having to type or select it from the drop-down list.

    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…)
    1 comment  ·  Admin →

  6. MySQL 8 Compatibility

    This should be a no-brainer, but nobody from Redgate is responding to the numerous topics and posts in the forum.

    Everyone is getting the error "Unable to cast object of type "System.Byte[]" to type System.String"

    Thank you from everyone who uses MySQL Compare

    9 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…)
    4 comments  ·  Admin →

  7. Compare based on Selected Schema

    I would be ideal if there was the ability to compare just a single Schema in databases. Example, exclude all dbo object and just include all objects in the XX schema. This would speed up the compare, as we would only be comparing objects in the XX schema and ignoring the 10K objects in the dbo schema.

    10 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 →

  8. Sort by Last Modified is broken

    Sort by Last Modified is broken in SQL Compare 14.0.6.13387.

    When I click the column heading to sort (Source or Target, order changes, but is definitely not ascending or descending.
    And the Last Modified value shown in the grid does not match that seen in sys.objects, information_schema.routines, or object explorer details.

    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…)
    completed  ·  1 comment  ·  Admin →

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

    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 →

  10. Generate Html report older version is better, new version has lot of scrolling.

    older version side by side comparison report better than the new version vertical comparison.

    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…)
    2 comments  ·  Admin →

  11. multi factor

    Support Azure AD auth using MFA

    93 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…)
    7 comments  ·  Admin →

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

    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…)
    4 comments  ·  Admin →

  13. Ignore MASKING FUNCTION on columns

    Dynamic masking functionality is new to SQL 2016. It is applied on columns.

    https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking

    Great for DEV and UAT environments where data obscurity is required.

    CREATE TABLE Membership

    (MemberID int IDENTITY PRIMARY KEY,

    FirstName varchar(100) MASKED WITH (FUNCTION = 'partial(1,"XXXXXXX",0)') NULL, *ignore these

    LastName varchar(100) NOT NULL,

    Phone# varchar(12) MASKED WITH (FUNCTION = 'default()') NULL,

    Email varchar(100) MASKED WITH (FUNCTION = 'email()') NULL);

    Ideally we need this ignored in SQL Compare and SQL Source control comparisons so it is not accidentally deployed to production.

    18 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 →

  14. Version 12 "Edit Project" UI: backspace should *not* clear out the database name

    In version 12 pressing "backspace" while typing the database name in the "Edit Project" screen clears out the database name completely instead of just deleting the last character.

    Made a typo while typing in the database name? Too bad, you'll have to type the whole thing again after pressing Backspace. Constantly switch between servers with thousands of databases with similar, but slightly different names? The Database textbox is nearly impossible to use until the database list in the drop-down is fully loaded (which can take a while) because when you go to backspace, it just wipes the text without letting…

    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…)
    1 comment  ·  Admin →

  15. Add support for External Tables

    I use Azure SQL, and there is limited cross-database functionality in that environment. Due to this I have several External Tables that I use to point to a Master Database with shared setting, info, etc. for each customer database.

    When I used SQL Compare to fill out the schema for a new database it copied all of the External Tables as Local Tables, and it didn't bring over the Data Source either. This could be very handy as dealing with external tables (and especially changes to them) is a pain.

    119 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…)
    6 comments  ·  Admin →

  16. Run SQL Compare on Linux/Mac

    I know weird to with a MS SQL Server, but many people who have been on the platform for a while now have developers with Macs, and automation systems on linux. DLM Automation is pricing some of us out of the Redgate ecosystem. With SQL server now running on Linux seems a reasonable path. I sure hope our beloved sql compare is not going away :(

    160 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…)
    13 comments  ·  Admin →

  17. Link to "Full Release Notes" broken -- please fix

    Link to Full Release Notes on the page at the URL below is broken -- please fix. Also, I get JavaScript errors on the page -- someone should look into.

    http://www.red-gate.com/updatecontrols/details?etc=1128868242&guid=f8b6d1e4-d76d-41eb-92c0-f0fa2edd2379&update=1687

    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…)
    2 comments  ·  Admin →

  18. v 12.0.33.3389 UI is sow and blocking compare to previous version

    unsure what is causing this, but i find the new version to much less performant.

    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…)
    1 comment  ·  Admin →
    completed  ·  Sam Blackburn responded

    We’ve just released SQL Compare 12.1.1.3793 to Frequent Updates, which some performance improvements when selecting/deselecting large numbers of tables. The performance improvement is particularly noticeable when the source is a scripts folder and the target is a live database over a network connection. (SC-9157) Does this solve your problem?

  19. Couple Fixes needed for the UI

    With the new UI several things are now "broken".

    First of all, on the Project dialog, the Database Drop Downs do not select the entry that matches what's in the text box.

    So if I have a list of database such as:

    DB A
    DB B
    DB C
    DB C2

    and the Text says "DB C", when I click the button for the drop down, it doesn't highlight it. So what that means is if I want to change it to DB C2, I either have to start typing in the name again, or scroll through the list until I…

    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…)
    1 comment  ·  Admin →
    completed  ·  Sam Blackburn responded

    We’ve implemented these features in the latest Frequent Update release, version 12.0.34 – does this work for you?

  20. BUG: SQL Difference pane shows non-existing differences in preview bar

    The preview bar on the left of SQL Difference pane shows dark blue segments for the lines that have no actual difference at all. It also appears that it is showing them for the comment lines generated by the tool, like -- Columns and -- Permissions. Version 12.0.30.3199 Professional

    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…)
    4 comments  ·  Admin →
    completed  ·  Sam Blackburn responded

    We think we’ve fixed this bug in the latest Frequent Update release, version 12.0.34. Does this solve your problem?

← Previous 1 3 4
  • Don't see your idea?