Red Gate forums :: View topic - how to get differences like in source control
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

how to get differences like in source control

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
slowcelica



Joined: 15 Feb 2014
Posts: 4

PostPosted: Sat Feb 15, 2014 12:13 am    Post subject: how to get differences like in source control Reply with quote

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?
Back to top
View user's profile Send private message AIM Address
Brian Donahue



Joined: 23 Aug 2004
Posts: 6671

PostPosted: Mon Feb 17, 2014 12:15 pm    Post subject: Reply with quote

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/Reporting_Schema_Differences

Hopefully this helps.
Back to top
View user's profile Send private message
slowcelica



Joined: 15 Feb 2014
Posts: 4

PostPosted: Wed Feb 19, 2014 5:38 pm    Post subject: Reply with quote

Brian,

Thanks that helped a lot, that is what I was looking for.
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group