Refresh data in an existing Feature Class

Question

I have an existing Feature Class in the sde database. How do I refresh the information in the Feature Class using ArcCatalog? I want to replace the old data with new data.

VinceAngelo · Answer

This isn't so common a practice that it required a context menu option.  If you use the Truncate Table (Data Management) tool, you can empty the existing contents, so that a "Load -> Load Data..." option would work.

Note: If your shapefile is large (100k-250k+ rows), you will see significant execution time benefit from going into the feature class properties and dropping the spatial index after Truncate, but before load, then rebuilding the index afterwards (this is actually what the old command-line 'shp2sde' utility would do, and in fact is best practice when writing scripts).

I think the Truncate Table tool will require an exclusive lock, so the ArcGIS Server service(s) which access the table must be stopped before reloading.

- V

Edit: Added Note above

DaviKucharski · Answer

ArcGIS : 10.0.4400

ArcCatalog : 10, Service Pack 5

Geodatabase I believe is the same

RDBMS: SQL Server 2012

Refesh Source is a new shape file

User ArcCatalog means using the user interface of ArcCatalog. I was expecting to see an option, when I right click on the Feature Class,  to allow me to Import or Replace the existing information with new data. It seems all I have is a Load/Load Data option. I can pick my new shape file but it appears to append the new data into the Feature Class with no option to Replace.

VinceAngelo · Answer

Please provide:

* ArcGIS version,
* Geodatabase version (if different)
* RDBMS with version, 
* The "refresh" data source format, and
* Whether "using ArcCatalog" refers to just user interface tools, or includes Python or ArcObjects .Net and/or ArcObjects Java as well.

What to include in a GeoNet question