how to get differences like in source control

Automate and integrate using the SQL comparison API

how to get differences like in source control

Postby slowcelica » Sat Feb 15, 2014 12:13 am

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?
slowcelica
 
Posts: 4
Joined: Sat Feb 15, 2014 12:08 am

Postby Brian Donahue » Mon Feb 17, 2014 12:15 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby slowcelica » Wed Feb 19, 2014 5:38 pm

Brian,

Thanks that helped a lot, that is what I was looking for.
slowcelica
 
Posts: 4
Joined: Sat Feb 15, 2014 12:08 am


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests