How can we help you today? How can we help you today?

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.
Query:
.\SQLCompare.exe /server1:%server1% /server2:%server2% /database1:%database1% /database2: %database2% > "C:\AutomationLogs\comparisonLog_%database1%_vs %database2%.txt"
Siddharth
0

Comments

4 comments

Sort by

Add comment

Please sign in to leave a comment.