


With ArcGIS Desktop (ArcEditor and ArcInfo) and ArcGIS Engine, you can set up a database server and create ArcSDE geodatabases that can be accessed by a few users and edited by one user at a time. Once you have created the SQL Server Express instance and run the wizard to enable the instance to store geodatabases, the libraries within the client application allow you to connect to and work with the database servers and create and work with geodatabases on the database server. The media for these products include installation files for SQL Server Express. In this case, the client applications are ArcGIS Desktop at the ArcEditor or ArcInfo license level, ArcGIS Engine, and ArcGIS Server Workgroup. Performing the administration of the database server and its geodatabases through ArcGIS Desktop means there is no extra software or database administration expertise required for you to create and use these types of ArcSDE geodatabases.Ĭonnections to the geodatabases on a database server are always direct connections they use the ArcSDE library files in the client to make the connection. "You create geodatabases and perform other administrative tasks for database servers through the Database Servers node in the Catalog window or ArcCatalog. See also this post for a good explanation of the licensing and links about SDE and SQL Server Express ArcSDE desktop license See below - you can have 10 concurrent editing connections. No offense QGIS folks )Īlso, make sure that your Esri sales guy gives you a quote for "ArcGIS Server Workgroup", not Enterprise.

There lot's of documentation on how to do it, and you don't have to be a dba - though I like postgres.

Even though only one user can edit at a time, the locking and unlocking may be better - you might try this out first. If you have ArcEditor or ArcInfo desktop level, you have the ability to use SQL Server Express.
