I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL.

LINQPad is not an option (although it's great for learning Linq). It can only query database (and has many cons for my needs). I am looking for management/alteration functionality also, not only making queries and viewing the results.

  • Could you elaborate a bit more on "why" you're looking for an alternative? Different OS? Just hate SSMS? – Chris_K May 5 '10 at 18:03
  • I use HeidiSQL for MySql and the experience is not comparable to SSMS. I do the same thing quicker and easier in HeidiSQL for MySQL then in SSMS for MS SQL Server. In development industry we use such words as lightweight vs cumbersome to express this kind of difference without the need of enumerating the differences feature by feature. That why I think, that "lightweight alternative" should be enough :) – JohnM2 May 5 '10 at 20:08
  • Thanks for the tip on HeidiSQL -- I hadn't found that one yet and look forward to trying it out soon. – Chris_K May 6 '10 at 14:19

Have a look at Quest Software's Toad for SQL Server. Free!

Toad ™ for SQL Server Freeware is a tool that improves the productivity of developers and administrators by providing an easy-to-use development environment.

With Toad, developers and database administrators can use a familiar, proven tool to manage SQL Server databases. Quest Software has an established track record for proven solutions that simplify, automate and improve the quality of application and database development. You can rely on Quest to provide you with an intuitive, graphical tool with all the features required to satisfy your growing SQL Server needs.


Not the answer you're looking for? Browse other questions tagged or ask your own question.