SQL Server Management Studio alternatives to browse/edit tables and run queries

Sql Server

Sql Server Problem Overview

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.

Sql Server Solutions

Solution 1 - Sql Server

I've started using [LinqPad][1]. In addition to being more lightweight than SSMS, you can also practice writing LINQ queries- way more fun than boring old TSQL!

[1]: http://www.linqpad.net/ "Linq Pad"

Solution 2 - Sql Server

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.

Solution 3 - Sql Server

Seems that no one mentioned Query Express (http://www.albahari.com/queryexpress.aspx) and a fork Query ExPlus (also link at the bottom of http://www.albahari.com/queryexpress.aspx)

BTW. First URL is the home page of Joseph Albahari who is the author of LINQPad (check out this killer tool)

Solution 4 - Sql Server

Database .NET

Solution 5 - Sql Server

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.

Solution 6 - Sql Server

powershell + sqlcmd :)

Solution 7 - Sql Server

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.

Solution 8 - Sql Server

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

Solution 9 - Sql Server

vim + dbext :)

Solution 10 - Sql Server

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.

Solution 11 - Sql Server

You can still install and use Query Analyzer from previous SQL Server versions.

Solution 12 - Sql Server

How about Embarcadero Rapid SQL Really good but kind of expensive.

Categories
Recommended Sql Server Solutions

Previous Solution:

Using ConfigurationManager to load config from an arbitrary location

asp.netConfigurationAsp Classic

Next Solution:

How to autosize a textarea using Prototype?

JavascriptHtmlCssTextareaPrototypejs

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionGateKillerView Question on Stackoverflow
Solution 1 - Sql ServerEvanView Answer on Stackoverflow
Solution 2 - Sql ServerbrendanView Answer on Stackoverflow
Solution 3 - Sql ServerPiotr OwsiakView Answer on Stackoverflow
Solution 4 - Sql ServerGovind MalviyaView Answer on Stackoverflow
Solution 5 - Sql Serveruser_vView Answer on Stackoverflow
Solution 6 - Sql ServerThuglifeView Answer on Stackoverflow
Solution 7 - Sql ServerDaniel OView Answer on Stackoverflow
Solution 8 - Sql ServerPaul GView Answer on Stackoverflow
Solution 9 - Sql ServersumekView Answer on Stackoverflow
Solution 10 - Sql Serveraef123View Answer on Stackoverflow
Solution 11 - Sql ServerdkretzView Answer on Stackoverflow
Solution 12 - Sql ServerpycckiView Answer on Stackoverflow