We have a regular need to update feature classes within a geodatabase with new data. This takes the following approach:
Add the QA_ feature class
Data Management Tools > Features > Delete Features
Drag in the data you want to load from ArcCatalog
Data Management Tools > General > Append
Set Schema to NO_TEST
We repeat this process 20-50 times.
Is there a way to automate this?
Solved! Go to Solution.
Yes. Write a Python script and schedule it to execute every 30min (decide time based on your requirement) using Windows Task Scheduler.
One suggestion: If you are deleting all records from the feature class, use the Truncate Table tool. That will be much faster.