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

63 results found

  1. 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)
    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. 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)
    You have left! (?) (thinking…)
    completed  ·  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)
  3. 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)
    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. 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)
    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. 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)
    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. 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)
    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. 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)
    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)
  8. 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)
    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. 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)
    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. 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)
    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)
  11. 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)
    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)
    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?

  12. 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)
    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)
    completed  ·  Sam Blackburn responded

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

  13. 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)
    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)
    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?

  14. Prior to v12, you could run schema compare and then click a button to open data compare with same data sources. seems to have gone now

    1 vote
    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. SQL Compare (and SQL Data Compare) still don't save their position on last close. It will always start in the upper left hand corner of the screen. I know this was reported before and it is shown as fixed but I'm running 12.0.30.3199 and it's still a problem on a fully patched Win7 Pro computer.

    1 vote
    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)

    Hi Michael,

    This was fixed in 12.0.32.3340 which is currently available on our frequent updates channel. You can switch on frequent updates by following the guide below. This change will be rolled into a default release later this month.

    http://documentation.red-gate.com/display/SC12/Turning+on+Frequent+Updates

    If you are still encountering issue with the start up positioning of the application following this update please could you get in contact with our support team by emailing support@red-gate.com.

    Regards,
    David

  16. When using compare to create out db rollout packages, we also create the rollback by changing the deployment direction. There is a bug where I could have items selected. Then I change the direction and no items are selected. Also had at one point where I selected a table did both directions. Unchecked the table then selected 2 sprocs. Changed the direction and it unchecked the 2 sprocs and reselected the table. This causes much headache and time to our process. Potentially we could miss items for our rollback solution and not know it until a time or rollback. Also…

    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)
    completed  ·  Sam Blackburn responded

    We think we’ve fixed this in the latest Frequent Update version, 12.0.32.3340. Does this version work for you?

  17. The Project Browser, that could be opened at startup, was replaced in Compare 12 with a much less useful standard Open File Dialog. Please bring back the browser. See also, https://forums.red-gate.com/viewtopic.php?f=200&t=80066

    18 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)
  18. I sent two crash reports today. (Unhappily the first time I ran version 12.) It did not describe or let me see what was being sent. I don't really feel comfortable with that. I'd like to know what is being sent before I send any more reports.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Sam Blackburn responded

    As of SQL Compare and Data Compare 12.2.4, the exception report dialog has a “view report data” button which will allow you to view the exact data which would be submitted to Redgate.

    We primarily added this feature to ensure users could assess any possible impact on their privacy, although the feature could also be used to dig through the data and recover the table name our support engineers found.

    At time of writing, 12.2.4 is on our frequent updates channel, and we expect to release the feature to default channel soon.

  19. Table tblTableA with field fldFieldA is renamed tblTableB and field fldFieldB.
    Then map tables between two different databases.
    Script snippet generated in renaming field is something like:
    IF (COLLENGTH(N'[dbo].[tblTableA]', N'fldFieldA) IS NOT NULL) AND (COLLENGTH(N'[dbo].[tblTableB]', N'fldFieldB') IS NULL)
    EXEC sp_rename N'[dbo].[tblTableB].[fldFieldA]', N'fldFieldB', N'COLUMN'
    GO
    Obviously I have omitted other script details, but hopefully you get the idea, that this will not work as the table has been renamed.

    Rob

    0 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)
    completed  ·  Sam Blackburn responded

    Update: It turns out this bug was really easy to fix – we’ve released it to our Frequent updates channel.

    Cheers,
    Sam.


    Hi Rob,

    Thanks for your feedback. I’ve managed to reproduce this issue locally and I’ve logged it with reference number SC-8948.

    I’m going to close this user voice request since this is for a bug rather than a new feature. (We track these in a slightly different way and want to make sure we triage this appropriately). If you’d like to track the progress of this fix please get in contact with our support team by emailing support@red-gate.com.

    Cheers,
    David

  20. I think it would be great if once you create a script from SQL Compare you would add the 'use db_name' as the first line to ensure the script gets ran on the correct database. Often I send my scripts to other teams to run and this will ensure they are running the script on the correct database. I believe SQL Data Compare already does htis after you create a script. Keep up the good and I can't say enough about how awesome your tool set is!

    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)
← Previous 1 3 4
  • Don't see your idea?