topic Re: How to extract features inserted, deletesd and updated in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492805#M28005 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what are the pros and cons of using SDE Synchronization versus running a script that extracts all inserts, updates and deletes and replicates them to other instances?</P><P></P><P>Thank you</P></BODY></HTML> Mon, 09 Nov 2015 19:35:23 GMT JoseSanchez 2015-11-09T19:35:23Z How to extract features inserted, deletesd and updated https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492803#M28003 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>the goal is to create an application or script that extracts by feature class all the records that were created, deleted and updated from the previous day, and then replicate them in a production database used only for read only access.</P><P></P><P>How do you select and extract from a feature class all the features that were inserted, deleted and updated, since for example yesterday?</P><P></P><P>thanks</P></BODY></HTML> Mon, 09 Nov 2015 18:57:09 GMT https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492803#M28003 JoseSanchez 2015-11-09T18:57:09Z Re: How to extract features inserted, deletesd and updated https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492804#M28004 <HTML><HEAD></HEAD><BODY><P>Are you using sde you could set up replication. <A href="http://desktop.arcgis.com/en/desktop/latest/manage-data/geodatabases/what-is-synchronization.htm" title="http://desktop.arcgis.com/en/desktop/latest/manage-data/geodatabases/what-is-synchronization.htm">What is synchronization?—ArcGIS Help | ArcGIS for Desktop</A></P></BODY></HTML> Mon, 09 Nov 2015 19:14:12 GMT https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492804#M28004 WesMiller 2015-11-09T19:14:12Z Re: How to extract features inserted, deletesd and updated https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492805#M28005 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what are the pros and cons of using SDE Synchronization versus running a script that extracts all inserts, updates and deletes and replicates them to other instances?</P><P></P><P>Thank you</P></BODY></HTML> Mon, 09 Nov 2015 19:35:23 GMT https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492805#M28005 JoseSanchez 2015-11-09T19:35:23Z Re: How to extract features inserted, deletesd and updated https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492806#M28006 <HTML><HEAD></HEAD><BODY><P>For sde sync there is an out of the box tool to handle synchronization. As for a script i've only seen one that does it by @Bruce Harold you can find it here <A href="https://community.esri.com/message/543207">Re: Python hashlib to compare shapefiles\feature classes</A> , for large data i would stick to the out of the box tool</P></BODY></HTML> Mon, 09 Nov 2015 19:50:16 GMT https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492806#M28006 WesMiller 2015-11-09T19:50:16Z Re: How to extract features inserted, deletesd and updated https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492807#M28007 <HTML><HEAD></HEAD><BODY><P>I can't say that one can somehow track a record that is deleted from a feature class as it won't be there tomorrow if it was deleted today, unless you had a copy of the feature class today and then compare it to tomorrows. </P><P></P><P>As for insertions and updates, if you add 2 date fields in your feature class and then enable Editor Tracking, then assign the create date field and the edit date field appropriately, then you should have a way of tracking when a record was created and/or edited.</P></BODY></HTML> Wed, 09 Dec 2015 04:35:28 GMT https://community.esri.com/t5/data-management-questions/how-to-extract-features-inserted-deletesd-and/m-p/492807#M28007 MikeCusi 2015-12-09T04:35:28Z