idea Show database version number in database connection properties in ArcGIS Pro Ideas

Show database version number in database connection properties

Bud — Mon, 30 Jan 2023 16:18:49 GMT

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.

Re: Show database version number in database connection properties

George_Thompson — Mon, 30 Jan 2023 16:34:35 GMT

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

*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

Re: Show database version number in database connection properties

Bud — Mon, 30 Jan 2023 17:01:57 GMT

@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.

Re: Show database version number in database connection properties

George_Thompson — Mon, 30 Jan 2023 17:23:53 GMT

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.