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.

69 results found

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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?

  4. Start-up position not saved

    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)
    Close
    Close
    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)
    Close
    Close
    completed  ·  AdminDavid Eadie (Software Engineer, Redgate) responded

    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

  5. reinstate open data compare from schema compare

    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)
    Close
    Close
    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)
    Close
    Close

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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?

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  Sam Blackburn responded

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

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Bug - Rename Table and Field

    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)
    Close
    Close
    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)
    Close
    Close
    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

1 2 4 Next →
  • Don't see your idea?