Post reply

Redgate sql comparison tool: How to filter repeating columns to compare across

  • June 1, 2022 at 11:01 pm

    #4042907

    I am comparing two databases (mostly the tables). In the difference report, I see the matching columns as well. How to restrict the search (any global filter settings available?) so that the repeating columns (exist in both databases) do not appear in the report. That way the difference report will be more refined. I want to basically eliminate the from the comparison report in all the tables. Want to apply the logic for all tables.

    Any guidance would be very useful.

    Thanks.

  • June 2, 2022 at 12:47 pm

    #4043212

    I don't think we can do that. You can absolutely filter out tables that have no differences. However, once a table has a difference, in order to show that table, we're showing, you know, the table. That would include columns that match. We're just not filtering at the column level to my knowledge.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply