Best practices for organizing ArcSDE data?

MatthewGerbrandt — Thu, 04 Aug 2011 15:22:32 GMT

Hello, folks. We're going to be moving to a new ArcSDE server soon and I was hoping for some guidance as to the best practices for organizing ArcSDE data.

We've been using the multi-database model of organzing data for about 7 years and I'm starting to get the impression that this method of organizing ArcSDE data is no longer the standard practice.

I've unsucessfullly searched for docmentation on the best practices for data organization and was hoping for some advice. If you were to set up a new ArcSDE server tomorrow, how would you organize the data and why?

Thank you very much for your time and advice!

Re: Best practices for organizing ArcSDE data?

MatthewGerbrandt — Thu, 04 Aug 2011 19:47:42 GMT

It looks like I've answered my own question. Here are a couple of links to articles about managing data in ArcSDE:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q0000000s000000.htm

http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/using_mu769895119.htm

Favorite quote:

�??The multiple spatial database model of a geodatabase in SQL Server was how ArcSDE geodatabases in SQL Server were initially implemented. Though this model is still supported, ESRI recommends you use the single-spatial database model, in which all geodatabase tables are stored in one SQL Server database.�?�
model.�?�

So it looks like that�??s the direction we�??ll be going.

If anyone disagrees with this approach, I'd be curious to hear why. I hope this info helps someone.

topic Re: Best practices for organizing ArcSDE data? in Data Management Questions

Best practices for organizing ArcSDE data?

Re: Best practices for organizing ArcSDE data?