Why use a file geodatabase

Question

When I have data I want retained, is there a reason to keep it stored in a file geodatabase vs our Enterprise geodatabase? For example, when there is a Demo of a house in our city we delete the address point.  My predecessor wanted to keep record of those deletes so he created a file geodatabase to recreate the address point in the "Deleted" database and removed the actual address point from the Enterprise db.  Wouldn't it be better to have that "Deleted" feature in our Enterprise Database or better yet, just extend the Address Point feature to have a Deleted column?  I'm very new to GIS and trying to understand what was done before I got here.

VinceAngelo · Answer

@SteveCole wrote: You cannot edit an enterprise SDE feature class with a basic ArcGIS license level.

This is not completely true. There are a number of ways to access/maintain  tables and rows in an EGDB that don't require a Standard or Advanced license (for example, a Portal survey could start data upload, without even a Basic license).

And with Standard/Advanced, you can do a number  of tasks in a PostgreSQL database without enabling it as an enterprise geodatabase.

_ v

evtguy · Answer

Another potential factor could be the license level that is available within your organization. You cannot edit an enterprise SDE feature class with a basic ArcGIS license level.

MobiusSnake · Answer

If you want to track history, Enterprise GDBs have functionality called Archiving which lets you roll back to view historical snapshots, you can enable this on specific feature classes or tables that you want to maintain history for.