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

104 results found

  1. We'd love the ability to be able to ignore varchar/nvarchar differences between databases. We have separate databases that are essentially the same, except all varchars are nvarchar to support unicode.

    At the moment, we cannot use SQL Compare to compare the two databases, as every Table/SPR/UDF comes up with changes.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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)
    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)
  3. We have certain tables with BLOBs (varbinary(max)) which takes ages to compare between two databases. But if i exclude this column for comparison, it wont appear in the deploy, which will fail (in my case) caus its "NOT NULL" column.

    In short:
    make an option to ignore columns on compare, but keep in deploy.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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)
    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)
  5. 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)
    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)
  6. Having sql-servers named "sqlserver218165", sqlserver328976" it would make a big difference if we in Sql compare could give the servers aliases, so we could compare "AccountingTest" to "AccountingProduction"

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. The current behaviour is to jump between rows to the next change of the currently selected field. While I understand that can be very useful, I've never actually needed that function. In fact, in comparing quite large data sets (over 100 rows) where any of the fields can change (and frequently not the same one) it's actually quite counterproductive (especially for someone like me who's not a big mouse user)

    Would it be possible to have an option to enable that feature somewhere in the application options so that I can turn it off?

    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  ·  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. Please add this feature when saving projects. It would be useful when the project has not been deployed, but saved for a future deployment or re-review without having to re-select all the tables.

    "The project does not remember which tables or rows of data were selected for deployment."

    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)
  9. Exporting the comparison results as excel file with customization:

    We are using Redgate trial version of "SQL Data Compare 14" using command line for the past couple of days for the data comparison work. As of now I understand that while exporting the comparative data in excel, each table result will be available in individual excel and the report summary for the consolidated tables. I want to know whether I can change the format of the excel file which is generated (excel customization). If so, please let me know how to do that process also I have attached the format…

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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)
    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)
  11. I would like to be able to add a tolerance to use to when comparing numeric values by column if possible.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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)
    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)
  13. 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)
    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)
  14. Now there is no option to split the script generated for sql data compare for very large data. It will make memory issues while running huge data script. Splitting the insert script for migrating data will be a good solution.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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)
    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)
  16. 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)
    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)
  17. The SQL Data Compare GUI is the best way to review differences. I'd like a way to export my results to a file that can be re-imported for others to view, without having to go back through the comparison process.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Instead of putting all alter table operations into a single command, provide an option to have them split into multiple individual operations.

    Instead of this:
    ALTER TABLE JobTime ADD
    UUIDPayWeek nvarchar (50) NULL,
    XMLEquipment xml NULL,
    XMLConsumables xml NULL;
    GO

    Do this:
    ALTER TABLE JobTime
    ADD UUIDPayWeek nvarchar (50) NULL
    GO

    ALTER TABLE JobTime
    ADD XMLEquipment xml NULL
    GO

    ALTER TABLE JobTime
    ADD XMLConsumables xml NULL
    GO

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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  ·  Admin →
    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 5 6
  • Don't see your idea?