Implementing Versioned Workflows in a Multiuser Geodatabase

Strictly by pre-registration only

What is this course about?

Efficiently maintain your enterprise data.

Learn a sound traditional versioning workflow that minimizes disruption to editors, ensures the integrity of your organization's GIS data, and integrates well with existing business workflows. This course (taught using ArcGIS Pro) explores a variety of versioned editing workflows for the enterprise geodatabase, including traditional versioned editing, nonversioned editing, and geodatabase replication. Discover best practices to achieve optimal performance while applying editing workflows that support your business needs.

Course details






3 days




Geodata Course

CPD points


Esri will provide the following software to use during class:

  • ArcGIS Pro (Standard or Advanced)
  • PostgreSQL

Are there any prerequisites?

What skills will I learn?

  • Design a traditional versioning workflow that meets your organization's needs.
  • Manage multiple geodatabase versions.
  • Implement one-way, two-way, and checkout replicas.
  • Monitor and maintain geodatabase performance in a traditional versioned editing environment.

What can I expect?

  • 1. Establishing the multiuser editing environment
    • Business needs
    • Editing workflow options
    • Choosing an editing workflow
    • Which editing workflow is best?
    • Geodatabase roles and tasks
    • How to select an editing workflow in ArcGIS
    • Exercise 1: Choose editing workflows
  • 2. Organizing versions
    • Defining a version
    • Version tree scenarios
    • Exercise 2: Organizing versions
  • 3. Edit isolation using delta tables
    • Nonversioned editing scenario
    • Registering simple data
    • Registering related data
    • Registering feature datasets
    • Edit isolation
    • Tracking edits
    • Exercise 3: Examine the delta tables
  • 4. Exploring versioning repository tables
    • SDE_STATES table
    • Representing versions
    • Exercise 4: Explore system table architecture
  • 5. Merging lineages through reconcile and post
    • Explicit reconcile and post
    • Performing an explicit reconcile and post
    • Merging protected lineages
    • Implicit (auto) reconcile and post
    • Exercise 5: Merge state lineages
  • 6. Reviewing conflicts
    • Defining a conflict
    • Conflict resolution
    • Would there be a conflict?
    • Exercise 6: Review and resolve conflicts
  • 7. Migrating edits to the base tables
    • Managing the state tree
    • Removing unreferenced records
    • Migrating edits to the base tables
    • Achieving a full compress
    • Exercise 7: Compress the geodatabase
    • Migrating edits to the base tables by disabling versioning
    • The move-to-base option
    • Developing a maintenance strategy
  • 8. Creating two-way replicas
    • Purpose of geodatabase replication
    • Preparing to create a two-way replica
    • Two-way replication scenario
    • Exercise 8: Create and manage a two-way replica
  • 9. Creating one-way replicas
    • Preparing for one-way replication
    • Scenario: One-way (parent-to-child) replication
    • Exercise 9: Create one-way replicas
    • Geodatabase archiving
    • Scenario: One-way (parent-to-child) archiving
  • 10. Creating check-out replicas
    • Check-out replication
    • Replica preparations
    • Scenario: Check-out/check-in
    • Exercise 10: Create a check-out replica
  • 11. Versioned editing with third-party apps
    • Creating versioned views
    • Querying with a versioned view
    • Editing the DEFAULT version
    • Editing other versions
    • Exercise 11: Explore versioned editing with non-Esri apps
  • 12. Implementing versioning in your own environment
    • Identifying business needs
    • Designing a version tree
    • Developing a maintenance plan
    • Policies and strategies