I have an existing MSSQL2008R2 database with views each containing a single geometry field along with a big number of "attributes".
I would like to be able to do INSERTS, UPDATES, and DELETES on these views in an ESRI environment. As viewing the data is not enough, I suspect that the new methods for adding MSSQL-stored datasets to ArcMAP is not enough (they only read data as far as I can see).
I am imagining something like adding supporting tables for ArcSDE - would you reckon that is possible, and if so how would you reckon one could do that?
I have read that ESRI have reduced the number of metadata tables in the new ArcSDE, so I hope that I will somehow be able to add those - either using SDE or by hand - to my existing model, as the primary (non-ESRI) software still needs to operate on the same database.
Cheers,
Greg