shrug-l: Question concerning Personal SDE GDB - Summary

Tripp Corbin tcorbin at egisassociates.com
Tue Jan 15 16:45:02 EST 2013


Thanks to everyone that answered including Robert LeClair, Mark Dietrich,
Jim Thomas, Jessie Dyer, Eric Buehler and Elaine Evans.  A few folks asked
me to post what I found out. Here is the long and short of it. 

 

 

1.      Does it support two way replication with an Enterprise or Workgroup
Geodatabase? - Yes, an ArcSDE personal geodatabase does support replication
for both an Enterprise and Workgroup SDE database.  

2.      How many connections does it support? - 3 concurrent connections 

3.      How many concurrent editors does it allow? - 1 editor at a time

4.      Is it also limited to 4 GB or 10 GB depending on the version of SQL
Express being used? - Yes, the maximum database size of 10 GB per database
in SQL Server 2008 R2 (4 GB for SQL Server Express 2008 and earlier)

5.      Has anyone had success using it? Several folks reported using it
successfully. See below

        

Tripp,

I've been using the SQL express 2008 version for about a year and a half on
a big project I'm working on in 10.0 and 10.1. 

 

1.      It does support distributed GeoDatabase replication (various types)
two way, check out or one way through the versioning environment. 

2.      Not sure how many connections it supports, I haven't used it with
multiple editors but I have used multiple checkouts concurrently with
success.

3.      I read that the SQL Express is limited to 4 GB per ESRI and
Microsoft documentation. Haven't tried to exceed that so far. I've run 3-4
Geodatabases on the same install with no problems.

4.      The editing is a bit temperamental, sometimes changes to the schema
don't always show up correctly in an ArcMap session or edits don't always
show up immediately for some operations. Usually occurs during long edit
sessions with multiple saves and the database seems to get lost. Doesn't
lose the data but things like the indexes seem to go stale. Exiting the
session and doing database maintenance of compressing, analyzing and
rebuilding indexes restores everything but gets tiresome. Domains seem to
work OK. Can go into SQL Server Management Studio and do some work on the
database behind the scenes with field names and orders. Views haven't worked
very well yet. Care must be taken if the current Geodatabase is versioned as
messing with the schema can cause grave problems.

 

Backups seem to work fine and XML Workspace exports usually work. SQL
backups work if someone else is using SQL Server. 

 

So it doesn't match an Enterprise database environment for editing but has
most of the core SDE functionality. For a small shop it can work but it is a
little more temperamental meaning you'll have to tweak it every once in a
while to keep it running and is cheaper than Oracle.

 

Mark Dietrich | P.G. | GISP | GIS/Geodatabase Designer 

URS Corporation

1625 Summit Lake Drive, Suite 200, Tallahassee, FL 32317

850.402.6382 Direct | 850.509.1488 Mobile

Mark.Dietrich at us.com | www.urscorp.com <http://www.urscorp.com/> 

 

Hi

I use a personal sde gdb. I have 2 instances of it set up. One is a backup
and for testing and the other is the production db. I can edit both
instances at the same time.

 

Jessie Dyer

GIS Specialist

Red Cedar Gathering

 

 

 

Tripp Corbin, MCP, CFM, GISP | Chief Executive Officer
 <http://www.egisassociates.com/> eGIS Associates, Inc.

tcorbin at egisassociates.com | www.egisassociates.com 

678-710-9710 ext 21 | 866-304-3864 Fax

Esri Certified Trainer | Esri Certified Desktop Associate

 

From: Robert LeClair [mailto:rleclair at esri.com] 
Sent: Tuesday, January 15, 2013 2:14 PM
To: tcorbin at egisassociates.com
Subject: RE: Question concerning Personal SDE GDB

 

Hi Tripp - 


To answer your questions:  

 

1.      Does it support two way replication with an Enterprise or Workgroup
Geodatabase? Personal SDE geodatabases support two way replication.

2.      How many connections does it support?  Personal SDE geodatabases
support 3 concurrent connections.

3.      How many concurrent editors does it allow?  Of the 3 concurrent
connections, only 1 can edit at any given time.

4.      Is it also limited to 4 GB or 10 GB depending on the version of SQL
Express being used?  Yes, 2005 SQL Server Express is 4 GB database limit and
2008 SQL Server Express R2 is 10 GB database limit.  For example, you can
have as many geodatabases as you want - they just cannot total more than 4
GB or 10 GB total.

5.      Has anyone had success using it?  I'm sure there are successful
folks out there but I've been teaching for Esri for 6+ years now so am
somewhat out of the production world.

 

Hope this helps!

 

-Robert

 

Robert LeClair | Instructor, CTT+
Esri | One International Court | Broomfield, CO 80021
T 303-449-7779 x8225 | M 208-283-6630 | F 303-449-8830

rleclair at esri.com | esri.com

 

 

From: owner-gisco at lists.colorado.edu [mailto:owner-gisco at lists.colorado.edu]
On Behalf Of Tripp Corbin
Sent: Tuesday, January 15, 2013 10:24 AM
To: 'gisco at lists.colorado.edu'
Subject: Question concerning Personal SDE GDB

 

Good afternoon everyone

I am trying to determine the limitations of the Personal SDE geodatabase
which comes with ArcGIS Desktop. I am trying to determine if it will work as
a possible solution for a client. I am very familiar with personal, file and
traditional ArcGIS Server GDB but never really used the Personal SDE and
Esri documentation seems a little vague. 

 

So I want to know the following:

1.      Does it support two way replication with an Enterprise or Workgroup
Geodatabase?

2.      How many connections does it support?

3.      How many concurrent editors does it allow?

4.      Is it also limited to 4 GB or 10 GB depending on the version of SQL
Express being used?

5.      Has anyone had success using it?

 

Tripp Corbin, MCP, CFM, GISP | Chief Executive Officer
 <http://www.egisassociates.com/> eGIS Associates, Inc.

tcorbin at egisassociates.com | www.egisassociates.com 

678-710-9710 ext 21 | 866-304-3864 Fax

Esri Certified Trainer | Esri Certified Desktop Associate

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20130115/059cd296/attachment.htm


More information about the SHRUG-L mailing list