topic determin geodatabase in Data Management Questions

determin geodatabase

JoshBowman1 — Thu, 20 Sep 2012 18:17:56 GMT

I am looking for assistance on how to find out what geodatabase version is running. I have been tasked with an upgrade to 10 project, but for the short term we need to do some client testing and in order to connect a 10.1 client I believe I need a 9.3 geodatabase or newer. I believe I am running 9.2 from errors I have seen, but I wanted to know if there's a definitive way to identify it. We are hosting our data on SQL Server 2005.

Thanks,
Josh

Re: determin geodatabase

Robert_LeClair — Thu, 20 Sep 2012 18:24:51 GMT

Josh -

One way is to open SQL Server Management Studio and open the geodatabase in question (Databases tab -> Geodatabase -> Tables and Select (the Top 1000 rows) for the dbo.SDE_version repository table. The tables schema will have MAJOR, MINOR, BUGFIX, etc. The MAJOR is the release 9 or 10 for example and the MINOR is the dot release .3 or .1 for example.

Hope this helps!

Regards,

Robert LeClair
Esri-Denver

Re: determin geodatabase

JoshBowman1 — Thu, 20 Sep 2012 18:48:00 GMT

I confirmed my suspicious we're on 9.2 with that tip. Thanks much!

Re: determin geodatabase

KimPeter — Thu, 20 Sep 2012 23:39:08 GMT

Josh,

Also be aware that SQL Server 2005 isn't supported with 10.1 clients.

'>http://resources.arcgis.com/en/help/system-requirements/10.1/#/Microsoft_SQL_Server_Database_Requirements/015100000070000000/

http://resources.arcgis.com/en/help/main/10.1/#/Compatibility_when_connecting_directly_from_ArcGIS_clients_to_geodatabases_in_SQL_Server/002q000000n9000000/