Personal SDE

9905
11
04-15-2010 01:28 PM
SteveMlinarich
New Contributor
I'm trying to get information on the Personal SDE. Could anyone direct me to some info on it?

Thanks!
0 Kudos
11 Replies
VinceAngelo
Esri Esteemed Contributor
For what kind of information are you looking?

A search on "Personal ArcSDE" at www.esri.com returns 308 documents, many of which
would appear to be useful. 

The documentation also covers this topic:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n00000007000000.htm

-V
0 Kudos
DerekLaw
Esri Esteemed Contributor
Just wanted to add onto Vince's post:

1. ESRI Instructional Podcasts:
http://www.esri.com/news/podcasts/instructional_series.html

The following podcasts discuss Personal ArcSDE (aka. ArcSDE for SQL Server Express), suggested listening order:

- Introduction to Bundled Database Servers
- Installing ArcSDE for Microsoft SQL Server Express
- Creating Desktop and Workgroup Geodatabases
- Administering and Maintaining Desktop and Workgroup Geodatabases

2. ArcUser article: Just Rightâ??Geodatabases Designed for Medium to Small Organizations
http://www.esri.com/library/reprints/pdfs/arcuser_geodatabase.pdf

Hope this helps
StormwaterWater_Resources
New Contributor III
On Esri's "Replication Types" help page they say: 
However, if you are using an ArcGIS for Desktop Standard license to edit the child replica's data, consider using personal ArcSDE as the target geodatabase.
  It all sounds good, until you go to search on "personal ArcSDE" (WITH the quotes).  I can't find anything current.  I looked over the DVD files, and I don't see any documentation.  The links in this very old thread are 404.  Suggestions?
0 Kudos
VinceAngelo
Esri Esteemed Contributor
A search on "Personal ArcSDE" (without quotes) in the upper search box returns 3000 plus
documents if you update to the "All Collections" search filter.

- V
0 Kudos
StormwaterWater_Resources
New Contributor III
update to the "All Collections" search filter.


How do I do this?  You said the upper search bar, so I'm assuming you mean the "Search the forums" field.  I'm not seeing anything obvious.

More importantly though, I don't want a forum.  I want an Esri help page where I can get some basic information about what they are, how they are licensed, what they are used for (vs other GDBs), and how they are created or installed.

In this particular case I'd prefer that you give me the fish rather than teaching me to fish.  Can you give me a specific link to a basic description of a Personal ArcSDE DB?

The problem with the forums is all I'm seeing (when I use Search the forums on Personal ArcSDE with no quotes, but presumably NOT updating to All Collections, but still returning 1500 hits) is discussions of Personal Geodatabases where SDE is mentioned, and the few hits with Personal ArcSDE are unsolved problems (at least on the first page of 25 entries).  I want an Esri help page with the title: Personal ArcSDE.

Thank you in advance.
0 Kudos
VinceAngelo
Esri Esteemed Contributor
Once you're on the Search Results page, the left side has a column entitled "Search Filters".
if you click on "All Collections" you get all documents (3270 just now). "Help" will pull up
just Help documents (1730 results).

I doubt there is a page just on "Personal ArcSDE"; the "Types of Geodatabases" page is as
close as I've seen (it's not a big topic because it's exactly the same as Workgroup ArcSDE,
but with fewer license seats).

- V
0 Kudos
MarcoBoeringa
MVP Regular Contributor
More importantly though, I don't want a forum.  I want an Esri help page where I can get some basic information about what they are, how they are licensed, what they are used for (vs other GDBs), and how they are created or installed.
...
The problem with the forums is all I'm seeing (when I use Search the forums on Personal ArcSDE with no quotes, but presumably NOT updating to All Collections, but still returning 1500 hits) is discussions of Personal Geodatabases where SDE is mentioned, and the few hits with Personal ArcSDE are unsolved problems (at least on the first page of 25 entries).  I want an Esri help page with the title: Personal ArcSDE.


About Personal ArcSDE (also called "Desktop Geodatabase" or "ArcSDE Personal Server" in some documents by ESRI):

I fully agree this is badly documented, but on the other hand, once you realize there is actually no real distinction between Personal, Workgroup, and Enterprise Geodatabases, except a licensing scheme determining the maximum no. of concurrent users for the geodatabase (Vince may protest here, but for the sake of this thread, I think it valid), it actually turns out to be surprisingly simple:


*** STEPS TO INSTALL "PERSONAL ARCSDE / DESKTOP GEODATABASE" ***
(E.g. with "ArcGIS for Home Use" license based on "ArcGIS for Desktop Advanced")

* EDIT: * It may be advisable to reboot in between / after some of these steps, e.g. installing SQL Server, so as to ensure all services are properly running and usable for the next step.

1) - Install SQL Server 2012 Expresss

I am not going to detail all steps of the SQL Server installation here, use the Microsoft documentation if in doubt. Basically, you can choose almost all defaults, as the 2012 version of SQL Server installation already sets it all up under restricted Windows accounts, so rather safe. The defaults will install "extra's" like the Reporting Services that aren't necessary for the functioning of an ESRI Geodatabase, so you may prefer to opt out on these "software developer / SDK options" of the installation.

NOTE: you can also use the ArcGIS for Desktop 10.2 installation to install SQL Server 2008 R2 Express, as it is included in the desktop installer, but since I guess you will want to use the "latest", install 2012.

2) - Create a new instance in the process of the installation of SQL Server. Record the name of the instance for later use.

3) - Ensure you are logged in as a full Windows Administrator on your PC.

This is very important, if you don't do this, the enabling of the database for geodatabase storage may fail. Make sure this administrative login is also registered with your SQL Server Express if you haven't already done so during the install of SQL Server Express (which is usually the case, so you can probably skip this).

4) - Start the ArcGIS for Desktop 10.2 installation.

NOTE: Yes, you need the installation for ArcGIS for Desktop, not ArcGIS for Server. So you can use the installation that is part of the 10.2 Desktop Advanced "ArcGIS for Home Use" program. It is downloadable from the Customer Care portal once you receive your license from ESRI.

5) - Once in the main screen, choose ArcSDE for Microsoft SQL Server 2008 R2 Express as the installation option.

NOTE: don't worry: it won't automatically overwrite or re-install your SQL Server 2012 Express, see next steps.

6) - Once the install wizard appears, choose Next

7) - In the next dialog that appears (Installation Options), deactivate the Microsoft SQL Server Express Edition option, since you already installed it in step 1). Leave the Enable geodatabase storage on SQL Server Express checked. You want your database to be enabled to use ESRI Geodatabases.

😎 - Click Next

9) - In the Choose a SQL Server Instance and add a Windows login dialog, choose under SQL Server instance name your instance created in step 1), e.g. YOUR_COMPUTER_NAME\YOUR_INSTANCE. Add a valid Windows Login who will administer the geodatabase, e.g. YOUR_COMPUTER_NAME\YOUR_LOGIN_NAME. Note the YOUR_COMPUTER_NAME, since we are using Personal ArcSDE on SQL Server Express, your local PC is likely the server.

10) - Click Next and finish the installation. You can also close the ArcGIS for Desktop installation window now, as you no longer need it. Your database should now be enabled for creating geodatabases

11) - To create a geodatabase, DON'T USE THE "Create / Enable Enterprise Geodatabase" TOOLS!!!

I can not emphasize this enough. As the name of the tools already indicates, these tools only work against "enterprise" databases, not on SQL Server Express!

12) - To create an ESRI Geodatabase on SQL Server Express, simply create a new Database Server(!) connection to the SQL Server instance in ArcCatalog using the Add Database Server option under Database Servers in the Catalog Tree of ArcCatalog.

NOTE: I wrote Database Server, not Database Connection. You must first create a Database Server connection, as only a Database Server connection contains the context menu option to create a New Geodatabase, as in step 13).

13) - Now right click the new Database Server connection, and choose New Geodatabase from the context menu.

Yes, it is that simple! No hassle with an authorization file as in the "Create / Enable Enterprise Geodatabase" tools. The authorization of ArcSDE Personal Server forms an integral part of your ArcGIS for Desktop license, and was applied in steps 4) to 10).

NOTE 1: In order for this step to work, you must have an ArcGIS for Desktop Standard or ArcGIS for Desktop Advanced license. This doesn't cost you anything extra with an ArcGIS for Home Use license, it is just another licensing scheme you need to activate / authorize from the ArcGIS Administrator included with ArcGIS for Desktop. In Desktop Basic the New Geodatabase option is disabled in the context menu.

NOTE 2: After you have created the geodatabase via the Database Server connection, you can now also use the Add Database Connection option in ArcCatalog, to create a new Database Connection to your geodatabase.


Congratulations, you have just created your Personal ArcSDE / Desktop Geodatabase in SQL Server 2012 Express!
VinceAngelo
Esri Esteemed Contributor
there is actually no real distinction between Personal, Workgroup, and Enterprise Geodatabases, ...


There is no technical difference between Personal/Desktop and Workgroup geodatabases,
but Enterprise geodatabases are different, in creation, in capabilities, and in use.

- V
0 Kudos
MarcoBoeringa
MVP Regular Contributor
As a small testimony to the success of the described operation of enabling Personal ArcSDE / Desktop Geodatabase / ArcSDE Personal Server, see the attached screenshot showing the properties of the Database Server connection in ArcCatalog 10.2:
0 Kudos