topic Re: Traditional Versioning Replication with Edits to Base in Geodatabase Questions

Traditional Versioning Replication with Edits to Base

CodyPatterson — Thu, 15 Feb 2024 14:32:21 GMT

Hey All,

We view our data through SQL, and would like to replicate our Geodatabase one way to another geodatabase, how can we accomplish this while also being able to view our data from SQL as replication does not allow the moving of edits to the base?

Enterprise 11.2 geodatabase

Thanks in advance!

Cody

Re: Traditional Versioning Replication with Edits to Base

RobertKrisher — Thu, 15 Feb 2024 14:39:45 GMT

Even though the edits aren't moved to the base tables you can still query the data using SQL. You'll just need to use versioned views to query the data in default (or other versions). You can find examples of this technique in this page of the online help. These versioned views will do the hard work of joining together all the edits in the base, adds, and delete tables to show you the correct rows.

Re: Traditional Versioning Replication with Edits to Base

CodyPatterson — Thu, 15 Feb 2024 14:53:00 GMT

Hey @RobertKrisher

Thank you for the response! I was also curious if you knew, we found that the database when traditionally versioned without moving to base, it has a SDE_STATE_ID, in what case would that state ID change?

Thanks again!

Cody

Re: Traditional Versioning Replication with Edits to Base

RobertKrisher — Thu, 15 Feb 2024 15:08:15 GMT

@CodyPatterson As soon as something is traditionally versioned it will get an SDE_STATE_ID field (regardless of whether edits are moved to base) and this value is used along with several system-maintained tables to manage all the edits in default and versions. If you just use the versioned views, you don't need to worry too much about what's happening behind the scenes (because the views handle it all for you).

There are several technical articles out there that explain this process (and the waters can get pretty deep on this stuff)

Here's a good introduction to traditional versioning: Versioning 101 - ArcUser Technical Article - Esri Community

Here's a description of the system tables: ArcGIS Help 10.1 - Versioned tables in a geodatabase in SQL Server

Re: Traditional Versioning Replication with Edits to Base

CodyPatterson — Thu, 15 Feb 2024 16:13:57 GMT

Hey @RobertKrisher

I think that answers most of my questions, I appreciate the resources greatly!

Cody

Re: Traditional Versioning Replication with Edits to Base

RobertKrisher — Thu, 15 Feb 2024 16:14:42 GMT

@CodyPatterson glad I was able to help!