Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices Previous Releases

315968
0
08-28-2019 04:41 PM
MarceloMarques
Esri Regular Contributor
0 0 315K

MCS Enterprise Databases Best Practices - Current Release

ArcGIS Help Guide Books Previous Releases

*Guide books are available in the ArcMap Help beginning with ArcGIS 10.2 release.

________________________________________________________________________________________________

Table of Contents

An Esri ® Technical Reference Document • 2022

________________________________________________________________________________________________

Guide Books Previous Releases

The guide books are intended for database administrators to help establish the product workspaces in an Enterprise Geodatabase.

________________________________________________________________________________________________

ArcGIS Pro 2.x

Note: Roads and Highways, Pipeline Referencing, GeoEvent, Indoors, Aviation, Nautical customers can follow the same best practices in the Production Mapping Guide Books

ArcGIS Pro 2.x

    Production Mapping & Defense Mapping - Topographic Mapping
Production Database
         Best Practices Production Mapping 2.x Workspace in Oracle® February, 2019
         Best Practices Production Mapping 2.x Workspace in SQL Server® February, 2019
         Best Practices Production Mapping 2.x Workspace in PostgreSQL® March 2020

    Data Reviewer
      Best Practices Data Reviewer 2.x Workspace in Oracle® February, 2019
      Best Practices Data Reviewer 2.x Workspace in SQL Server® February, 2019
      Best Practices Data Reviewer 2.x Workspace in PostgreSQL® March 2020

    Workflow Manager
      Best Practices Workflow Manager 2.x Workspace in Oracle® February, 2019
      Best Practices Workflow Manager 2.x Workspace in SQL Server® February, 2019
      Best Practices Workflow Manager 2.x Workspace in PostgreSQL® March 2020

________________________________________________________________________________________________

ArcMap 10.8

Note: Roads and Highways, Pipeline Referencing, GeoEvent, Indoors, Aviation customers can follow the same best practices in the Production Mapping Guide Books

ArcMap 10.8 Feb 20, 2020
  Production Mapping      
    Production Database       
      Best Practices Production Mapping 10.8 Workspace in Oracle®        
      Best Practices Production Mapping 10.8 Workspace in SQL Server®        
      Best Practices Production Mapping 10.8 Workspace in PostgreSQL®      
    Product Library        
      Best Practices Product Library 10.8 Workspace in Oracle®        
      Best Practices Product Library 10.8 Workspace in SQL Server®        
      Best Practices Product Library 10.8 Workspace in PostgreSQL®   
  Data Reviewer     
    Best Practices Data Reviewer 10.8 Workspace in Oracle®     
    Best Practices Data Reviewer 10.8 Workspace in SQL Server®     
    Best Practices Data Reviewer 10.8 Workspace in PostgreSQL®   
  Workflow Manager     
    Best Practices Workflow Manager 10.8 Workspace in Oracle®     
    Best Practices Workflow Manager 10.8 Workspace in SQL Server®     
    Best Practices Workflow Manager 10.8 Workspace in PostgreSQL®   
  Bathymetric Solution (BIS) - Maritime
    Best Practices Bathymetry Solution (BIS) 10.8 Workspace in Oracle®     
    Best Practices Bathymetry Solution (BIS) 10.8 Workspace in SQL Server®
  Nautical Solution (NIS) - Maritime
    Best Practices Nautical Solution (NIS) 10.8 in Oracle®
    Best Practices Nautical Product Library 10.8 in Oracle®
    Best Practices Nautical Solution (NIS) 10.8 in SQL Server®
    Best Practices Nautical Product Library 10.8 in SQL Server®

ArcMap 10.7

ArcMap 10.7 Mar 19, 2019
  Production Mapping      
    Production Database       
      Best Practices Production Mapping 10.7 Workspace in Oracle®        
      Best Practices Production Mapping 10.7 Workspace in SQL Server®        
      Best Practices Production Mapping 10.7 Workspace in PostgreSQL®      
    Product Library        
      Best Practices Product Library 10.7 Workspace in Oracle®        
      Best Practices Product Library 10.7 Workspace in SQL Server®        
      Best Practices Product Library 10.7 Workspace in PostgreSQL®   
  Data Reviewer     
    Best Practices Data Reviewer 10.7 Workspace in Oracle®     
    Best Practices Data Reviewer 10.7 Workspace in SQL Server®     
    Best Practices Data Reviewer 10.7 Workspace in PostgreSQL®   
  Workflow Manager     
    Best Practices Workflow Manager 10.7 Workspace in Oracle®     
    Best Practices Workflow Manager 10.7 Workspace in SQL Server®     
    Best Practices Workflow Manager 10.7 Workspace in PostgreSQL®   
  Bathymetric Solution (BIS) - Maritime
    Best Practices Bathymetry Solution (BIS) 10.7 Workspace in Oracle®     
    Best Practices Bathymetry Solution (BIS) 10.7 Workspace in SQL Server®
  Nautical Solution (NIS) - Maritime
    Best Practices Nautical Solution (NIS) 10.7 in Oracle®
    Best Practices Nautical Product Library 10.7 in Oracle®
    Best Practices Nautical Solution (NIS) 10.7 in SQL Server®
    Best Practices Nautical Product Library 10.7 in SQL Server®

ArcMap 10.6

ArcMap 10.6 Jan 09, 2018
  Production Mapping      
    Production Database       
      Best Practices Production Mapping 10.6 Workspace in Oracle®        
      Best Practices Production Mapping 10.6 Workspace in SQL Server®        
      Best Practices Production Mapping 10.6 Workspace in PostgreSQL®      
    Product Library        
      Best Practices Product Library 10.6 Workspace in Oracle®        
      Best Practices Product Library 10.6 Workspace in SQL Server®        
      Best Practices Product Library 10.6 Workspace in PostgreSQL®   
  Data Reviewer     
    Best Practices Data Reviewer 10.6 Workspace in Oracle®     
    Best Practices Data Reviewer 10.6 Workspace in SQL Server®     
    Best Practices Data Reviewer 10.6 Workspace in PostgreSQL®   
  Workflow Manager     
    Best Practices Workflow Manager 10.6 Workspace in Oracle®     
    Best Practices Workflow Manager 10.6 Workspace in SQL Server®     
    Best Practices Workflow Manager 10.6 Workspace in PostgreSQL®   
  Bathymetric Solution (BIS) - Maritime   
    Best Practices Bathymetry Solution (BIS) 10.6 Workspace in Oracle®     
    Best Practices Bathymetry Solution (BIS) 10.6 Workspace in SQL Server®
  Nautical Solution (NIS) - Maritime
    Best Practices Nautical Solution (NIS) 10.6 in Oracle®
    Best Practices Nautical Product Library 10.6 in Oracle®
    Best Practices Nautical Solution (NIS) 10.6 in SQL Server®
    Best Practices Nautical Product Library 10.6 in SQL Server®

ArcMap 10.5

ArcMap 10.5 Jun 22, 2017    
  Production Mapping      
    Production Database        
      Best Practices Production Mapping 10.5 Workspace in Oracle®        
      Best Practices Production Mapping 10.5 Workspace in SQL Server®        
      Best Practices Production Mapping 10.5 Workspace in PostgreSQL®      
    Product Library        
      Best Practices Product Library 10.5 Workspace in Oracle®        
      Best Practices Product Library 10.5 Workspace in SQL Server®        
      Best Practices Product Library 10.5 Workspace in PostgreSQL®   
  Data Reviewer     
    Best Practices Data Reviewer 10.5 Workspace in Oracle®     
    Best Practices Data Reviewer 10.5 Workspace in SQL Server®     
    Best Practices Data Reviewer 10.5 Workspace in PostgreSQL®   
  Workflow Manager     
    Best Practices Workflow Manager 10.5 Workspace in Oracle®     
    Best Practices Workflow Manager 10.5 Workspace in SQL Server®     
    Best Practices Workflow Manager 10.5 Workspace in PostgreSQL®   
  Bathymetric Solution (BIS) - Maritime
    Best Practices Bathymetry Solution (BIS) 10.5 Workspace in Oracle®     
    Best Practices Bathymetry Solution (BIS) 10.5 Workspace in SQL Server®
  Nautical Solution (NIS) - Maritime
    Best Practices Nautical Solution (NIS) 10.5 in Oracle®
    Best Practices Nautical Product Library 10.5 in Oracle®
    Best Practices Nautical Solution (NIS) 10.5 in SQL Server®
    Best Practices Nautical Product Library 10.5 in SQL Server®

ArcMap 10.4

ArcMap 10.4 February 25, 2016    
  Production Mapping      
    Production Database        
      Best Practices Production Mapping 10.4 Workspace in Oracle®        
      Best Practices Production Mapping 10.4 Workspace in SQL Server®      
    Product Library        
      Best Practices Product Library 10.4 Workspace in Oracle®        
      Best Practices Product Library 10.4 Workspace in SQL Server®   
  Data Reviewer     
    Best Practices Data Reviewer 10.4 Workspace in Oracle®     
    Best Practices Data Reviewer 10.4 Workspace in SQL Server®   
  Workflow Manager     
    Best Practices Workflow Manager 10.4 Workspace in Oracle®     
    Best Practices Workflow Manager 10.4 Workspace in SQL Server®   
  Bathymetric Solution (BIS) - Maritime
    Best Practices Bathymetry Solution (BIS) 10.4 Workspace in Oracle®     
    Best Practices Bathymetry Solution (BIS) 10.4 Workspace in SQL Server®
  Nautical Solution (NIS) - Maritime
    Best Practices Nautical Solution (NIS) 10.4 in Oracle®
    Best Practices Nautical Product Library 10.4 in Oracle®
    Best Practices Nautical Solution (NIS) 10.4 in SQL Server®
    Best Practices Nautical Product Library 10.4 in SQL Server®

ArcMap 10.3

ArcMap 10.3 September 9, 2014    
  Production Mapping      
    Production Database        
      Best Practices Production Mapping 10.3 Workspace in Oracle®        
      Best Practices Production Mapping 10.3 Workspace in SQL Server®      
    Product Library        
      Best Practices Product Library 10.3 Workspace in Oracle®        
      Best Practices Product Library 10.3 Workspace in SQL Server®   
  Data Reviewer     
    Best Practices Data Reviewer 10.3 Workspace in Oracle®     
    Best Practices Data Reviewer 10.3 Workspace in SQL Server®   
  Workflow Manager     
    Best Practices Workflow Manager 10.3 Workspace in Oracle®     
    Best Practices Workflow Manager 10.3 Workspace in SQL Server®   
  Bathymetric Solution (BIS) - Maritime
    Best Practices Bathymetry Solution (BIS) 10.3 Workspace in Oracle®     
    Best Practices Bathymetry Solution (BIS) 10.3 Workspace in SQL Server®
  Nautical Solution (NIS) - Maritime
    Best Practices Nautical Solution (NIS) 10.3 in Oracle®
    Best Practices Nautical Product Library 10.3 in Oracle®
    Best Practices Nautical Solution (NIS) 10.3 in SQL Server®
    Best Practices Nautical Product Library 10.3 in SQL Server®

ArcMap 10.2

ArcMap 10.2 December 26, 2013    
  Production Mapping      
    Production Database        
      Best Practices Production Mapping 10.2 Workspace in Oracle®        
      Best Practices Production Mapping 10.2 Workspace in SQL Server®      
    Product Library        
      Best Practices Product Library 10.2 Workspace in an Oracle®        
      Best Practices Product Library 10.2 Workspace in an SQL Server®   
  Data Reviewer     
    Best Practices Data Reviewer 10.2 Workspace in Oracle®     
    Best Practices Data Reviewer 10.2 Workspace in SQL Server®   
  Workflow Manager     
    Best Practices Workflow Manager 10.2 Workspace in Oracle®     
    Best Practices Workflow Manager 10.2 Workspace in SQL Server®   
  Bathymetric Solution (BIS) - Maritime
    Best Practices Bathymetry Solution (BIS) 10.2 Workspace in Oracle®     
    Best Practices Bathymetry Solution (BIS) 10.2 Workspace in SQL Server®
  Nautical Solution (NIS) - Maritime
    Best Practices Nautical Solution (NIS) 10.2 in Oracle®
    Best Practices Nautical Product Library 10.2 in Oracle®
    Best Practices Nautical Solution (NIS) 10.2 in SQL Server®
    Best Practices Nautical Product Library 10.2 in SQL Server®

________________________________________________________________________________________________

An Esri ® Technical Reference Document • 2022

________________________________________________________________________________________________

About the Author
| Marcelo Marques | Principal Product Engineer | Esri | Cloud & Database Administrator | OCP - Oracle Certified Professional | 30 years experience | www.linkedin.com/in/mmarquesbr | I have worked with Esri Technology since 1992 and I have been working with Enterprise Geodatabases since 1997 when the Geodatabase was first released. | " a successful Enterprise ArcGIS application deployment starts with a strong physical database design and best database administration practices" | " I do not fear computers. I fear the lack of them." - Isaac Asimov |