Select to view content in your preferred language

determin geodatabase

597
3
09-20-2012 11:17 AM
JoshBowman1
Emerging Contributor
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
0 Kudos
3 Replies
Robert_LeClair
Esri Esteemed Contributor
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
0 Kudos
JoshBowman1
Emerging Contributor
I confirmed my suspicious we're on 9.2 with that tip.  Thanks much!
0 Kudos