AnsweredAssumed Answered

Parcel Fabric Versioned Views (SQL Server)

Question asked by crombezk on Jun 27, 2018
Latest reply on Jul 5, 2018 by andrescastillo08

We work in a versioned environment using SQL server back end.

Whenever you 'register a table as versioned' a versioned view is created that sees everything the default version sees.

These views in SQL Server will either have _VW or _evw at the end of the table name depending on the release of the ArcGIS Enterprise database.

 

My question is why these views do not exist for the Parcel Fabric?

Is there any way to perform a direct SQL Query on the default version without doing some sort of elaborate join with the business table and the add and delete tables?

I am mostly concerned with the parcels table.

 

I realize that a compress will update the business table.

But it seems that some nights even though my reconcile, post, compress, index and analyze script runs without failure, the edits are not always visible in the business table the next morning.

 

Thanks,

Kathleen

Outcomes