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.
There are quite a few ways to accomplish this, but some of them depend on version, database, and the "refresh" data source. Also involved:
Please restate your question in light of these needed details
- V
Vince,
Some history. I just right click on my Feature Dataset and click Import Feature Class (Single) to create this Feature Class. Currently, the class has around 16,000 records. The new data would jump that up to around 20,000. I don't know how many are different but at least around 4,000 are new. Some could have dropped out also. I do not believe the feature class is versioedn, or any foreign key relationships. The only thing we use this for is in an MXD file to supply data to one of our mapping services.
Hope this helps and let me know.
Please provide:
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.
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