Select to view content in your preferred language

Show database version number in database connection properties

400
3
01-30-2023 08:17 AM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

It would be helpful if the database version number could be shown in the database connection properties in ArcGIS Pro (or a similar location). For example: Oracle 18c.

I'm aware that I can query the database directly for that information using an SQL client. But not all computers/users have an SQL client. So it would be better if we could see that information right in ArcGIS Pro.

Example use case: The user needs to know what the database version is so that they can know what SQL will be valid when writing a definition query, query layer, etc.

Could that functionality be added?

Thanks.

3 Comments
George_Thompson

You can see this currently in the ".sde" connection file properties, under the "Upgrade Status" section:


George_Thompson_0-1675096337229.png

 

*Note - I also tested with a non-SDE connection file and was able to see the same thing.

Is that what you are looking for?

Updated - I am using Pro 3.0.3

Bud
by

@George_Thompson 11.0.0.3.0 looks like the geodatabase version number, not the PosrgreSQL database version number. 

I’m looking for the database version number, such as PostgreSQL 13.6 or Oracle 18c.

George_Thompson

Ah, ok. Thanks for that clarification.

I have not seen that one in the connection properties. That would be a great enhancement request to add.