I am using SQL Server server database contains lat/lon values and using this information I have created the shapefiles and published on server...

When I get the update say 100 records then I need to recreate the shapefile 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!

  • 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

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".


  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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