Querying multiple SDE Databases

Discussion created by maduke06 on Jan 24, 2014
Latest reply on Nov 29, 2014 by xander_bakker
Our office has multiple SDE databases on an SQL server.  Each SDE database represents a County within our state and each County SDE Database has the same feature classes and attributes table parameters.

Is there an existing tool or a script that you use which will allow us to querry all of our county databases at one time for a specific attribute total or value?

Example:  We want to determine the total acrage of State Forest.  Each county database has a feature class called 'state_forest_area' and in that feature class is the attribute column for 'total_acres'.  What we would like the tool/script to do is access each County Database and pull the total acres from each 'state_forest_area' feature class and total them.  OR at the least, have an output of all the 'state_forest_area' records, then we could total them ourselves.