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

  1. We use SCA with the following setting:

    <SyncOptionIncludeExistenceChecks>True</SyncOptionIncludeExistenceChecks>

    Yet when a migration script is created for a table with data tracking enabled, there is no existence check:

    PRINT (N'Add 1 row to [dbo].[ReleaseNote]');

    SET IDENTITY_INSERT [dbo].[ReleaseNote] ON;

    INSERT INTO [dbo].[ReleaseNote] ([ReleaseNoteID], [AppVersionID], [ReleaseNoteText], [DisplaySequence], [DisplayCondition])
    VALUES (14, 4, N'You can now save calculations.', 2, NULL);

    SET IDENTITY_INSERT [dbo].[ReleaseNote] OFF;
    GO

    I just got an error for the statement above, since the record already existed. Can you please update SCA to apply existence checks to table inserts?

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Provide AWS AMI for Redgate SQL Data compare

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. I should be able to import an SQL Compare project into an SQL Data Compare project to get db names and such, plus table and owner mappings.
    It seems like it would be a frequent thing that a compare and build would be followed by a data migration too.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  4. You should be able to hide schemas from the display of un-mapped items at the bottom of the table mappings project edit dialog.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. On the table mapping project edit page, the Where clause functionality needs to be added to the unmapped items at the bottom.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. There's already an "Export to Excel" option, can we extend this to have an option send the results to Libre Office Calc instead?

    If you want a use case, I can give you a few. But my usual one is that my Excel is busy running macros and won't respond for five or ten minutes until it's finished. So sending it to Libre Office to filter would save me some time.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. When I am comparing a SQL Source Control Repository against a DB, we need find an option to only compare tables which are linked for static data in source control.
    This seems like a glaring missing feature, since I now have to create a project that manually maps all the tables that have static data and ignore everything else, and manually update it when new static tables are included in the repository.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. I keep getting the error "Error mapping index key - try using clustered index as comparison key". I can't tell what table it refers to as it's not shown in the error message or the More Popup. It would be very helpful to display the table name when showing error messages

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. I would like to see all the differences from "Only in left" and "Only in right" and "In both but different" in one view/tab.

    I know you can turn off "Show identical values in results" from the project options and then use "All Rows" but that requires a re-compare which can take a long time.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. SQL Data Compare resorts the files during every check in preventing source control from correctly reporting changes.

    1) It prevents us from performing code reviews on data checked in.
    2) It prevents us from figuring out who made a change and when without huge efforts.

    We have tried to live with this behavior but are finding it extremely frustrating.

    When users add a new record, SQL Data Compare first sorts the existing file and then adds the new record to the top of the file. This makes it look like the user is performing multiple actions in source control causing…

    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  ·  Flag idea as inappropriate…  ·  Admin →
  15. Can we please get the ability to export the contents of the SQL Data Compare results window (containing the rows with differences) to Excel, complete with the cell formatting seen in the application? I.e. headers for fields with differences in bold, cells with differences highlighted a different colour, etc.

    This functionality exists in SQL Prompt (exporting from SSMS, admittedly without the formatting) so surely should be possible from Data Compare also?

    Even better would be to be able to do this for all tables/subsets selected in the list of tables above the results window (i.e. all the data included by…

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. An HTML report similar to the one provided with the SQL Schema Compare utility would be an excellent tool for doing QA Testing and Regression Testing. The QA Analyst could send the HTML report link to programmers to fix erroneous data. (The databases being compared would be the Pre-Test versus the Post-Test data.)

    7 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  ·  Flag idea as inappropriate…  ·  Admin →
  17. It would be useful to sort a column so that differences appear first (or last). This could be done through a right click on the column headers and selecting the type of sort to perform.

    When comparing dataset with a large number of different rows (in my case 150k) where one column may having only 1 row that's different its next to impossible to find that row. Using the mouse to drag the scroller skips too much to be useful and paging down takes FOREVER.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Compare does not read from SQL backups that have used the native compression, although they can read from Redgate Backup files that have been compressed. I think that it should also be able to read from SQL compressed backups, as not all users will have Redgate Backup software.
    This would be beneficial to all, because it would create a way of restoring lost data without using a partial restore, to any user that has this Compare software.

    32 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  ·  Flag idea as inappropriate…  ·  Admin →
  19. My primary usage as QA is to use some DB as a baseline, run old code against it, run new code against it, and compare the results. Most of the differences are the times that records were updated or other time related fields. I am only interested in the data differences. All of the datetime field differences clutter the comparison and increase my analysis time by about a factor of 20.
    I know I could go in and manually find all of the datetime fields in each of the 300-600 tables (depending on the DB) and un-check all the datetime…

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Would like to be able to assign a color to server/database combinations so that I can easily see what database will be updated. For example, my PROD database would always be colored red and it would help from pushing changes to the wrong database.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5
  • Don't see your idea?