<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Bell MT";
panose-1:2 2 5 3 6 3 5 2 3 3;}
@font-face
{font-family:"Tempus Sans ITC";
panose-1:4 2 4 4 3 13 7 2 2 2;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>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. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>1.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>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. <o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>2.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>How many connections does it support? – 3 concurrent connections <o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>3.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>How many concurrent editors does it allow? – 1 editor at a time<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>4.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Is it also limited to 4 GB or 10 GB depending on the version of SQL Express being used? - Yes, the m<span lang=EN>aximum database size of 10 GB per database in SQL Server 2008 R2 (4 GB for SQL Server Express 2008 and earlier)</span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>5.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Has anyone had success using it? Several folks reported using it successfully. See below<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'> <o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>Tripp,</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>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. </span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'><span style='color:#1F497D'>1.</span><span style='font-size:7.0pt;font-family:"Times New Roman","serif";color:#1F497D'> </span><span style='color:#1F497D'>It does support distributed GeoDatabase replication (various types) two way, check out or one way through the versioning environment. </span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'><span style='color:#1F497D'>2.</span><span style='font-size:7.0pt;font-family:"Times New Roman","serif";color:#1F497D'> </span><span style='color:#1F497D'>Not sure how many connections it supports, I haven’t used it with multiple editors but I have used multiple checkouts concurrently with success.</span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'><span style='color:#1F497D'>3.</span><span style='font-size:7.0pt;font-family:"Times New Roman","serif";color:#1F497D'> </span><span style='color:#1F497D'>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.</span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'><span style='color:#1F497D'>4.</span><span style='font-size:7.0pt;font-family:"Times New Roman","serif";color:#1F497D'> </span><span style='color:#1F497D'>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.</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>Backups seem to work fine and XML Workspace exports usually work. SQL backups work if someone else is using SQL Server. </span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>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.</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><b><span style='color:#365F91'>Mark Dietrich</span></b><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'> </span><b><span style='color:#365F91'>| P.G. | GISP | GIS/Geodatabase Designer </span></b><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>URS Corporation</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>1625 Summit Lake Drive, Suite 200, Tallahassee, FL 32317</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'>850.402.6382 Direct | 850.509.1488 Mobile</span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'><a href="mailto:Mark.Dietrich@us.com">Mark.Dietrich@us.com</a> | <a href="http://www.urscorp.com/">www.urscorp.com</a></span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Hi<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>Jessie Dyer<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>GIS Specialist<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>Red Cedar Gathering<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><b><i><span style='font-size:12.0pt;color:black'>Tripp Corbin, MCP, CFM, GISP</span></i></b><b><span style='font-size:12.0pt;color:black'> </span></b><span style='font-size:12.0pt;color:black'>| Chief Executive Officer</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><br></span><b><span style='font-size:18.0pt;font-family:"Times New Roman","serif";color:#244061'><a href="http://www.egisassociates.com/"><span style='color:#244061;text-decoration:none'>eGIS Associates, Inc.</span></a></span></b><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><a href="mailto:tcorbin@egisassociates.com">tcorbin@egisassociates.com</a> | <a href="www.egisassociates.com">www.egisassociates.com</a> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>678-710-9710 ext 21 | 866-</span><span lang=EN style='color:#244061'>304-3864 Fax</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Esri Certified Trainer | Esri Certified Desktop Associate</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:black'><o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Robert LeClair [mailto:rleclair@esri.com] <br><b>Sent:</b> Tuesday, January 15, 2013 2:14 PM<br><b>To:</b> tcorbin@egisassociates.com<br><b>Subject:</b> RE: Question concerning Personal SDE GDB<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D'>Hi Tripp – <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><br>To answer your questions: <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in'>1.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Does it support two way replication with an Enterprise or Workgroup Geodatabase? <span style='color:#1F497D'>Personal SDE geodatabases support two way replication.</span><o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>2.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>How many connections does it support? <span style='color:#1F497D'>Personal SDE geodatabases support 3 concurrent connections.<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in'>3.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>How many concurrent editors does it allow? <span style='color:#1F497D'>Of the 3 concurrent connections, only 1 can edit at any given time.<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in'>4.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Is it also limited to 4 GB or 10 GB depending on the version of SQL Express being used? <span style='color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in'>5.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Has anyone had success using it<span style='color:#1F497D'>? 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.<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in'><o:p> </o:p></p><p class=MsoNormal>Hope this helps!<o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Tempus Sans ITC";color:#1F497D'>-Robert<o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0000CC'><o:p> </o:p></span></b></p><p class=MsoNormal><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0000CC'>Robert LeClair</span></b><i><span style='font-size:8.0pt;color:#0000CC'> </span></i><b><span style='font-size:8.0pt;color:#0000CC'>| </span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0070C0'>Instructor, CTT+</span></b><span style='font-family:"Bell MT","serif";color:#1F497D'><br></span><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:gray'>Esri <b>|</b> One International Court <b>|</b> Broomfield, CO 80021</span><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0000CC'><br></span><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:gray'>T 303-449-7779 x8225 <b>| </b>M 208-283-6630 <b>| </b>F 303-449-8830<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:gray'><a href="mailto:rleclair@esri.com">rleclair@esri.com</a> <b>|</b> esri.com</span><span style='font-family:"Bell MT","serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <a href="mailto:owner-gisco@lists.colorado.edu">owner-gisco@lists.colorado.edu</a> [<a href="mailto:owner-gisco@lists.colorado.edu">mailto:owner-gisco@lists.colorado.edu</a>] <b>On Behalf Of </b>Tripp Corbin<br><b>Sent:</b> Tuesday, January 15, 2013 10:24 AM<br><b>To:</b> 'gisco@lists.colorado.edu'<br><b>Subject:</b> Question concerning Personal SDE GDB<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Good afternoon everyone<o:p></o:p></p><p class=MsoNormal>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. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So I want to know the following:<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>1.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Does it support two way replication with an Enterprise or Workgroup Geodatabase?<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>2.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>How many connections does it support?<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>3.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>How many concurrent editors does it allow?<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>4.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Is it also limited to 4 GB or 10 GB depending on the version of SQL Express being used?<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in'>5.<span style='font-size:7.0pt;font-family:"Times New Roman","serif"'> </span>Has anyone had success using it?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b><i><span style='font-size:12.0pt;color:black'>Tripp Corbin, MCP, CFM, GISP</span></i></b><b><span style='font-size:12.0pt;color:black'> </span></b><span style='font-size:12.0pt;color:black'>| Chief Executive Officer</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><br></span><b><span style='font-size:18.0pt;font-family:"Times New Roman","serif";color:#244061'><a href="http://www.egisassociates.com/"><span style='color:#244061;text-decoration:none'>eGIS Associates, Inc.</span></a></span></b><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><a href="mailto:tcorbin@egisassociates.com">tcorbin@egisassociates.com</a> | <a href="www.egisassociates.com">www.egisassociates.com</a> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>678-710-9710 ext 21 | 866-</span><span lang=EN style='color:#244061'>304-3864 Fax</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Esri Certified Trainer | Esri Certified Desktop Associate</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";color:black'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>