I am working on an application, and one piece of functionality is to output a detailed comparison between two databases, scripts folders, etc.
So far, my comparison output isn't very detailed and only shows output such as:
"OnlyIn1 Table dbo.Users"
"Different Role Superman"
Instead, I'd like very detailed output such as:
"Table <name of table here> has Index IX_UserKey"
Additionally, the SQL Compare GUI will show that one table in database A has changed compared to the same table in database B and will specifically show the SQL statement that is different.
How can I realize this type of output in my application?
Thanks for the help!