Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We're building our new enterprise database and it will include SQL server spatial (native) data (moved from ArcSDE). This is great news for our SQL analysts who will now be able to consume our spatial data in their queries without having to break off data and use it in ArcGIS.

My question: is SQL Server Management Studio (SSMS) the only client that can connect to and use the SQL server spatial tables and functions? Or is there another lightweight client out there (SQLite, etc.) that can get the job done?

I'm also looking at how users can create their own local views of queries / spatial queries for use in charting in Excel, etc.

share|improve this question

closed as off-topic by swasheck, Aaron Bertrand Jul 26 '13 at 20:05

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – swasheck, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

swasheck and Aaron Bertrand... you can see what I'm getting at from this question. If you have a better place I could ask it, please let me know. –  mapBaker Jul 26 '13 at 20:07
I don't know that there is a place in the StackExchange network; shopping list questions are out of scope just about everywhere here, because it's impossible to retain a "correct" answer for any decent period of time. Frankly an independent search is probably going to be more reliable, but it's possible folks might spot your question in the meantime and add comments with current recommendations. –  Aaron Bertrand Jul 26 '13 at 20:11
I would like questions like this to have a place here. The date the answer is posted of course informs the usefulness of answers to these (and many other queries) –  Paul Jul 29 '13 at 14:43
Thanks, Paul!!! –  mapBaker Jul 29 '13 at 19:19