Top 10 SQL Compare Tips. Watch now.

Can we generate a report in SQL compare that includes Column changes at a table level? if yes, how?

Objective: I am trying to compare two databases using command line.
Scenario: I have two DBs with different names. In one of the table, I have added a new column. I am expecting that while schema comparison, I should be able to see the different columns added explicitly.
Actual output: I am getting only tables list and NOT the columns.
.\SQLCompare.exe /server1:%server1% /server2:%server2% /database1:%database1% /database2: %database2% > "C:\AutomationLogs\comparisonLog_%database1%_vs %database2%.txt"

Best Answer

  • Jessica RJessica R Posts: 1,278 Rose Gold 4
    Accepted Answer
    Hi @spangotra!

    The command line output will only show what's different at the object level, but if you generate an html report via the ">/Report switch, it will show you what about the table object has actually changed .

    Is that along the lines of what you were looking for?

    Hope that helps!

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Sign In or Register to comment.