Migrating from older Query Analyzer (but not carrying the rest)
All, Introduction ============ As we know, a migration path for the old SQL Server 2000 Query Analyzer is to go to the SQL Server Management Studio (SSMS) for SQL Server 2005 or SQL Server 2008. But suppose I don't want hundreds of people installing that whole SSMS and those other features. All I really want is for my 500+ field folks to have a query tool for our production SQL Servers and I want to minimize cost and licensing. The database server side is where we spare no cost. Cost Effective ============== So, I took a look at SQL Server Express and SQL Server Management Studio Express. Sure they are free, but these products have way more than I want to put into the hands of 500+ field folks onto their laptops (because of too many potential Help Desk calls for non-essential actions). A Query Tool Solution??? ======================== So, is there not a query tool (i.e. "unbundled Query Analyzer") or do I have to take all the extras from the "Express" products, just so my 500+ users can do queries against the SQL Servers. OK. I'm not really interested in using their licensed Excel (on each laptop) to do an xquery via ODBC to the SQL Server. I'm looking for an "unbundle Query Analyzer" equivalent. Thanks for insights, Steve
You might look at RedGate SQL Prompt. Quest and I believe Idera also make similar products. Sapien also has some pretty good editors although I am not sure if they allow execution to a server through the software.
You should take a look at [Atlantis Interactive](
http://www.atlantis-interactive.co.uk/). They have a product called SQL Everywhere that might do the trick for you. Talk about cost effective, you can't beat the price. FREE!! If you end up using the tool give @matt whitfield a huge thanks for creating it.