how to get differences like in source control

slowcelica

I'm working on a project and I would like to show differences in between the source and target database like what is shown in SQL source control's get latest tab. Is this possible to do using SQL compare SDK? And are there any examples of how to do this or code samples?

Brian Donahue

Hello,

Showing side-by-side comparison of individual lines of SQL code is not exposed in SQL Compare's API.

You could use the command-line version of SQL Compare to generate a report - the "interactive" report format will compare lines of SQL and show the results, broken down by object, in a web browser.

There is a code sample for generating a similar report using the SDK, but it's probably not as good as using the command-line version of the commercial SQL Compare.

http://sdk.red-gate.com/index.php/Repor ... ifferences

Hopefully this helps.

slowcelica

Brian,

Thanks that helped a lot, that is what I was looking for.