Are there any great tools as an alternative TOAD to be used for SQL Server?

The tool can be commerical or open source.

  • I agree with pritaeas. Navicat is great, I've been using it for a while now with all sorts of databases and it has never failed me. TOAD is a great tool though, but it lacks a good look and feel and so is a little bit tricky ot learn how to use. Despite this, it's query profiling tool is great. – ionutab May 24 '12 at 15:11
  • HeidiSQL (heidisql.com) supports MsSQL too. Never tried it for mssql but its the best tool available for MySQL – Imre L May 24 '12 at 15:44
  • Personally never felt like using any third party tools other than SSMS. It has been amazing all these years and is still going great. Why is that you want to use third party tools to work on MS SQL Server? – Shyam Viking May 25 '12 at 11:53
  • More userfriendly and increase productivity – What'sUP May 25 '12 at 14:04

Say TOAD for SQL Server? I dont't have experience with it, probably you have your reason asking for a replacement tool.


SQL Server Management Studio that comes with SQL Server?

If you need to run on non-Windows, then look at SQuireeL


Personally, I am a fervent user of Navicat. The Premium version allows connecting to multiple database servers. Am also very content with their support, already had several cases resolved, although sometimes it doesn't get in until the next version. (I am not affiliated with them.)


Although the Navicat UI is more polished, the feature set and extensible nature of Apex SQLEdit blows the doors off any other QA replacement I've found. Between replacement tokens, context sensitive custom scripts (i.e., right click a table and you're presented with a list of your own CUSTOM scripts specific to TABLES with token replacement), quick info, data mining right out of the result grid, sorting and filtering in grid, etc., etc.

At that point, you may as well keep SSMS, add RedGate SQL prompt (nice) and/or SSMS Tools (free/donate) to get only a pinch of what Apex offers.

Note, I have, in no way, explored Navicat features completely, just blown away by the apparent LACK of features during my first experience with the tool, especially where the rubber meets the road, query building and result grid features.

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