topic Compare FC structure in 2 SDE databases in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/compare-fc-structure-in-2-sde-databases/m-p/816962#M3488 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>Environment:</P><P>ArcSDe 10.7&nbsp; SQl Server</P><P>ArcGIS Desktop 10.7</P><P></P><P>We are looking for a way to compare the same feature classes in two databases and find the differences in the fields that were added, deleted or renamed.</P><P></P><P>Any tool to do that in ArcGIS SDE or directly Ms SQL server?</P><P></P><P>Any other suggestion running a Python script</P><P></P><P>Thanks</P></BODY></HTML> Thu, 25 Jun 2020 11:18:06 GMT JoseSanchez 2020-06-25T11:18:06Z Compare FC structure in 2 SDE databases https://community.esri.com/t5/geodatabase-questions/compare-fc-structure-in-2-sde-databases/m-p/816962#M3488 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>Environment:</P><P>ArcSDe 10.7&nbsp; SQl Server</P><P>ArcGIS Desktop 10.7</P><P></P><P>We are looking for a way to compare the same feature classes in two databases and find the differences in the fields that were added, deleted or renamed.</P><P></P><P>Any tool to do that in ArcGIS SDE or directly Ms SQL server?</P><P></P><P>Any other suggestion running a Python script</P><P></P><P>Thanks</P></BODY></HTML> Thu, 25 Jun 2020 11:18:06 GMT https://community.esri.com/t5/geodatabase-questions/compare-fc-structure-in-2-sde-databases/m-p/816962#M3488 JoseSanchez 2020-06-25T11:18:06Z Re: Compare FC structure in 2 SDE databases https://community.esri.com/t5/geodatabase-questions/compare-fc-structure-in-2-sde-databases/m-p/816963#M3489 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/message/643972-how-to-compare-feature-class-in-model-builder">https://community.esri.com/message/643972-how-to-compare-feature-class-in-model-builder</A>&nbsp;</P></BODY></HTML> Thu, 25 Jun 2020 11:41:52 GMT https://community.esri.com/t5/geodatabase-questions/compare-fc-structure-in-2-sde-databases/m-p/816963#M3489 JoseSanchez 2020-06-25T11:41:52Z Re: Compare FC structure in 2 SDE databases https://community.esri.com/t5/geodatabase-questions/compare-fc-structure-in-2-sde-databases/m-p/816964#M3490 <HTML><HEAD></HEAD><BODY><P>For a SQL way to handle this, look at this site.&nbsp;<A class="link-titled" href="https://codingsight.com/different-ways-to-compare-sql-server-tables-schema-and-data/" title="https://codingsight.com/different-ways-to-compare-sql-server-tables-schema-and-data/">Different Ways to Compare SQL Server Tables Schema and Data – {coding}Sight</A>&nbsp;</P></BODY></HTML> Thu, 25 Jun 2020 13:50:14 GMT https://community.esri.com/t5/geodatabase-questions/compare-fc-structure-in-2-sde-databases/m-p/816964#M3490 KathrynBrowning 2020-06-25T13:50:14Z