Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 2 down vote favorite

I am using sql server data base contains lat/lon values and using this information I have created the shape files and published on server..

When I get the update say 100 records then I need to recreate the shape file and merge it to (previous one) like this I am doing daily for last few days.. It is difficult to do daily for all records..

So is there any workaround?? I am using ArcGIS Desktop 10.1 and ArcGIS Server 10.1+ MS sql database 2008 r2

Any help will be great!! thanks in advance : )

share|improve this question
Why create a shapefile? - why not pull the data directly from MS SQL 2008? Do you have ArcSDE? – Mapperz♦ Nov 6 '12 at 14:19
@Mapperz Thanks for your reply.. I dont have ArcSDE..I am using 10.1 version for Desktop & Server – Sunil Nov 6 '12 at 14:57
are your lat/lon values in SQL server in a geography or geometry column? – Kirk Kuykendall Nov 6 '12 at 18:00
@Krik Kuykendall.. We are using Geography column. – Sunil Nov 6 '12 at 19:20
@Krik thanks...so Today I got 500 records and I have updated the database similarly its showing in ArcMap 10.1 but not in REST Service.. (After that I overwrite previous map service and then its displaying the records) So do I need to overwrite service every time ?? why its not updating the records automatically in ArcGIS Server ??..Currently I am going through 10.1 web help.. – Sunil Nov 8 '12 at 8:06

1 Answer

up vote 2 down vote accepted

If you do not have ArcSDE then you can try the ODBC (Open Database Connectivity)

enter image description here

Important part:

Goto Start -> and in the search bar type ODBC. right and click on "Use as Administrator".

http://www.code2learn.com/2011/07/microsoft-sql-server-2008-connection.html

share|improve this answer
thanks for your reply..I will try it and let you know.. thanks once again.. – Sunil Nov 7 '12 at 6:52
thanks for your idea.. I have tried and it worked successfully.. thanks : ) – Sunil Nov 10 '12 at 6:23

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.