June 1, 2022 at 11:01 pm
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
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply