Skip to content

SQL Data Compare

Welcome to the SQL Data Compare feature suggestion list. Find out more information about SQL Data Compare at http://www.red-gate.com/products/sql-development/sql-data-compare/

If you have any questions, need help or have found a bug in SQL Data Compare, please visit the forums at https://forums.red-gate.com/viewforum.php?f=201 or our support portal.

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Data 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.

115 results found

  1. Do not include quotes in header row when exporting

    Please do not include quotes in the field names of the header row when exporting results to CSV. If you double-click on the resulting CSV, Excel cannot parse the column names. Instead, what you get is a single cell for each row with all of the quotes and commas in 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

  2. In the "Tables & Views" tab I would like to have a checkbox "Show selected tables only". Thank you!

    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

  3. Provide option to prevent the automatic owner mapping

    Our company produces many products and our team develops product configurators for it. Each product has its own database schema and a project file for independent deployment in the test and production environment. When a new product is added, all project files have to be edited to unmapp the new schema, it takes a long time and is tedious.

    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

  4. Add option to drop a constraint instead of a "nocheck"

    My suggestion is to have an option to drop a foreign key in data compare instead of doing a "NOCHECK" / "WITH CHECK CHECK CONSTRAINT" with an "ALTER TABLE". Yes the way its done covers most cases but sometime the foreign key name need to be renamed in the same time. A drop/create can solve the issue. It's just a way to provide more control.

    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

  5. Add Row Count when comparing differences

    When comparing differences in the tables, add rowcounts in the tabs.

    For example, the tabs would read something like:
    All(234)
    Only in left (134)
    In both but different (0)
    Only in right (100)
    Identical (0)

    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. Bring back pivot view!

    I see from a community forum discussion that pivot view on the results grid went away after version 11.3, due to discontinuing licensing of Syncfusion components (issue SCD-2061). Please add my voice to those who found it useful and would like to see it come back! It's useful when the number of columns with differences is large, and the number of different rows is small.

    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

  7. Provide screen zoom capability (CTRL+ScrollWheel). This would help support 508 compliance.

    SQL Data Compare report output can be hard to read on a small laptop screen. Zoom capability with horizontal/vertical scroll capability would be helpful for viewing report output on smaller screens.

    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

  8. Create an option to change the direction of the update in a project without having to re-build the project

    I sometimes need to make changes to both the From database and the To database, it would be useful to be able to change the direction of the deployment script after having completed the comparison of the data. This would be useful in the SQL Compare tool as well.

    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

  9. table Id

    I am trying to compare only 1 field in the 2 tables, BUT the Id of the table is included anyway in the compare. That makes the compare result wrong. I expect identical in the result, but because the Id is included then the result is wrong. How can I remove the Id from compare?

    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

  10. Behavior of "Escape" / "RETURN" for cancelling or accepting in any (modal) dialog

    hi there,

    i would like to have a continuous behavior throughout the whole application regarding "Escape" -> Cancel and "RETURN" -> Accept.

    Its basically the same like his idea:
    https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/37568173-escape-to-close-value-details
    but everywhere in the whole Red-Gate ecosystem would be much appretiated.

    regards,
    Martin

    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

  11. Delete all rows or Truncate of target table

    to make a green field before compare. Mostly i use Data compare to refresh data from the live system to the dev/qa/... which is sometimes a mess. So i have to clear the target tables by hand before.

    This could be done in a global switch in "Edit project" -> "Options" but during the Deploy workflow I would remind the user and let him uncheck if required.

    Or at least make a clipboard copy for the scheme.tablename from the result window to make a manual truncate easier.

    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

  12. Make available for MySQL

    Make tool available for MySQL

    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

  13. Provide support for Amazon Redshift

    Provide support for Amazon Redshift

    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

  14. Add sort by selected in Dialog "Edit project" under "Tables & views"

    Its time consuming to scroll down to find the 5 checked tables within 400 tables in total. Please create some kind of a group/sort to show the selected on top or provide another toggle checkbox to show only the selected ones or all

    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

  15. Ability to send bugreport from unlicensed trial

    I've got some bugs during trial and I would like to send bug reports to support, but only licensed users can do it...

    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
1 2 3 4 6 Next →
  • Don't see your idea?