AnsweredAssumed Answered

transfer of Microsoft SQL statement to a statement that can be run against our SDE database

Question asked by ChrisWhittaker_SSWater on Jun 28, 2018
Latest reply on Jul 2, 2018 by ChrisWhittaker_SSWater

Hi,

 

we are migrating to a backend Microsoft SQL database and I have constructed a number of SQL statements like :

 

SELECT valvetype, count (VALVETYPE) FROM ssw_gis.valve
WHERE administrativearea= 'SST'
GROUP by VALVETYPE

 

The statement below gives me a count of valvetypes that have been migrated across from a legacy system to an eSRI solution so that we can balance both systems during the transformation.

 

As a stop gap before we directly send the data into our Microsoft tables we are creating a SDE database locally.

 

The question I have is there a way of copy and pasting the Microsoft SQL I have scripted that is going direct to the database into ARCMAP or ARC Catalog to generate the counts of items. If not then is there a way of remapping my Microsoft scripts to run direct in any of these ESRI Apps ?

Attachments

Outcomes