Schema difference details

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Schema difference details

Postby manu08 » Thu Jun 11, 2009 2:48 am

I'm using v7 of the SDK. I have code right now to compare two database schemas. However, the difference objects that get returned only indicate that there was a difference.

Is there a way to get more detail? As in, I'd like a list of the schema differences between the two tables (e.g., the default values on someColumn don't match).
manu08
 
Posts: 1
Joined: Mon Apr 13, 2009 6:57 pm

Postby Chris Auckland » Fri Jun 12, 2009 3:35 pm

Thanks for your post.

There isn't a simple way through the API to tell you what kind of differences need synchronising. However, you could generate a report of the differences similar to the report you can generate through the UI.

We have an example of this on our website here

I hope this helps.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests