Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
    
Probably best to port MySQL to PostGRES and use ArcSDE from there. –  Mapperz Aug 22 '12 at 13:30
add comment

1 Answer

The MSSQL environment can use the ESRI geodatabase when it is in native SQL. So to set this up, instead of trying to add the supporting tables, begin by creating a new SDE database on a dev machine. You will have to use the SDE installer. Make sure this is DBO owned, and don't bother creating an instance (service). Make sure your keyword is set to create native SQL geometries instead of SDE binaries.

Using the Query layer method of adding data in ArcMap, connect to the SQL data base. Export that data into your new SDE geodatabase. Replace the prod database with the dev database. If you choose to use ESRI versioning, you will need to use stored procs to expose the versions to the MSSQL environment.

OR Use QGIS instead of ArcGIS as it can write to SQL natively.

share|improve this answer
    
Thanks, I am indeed (also) using QGIS on the model too, but am in a big and mixed environment with MapInfo, Arc, QGIS - you name it... I think I will try approaching the problem by sdelayer -o register, though in the end I might end up needing to create my own SDE-model instead :-| –  Greg Aug 30 '12 at 14:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.