Introduction to storing the Production Mapping workspace in SQL Server (Production Mapping)

An Esri Production Mapping workspace contains the data you are using for production tasks, such as creating and updating features. Depending on the data model you are using, data in a Production Mapping workspace can be used to create a digital or hard-copy map/chart or a specific type of data. The data in a Production Mapping workspace usually corresponds with a data model and product class in the product library, but not always.

This guide book is intended for database administrators as recommendations for establishing the workspace in an enterprise geodatabase in SQL Server. The enterprise geodatabase uses ArcSDE technology as the gateway between geographic information system (GIS) clients and SQL Server.

ArcSDE service software installation

Connections to enterprise geodatabases use direct connections by default, but the ArcSDE application service is required if you want to connect to your geodatabase using the ArcSDE service connections. Direct connections are recommended.

If you will only be using direct connections and don't want the administration command line tools, ArcSDE installation isn't required.

If you want to install the ArcSDE application service or the administration command line tools, you need to download the ArcSDE installation files for your database management system and operating system from the Esri Customer Care portal. It may be useful to install the ArcSDE administration command line tools to perform certain advanced configuration operations.

For more information on ArcSDE services, see What is an ArcSDE service.

SQL Server installation

Before starting this guide book, install SQL Server 2008 R2 on a Windows operating system. The default settings for the SQL Server database management system work well with ArcSDE. Configure the instance to accept remote connections.

When you install SQL Server, be sure to install Full-Text Search.