Desktop gdb vs File gdb -- Which one to use?

736
6
07-27-2017 01:04 PM
Highlighted
Occasional Contributor III

Are there performance advantages to using the Database Server over a File Geodatabase?  The backup and restore ability with the Database Server is cool.  Is there anything else?  The idea of having a database in a database server for security is good, but is it really? 

Thanks,

Rich

https://community.esri.com/groups/geodatabase?sr=search&searchId=df45fbdd-daed-42d7-8faf-e1c44fc0e01...https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=f99bc198-1016-4560-b47b-7...

Reply
0 Kudos
6 Replies
Highlighted
MVP Regular Contributor

Choosing among these will depend upon what your organisation needs are.

Performance is something, which you will probably have to test for yourself. It will depend upon the type of data, amount of data and a lot many other factors. Generally speaking, if you won't be using too much data, you will probably observe File gdbs performing better than any SDE gdb.

Some of the other things to consider:

1. How much data will be loaded in the geodatabase (The Desktop gdb has a size limitation of 10GB per database, because the underlying Database is SQL Server Express)

2. How many editors will be editing simultaneously. (Only one user can edit at one given time in a Desktop gdb)

3. Are you planning to implement any functionality like Replication, Archiving, etc

I am branching this out as a separate question, as this a different question and so that others can also contribute with their opinions

Some previous discussions that you can check:

SDE or File Geodatabase 

Performance Metrics ArcSDE vs File Geodatabase 

https://community.esri.com/thread/45017 

Highlighted
Occasional Contributor III

Asrujit,

We are building a geodatabase that holds master data in a dozen feature datasets.  We are building a workflow for publishing to AGOL for Collector and are planning on implementing global ids to bring the data back into the master.  ArcServer is not part of our available software now so my two choices are file geodatabase or database server.  Neither of these will be able to be a parent in a replica or a version tree correct?  

Thanks,

Rich

Reply
0 Kudos
Highlighted
MVP Regular Contributor

The File gdb cannot be a Parent replica gdb, but the Desktop gdb can be.

The parent always has to be an SDE gdb ( Desktop gdb, Workgroup gdb or Enterprise Gdb). The child gdb can be a File gdb in some cases, depending upon the type of replica you choose to use.

Reply
0 Kudos
Highlighted
Occasional Contributor III

I've been looking through all of the online docs and don't seem to be able to either support or reject your statement about a Desktop gdb.  Does creating a replica using the Database Server on SQL Express require the enable enterprise geodatabase with a keycodes files?  

Reply
0 Kudos
Highlighted
MVP Regular Contributor

No, that is needed to create an Enterprise geodatabase.

Check this link on how to create a Desktop geodatabase:

Set up a database server—Help | ArcGIS Desktop 

Reply
0 Kudos
Highlighted
MVP Regular Contributor
Reply
0 Kudos