nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Connection & Query for versioned data?

ZacharyHart

When making a direct connection to eGDB tables via (for example) SSMS (Management Studio) for a GDB that has (traditional) versioning enabled, I'm querying an old version of the data. The data is post & reconciled to the default version daily.

If I look at the list of (default/Esri created) views and query against the same table via that view, I see the default version.

I am aware of the Esri created stored procedure for switching versions, but what is the version which querying the table, not via a view? I cannot see any way to determine which version state this table is other than that (based on editing dates) it is very old.

Trouver plus de publications taguées avec

Versioning

Accepted answers

All comments

George_Thompson

I am not sure you can determine that information based on querying just the base table. There may be edits that have not be compressed and pushed to the base table.

I would not query the base table (directly) to determine anything in terms of "current state" when it is versioned (traditionally).

I hope I am providing a response to your question. If not, let us know.

ZacharyHart

so does 'base table' represent the default version of the GDB?

The versions are post & reconciled to the default version daily and and compression is run weekly.

If I query say the top 10 records sorted by 'last_edited_date' descending, i'm seeing stuff from 2019 which would be the inception of this particular GDB.

George_Thompson

"Base table" does not equal or represent DEFAULT, unless it is not versioned or all the delta tables are empty.

Based on that example above, it could mean that those records have not ever been edited and / or there are still edits that have not compressed.

That would be the best reason to use the versioned view.

ZacharyHart

I should perhaps clarify: according to my query, the most recent edits in the base table show as circa 2019. Which would then mean none of the edits have been compressed?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.