Finding differences between 2 SDE child versions

JoseSanchez

Hello everyone,

How can I find differences between 2 SDE child versions using C# or VB.net. Both versions (version 1 and version 2) that have the same parent, Default.

How can I identify the features that changed from a specific feature class from version 2 and copy these changes to version 1?

Can I change the parent for version 2 from Default to version 1 and then apply a reconcile and post?

Please advise

nicogis

In arcobjects you can see the difference between two transactional versions with this code:

-list of oids : update in Versione A and no change in Default   (no conflits …)

List<int> f1 = FindVersionDifferences(aWorkspace, "Version A", "DEFAULT", featureClassName, esriDifferenceType.esriDifferenceTypeUpdateNoChange);

-list of oids : delete in Versione A and no change in Default (no conflits …)

List<int> f2 = FindVersionDifferences(aWorkspace, "Version A", "DEFAULT", featureClassName, esriDifferenceType.esriDifferenceTypeDeleteNoChange);

-list of oids : insert in Versione A (no conflits)

List<int> f3 = FindVersionDifferences(aWorkspace, "Version A", "DEFAULT", featureClassName, esriDifferenceType.esriDifferenceTypeInsert);

-list of oids : update in Versione A and update in Default (conflits)

List<int> f4 = FindVersionDifferences(aWorkspace, "Version A", "DEFAULT", featureClassName,

esriDifferenceType.esriDifferenceTypeUpdateUpdate);

-list of oids : update in Versione A and delete in Default (conflits)

List<int> f5 = FindVersionDifferences(aWorkspace, "Version A", "DEFAULT", featureClassName, esriDifferenceType.esriDifferenceTypeUpdateDelete);

-list of oids : delete in Versione A and update in Default (conflits)

List<int> f6 = FindVersionDifferences(aWorkspace, "Version A", "DEFAULT", featureClassName, esriDifferenceType.esriDifferenceTypeDeleteUpdate);

you also get 6 lists between Version B and Default and compare lists for see difference between Version A and B

for example change in A and in change B and no change in Default:

var c = f1_VersionA_Default.Intersect(f1_VersionB_Deafult);
c is list of oids changed in A and changed in B but not in Default

and so on …

 

<SPAN class="keyword token">public</SPAN> List<SPAN class="operator token"><</SPAN><SPAN class="keyword token">int</SPAN><SPAN class="operator token">></SPAN> <SPAN class="token function">FindVersionDifferences</SPAN><SPAN class="punctuation token">(</SPAN>IWorkspace workspace<SPAN class="punctuation token">,</SPAN> String childVersionName<SPAN class="punctuation token">,</SPAN> String parentVersionName<SPAN class="punctuation token">,</SPAN> String tableName<SPAN class="punctuation token">,</SPAN> esriDifferenceType differenceType<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// Get references to the child and parent versions.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IVersionedWorkspace versionedWorkspace<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>IVersionedWorkspace<SPAN class="punctuation token">)</SPAN>workspace<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IVersion childVersion<SPAN class="operator token">=</SPAN>versionedWorkspace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">FindVersion</SPAN><SPAN class="punctuation token">(</SPAN>childVersionName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IVersion parentVersion<SPAN class="operator token">=</SPAN>versionedWorkspace<SPAN class="punctuation token">.</SPAN><SPAN class="token function">FindVersion</SPAN><SPAN class="punctuation token">(</SPAN>parentVersionName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// Cast to the IVersion2 interface to find the common ancestor.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//IVersion2 childVersion2=(IVersion2)childVersion;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//IVersion commonAncestorVersion=childVersion2.GetCommonAncestor(parentVersion);</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// Cast the child version to IFeatureWorkspace and open the table.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IFeatureWorkspace childFWS<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>IFeatureWorkspace<SPAN class="punctuation token">)</SPAN>childVersion<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ITable childTable<SPAN class="operator token">=</SPAN>childFWS<SPAN class="punctuation token">.</SPAN><SPAN class="token function">OpenTable</SPAN><SPAN class="punctuation token">(</SPAN>tableName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// Cast the common ancestor version to IFeatureWorkspace and open the table.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//IFeatureWorkspace commonAncestorFWS=(IFeatureWorkspace)commonAncestorVersion;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//ITable commonAncestorTable=commonAncestorFWS.OpenTable(tableName);</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IFeatureWorkspace commonAncestorFWS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>IFeatureWorkspace<SPAN class="punctuation token">)</SPAN>parentVersion<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ITable commonAncestorTable<SPAN class="operator token">=</SPAN>commonAncestorFWS<SPAN class="punctuation token">.</SPAN><SPAN class="token function">OpenTable</SPAN><SPAN class="punctuation token">(</SPAN>tableName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// Cast to the IVersionedTable interface to create a difference cursor.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IVersionedTable versionedTable<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>IVersionedTable<SPAN class="punctuation token">)</SPAN>childTable<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDifferenceCursor differenceCursor<SPAN class="operator token">=</SPAN>versionedTable<SPAN class="punctuation token">.</SPAN>Differences
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN>commonAncestorTable<SPAN class="punctuation token">,</SPAN> differenceType<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// Create output variables for the IDifferenceCursor.Next method and a FID set.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//IFIDSet fidSet=new FIDSetClass();</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IRow differenceRow<SPAN class="operator token">=</SPAN><SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">int</SPAN> objectID<SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List<SPAN class="operator token"><</SPAN><SPAN class="keyword token">int</SPAN><SPAN class="operator token">></SPAN> l <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">int</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// Step through the cursor, showing the ID of each modified row.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; differenceCursor<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Next</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">out</SPAN> objectID<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">out</SPAN> differenceRow<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">while</SPAN> <SPAN class="punctuation token">(</SPAN>objectID <SPAN class="operator token">!=</SPAN>&nbsp; <SPAN class="operator token">-</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>objectID<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; differenceCursor<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Next</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">out</SPAN> objectID<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">out</SPAN> differenceRow<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// fidSet.Reset();</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">// return fidSet;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> l<SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>