topic Editing and updating a sql table and sde featureclass in Data Management Questions https://community.esri.com/t5/data-management-questions/editing-and-updating-a-sql-table-and-sde/m-p/553082#M31336 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>I have a table of (point) data that is currently stored in sql server and my aim is to be able to edit and update this data by creating an SDE featureclass from it. Currently we have a series of batch files that run SDE commands to allow this process to happen however the process is long winded and requires manual user intervention. </SPAN><BR /><BR /><SPAN>What i would like to have, is a direct link whereby any changes being made to the point data in an arcmap or arcserver application show up in both the sql table as well as the sde featureclass, does anyone have any experience of implementing such a process? i've read that this could be possible by using the geometry keyword in sql server 2008??</SPAN><BR /><BR /><SPAN>many thanks</SPAN><BR /><SPAN>regards</SPAN><BR /><BR /><SPAN>Saad</SPAN></BODY></HTML> Tue, 25 Sep 2012 12:42:56 GMT SaadMasood 2012-09-25T12:42:56Z Editing and updating a sql table and sde featureclass https://community.esri.com/t5/data-management-questions/editing-and-updating-a-sql-table-and-sde/m-p/553082#M31336 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>I have a table of (point) data that is currently stored in sql server and my aim is to be able to edit and update this data by creating an SDE featureclass from it. Currently we have a series of batch files that run SDE commands to allow this process to happen however the process is long winded and requires manual user intervention. </SPAN><BR /><BR /><SPAN>What i would like to have, is a direct link whereby any changes being made to the point data in an arcmap or arcserver application show up in both the sql table as well as the sde featureclass, does anyone have any experience of implementing such a process? i've read that this could be possible by using the geometry keyword in sql server 2008??</SPAN><BR /><BR /><SPAN>many thanks</SPAN><BR /><SPAN>regards</SPAN><BR /><BR /><SPAN>Saad</SPAN></BODY></HTML> Tue, 25 Sep 2012 12:42:56 GMT https://community.esri.com/t5/data-management-questions/editing-and-updating-a-sql-table-and-sde/m-p/553082#M31336 SaadMasood 2012-09-25T12:42:56Z Re: Editing and updating a sql table and sde featureclass https://community.esri.com/t5/data-management-questions/editing-and-updating-a-sql-table-and-sde/m-p/553083#M31337 <HTML><HEAD></HEAD><BODY><SPAN>From SQL's point of view, there is no difference between a table and a feature class.</SPAN><BR /><BR /><SPAN>If you have a "point table", that is the table which should contain the geometry.</SPAN><BR /><SPAN>If you don't want/need the power/complexity of a versioned table, don't version it.</SPAN><BR /><SPAN>If you want edits to the text DMS or DD real data columns to manifest a change</SPAN><BR /><SPAN>to the geometry, use a trigger (the same is possible from an edit to the geometry,</SPAN><BR /><SPAN>though doing both would be difficult).</SPAN><BR /><BR /><SPAN>But there isn't really any reason to do this in multiple tables -- Creating complex </SPAN><BR /><SPAN>links between tables only harms performance.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Tue, 25 Sep 2012 15:56:13 GMT https://community.esri.com/t5/data-management-questions/editing-and-updating-a-sql-table-and-sde/m-p/553083#M31337 VinceAngelo 2012-09-25T15:56:13Z