Select to view content in your preferred language

SQL Query to get all Records from a versioned geodatabase

1067
3
11-24-2016 09:24 PM
BhargavaRam
Emerging Contributor

Does anybody know the query to get the latest of ALL records in a versioned SDE geodatabase (including records from the add and delete (A&D) tables? I'm specifically looking for SQL Server.

0 Kudos
3 Replies
Asrujit_SenGupta
MVP Regular Contributor

Instead of querying the Feature Classes or Tables, try to pull the updated data from the Versioned views. Versioned view will show data from the Base\Business Tables and the Delta Tables both, which is what you need.

BhargavaRam
Emerging Contributor

Thanks Gupta for quick response.

Versioned views holds the data only after the versions are  "reconcile & post" to default.

Is there any query/method to get the all the records before i post it to default?  

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor