SQL Server Management Studio alternatives to brows

Question

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.

Closed 7 years ago.

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.

Answer 1

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!

Answer 2

There is an express version on SSMS that has considerably fewer features but still has the basics.

Answer 3

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:

• Intellisense that actually works when using multiple tables and joins with aliases
• Suggestion of joins when using multiple tables (reduces time on typing, really neat)
• Rich formatting of sql code, AutoIndent using Ctrl K, Ctrl D.
• Better representation of SQL plans
• Highlights variables declarations while they are used.
• Table definition on mouse hover.

All these features have saved me lot of time.

Answer 4

Database .NET

Answer 5

vim + dbext :)

Answer 6

powershell + sqlcmd :)