Introduction to storing the Reviewer workspace in an enterprise geodatabase in SQL Server

ArcGIS Data Reviewer for Desktop, a data quality-control management application, requires that you have a workspace defined when using a Reviewer session to store the results found during your data review process. It creates a new feature dataset and tables in the geodatabase that you have identified as your Reviewer workspace. The feature dataset includes point, line, and polygon feature classes, which contain error geometries for the features that have been written to the Reviewer table. When stored in an enterprise geodatabase, the Reviewer workspace supports versioning.

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 about 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.