I was wondering if there are any alternatives to Microsoft's SQL Server Management Studio?
Not there's anything wrong with SSMS, but sometimes it just seem too big an application where all I want todo is browse/edit tables and run queries.
This question is tagged with
~ Asked on 2008-08-07 19:06:03
I've started using LinqPad. In addition to being more lightweight than SSMS, you can also practice writing LINQ queries- way more fun than boring old TSQL!
~ Answered on 2008-08-07 20:31:12
TOAD for MS SQL looks pretty good. I've never used it personally but I have used Quest's other products and they're solid.
~ Answered on 2008-08-07 19:17:11
~ Answered on 2011-02-26 10:02:43
BTW. First URL is the home page of Joseph Albahari who is the author of LINQPad (check out this killer tool)
~ Answered on 2010-02-26 10:11:38
I have been using Atlantis SQL Enywhere, a free software, for almost 6 months and has been working really well. Works with SQL 2005 and SQL 2008 versions. I am really impressed with its features and keyboard shortcuts are similar to VS, so makes the transition really smooth to a new editor.
Some of the features that are worth mentioning:
All these features have saved me lot of time.
~ Answered on 2012-03-07 05:34:03
If you are already spending time in Visual Studio, then you can always use the Server Explorer to connect to any .Net compliant database server.
Provided you're using Professional or greater, you can create and edit tables and databases, run queries, etc.
~ Answered on 2008-08-07 23:47:57
There is an express version on SSMS that has considerably fewer features but still has the basics.
~ Answered on 2008-08-07 19:25:57
vim + dbext :)
~ Answered on 2011-10-05 16:29:29
Oracle has a free program called SQL Developer which will work with Microsoft SQL Server as well as Oracle & MySQL. When accessing SQL Server, however, Oracle SQL Developer is only intended to enable an easy migration to Oracle, so your SQL Server database is essentially read-only.
~ Answered on 2008-12-12 23:22:18
You can still install and use Query Analyzer from previous SQL Server versions.
~ Answered on 2008-12-12 23:17:16
How about Embarcadero Rapid SQL Really good but kind of expensive.
~ Answered on 2012-05-30 15:03:26