topic Re: Desktop gdb vs File gdb -- Which one to use? in Data Management Questions

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

RichardHughes2 — Thu, 27 Jul 2017 20:04:20 GMT

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-e1c44fc0e01e&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=f99bc198-1016-4560-b47b-7977b691ea02&searchIndex=0‌

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

Asrujit_SenGupta — Fri, 28 Jul 2017 08:24:20 GMT

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

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

RichardHughes2 — Fri, 28 Jul 2017 12:16:03 GMT

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

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

Asrujit_SenGupta — Fri, 28 Jul 2017 12:23:23 GMT

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.

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

RichardHughes2 — Fri, 28 Jul 2017 12:54:38 GMT

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?

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

Asrujit_SenGupta — Fri, 28 Jul 2017 13:03:47 GMT

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

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

Asrujit_SenGupta — Fri, 28 Jul 2017 13:13:09 GMT

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

Check this as well...