Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

The tool can be commerical or open source.

share|improve this question

closed as off-topic by Kin, Jon Seigel, Marian, Martin Smith, bluefeet Oct 23 '13 at 13:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Jon Seigel, Martin Smith, bluefeet
If this question can be reworded to fit the rules in the help center, please edit the question.

    
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 –  FullMetalGame May 25 '12 at 14:04
add comment

5 Answers 5

up vote 3 down vote accepted

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

share|improve this answer
1  
Related: dba.stackexchange.com/q/17257/2660 –  Nick Chammas May 24 '12 at 14:35
add comment

SQL Server Management Studio that comes with SQL Server?

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

share|improve this answer
add comment

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.)

share|improve this answer
add comment

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.

share|improve this answer
add comment

Devart has a dbForge product line - a set of IDE's for developing, managing and administrating Oracle, SQL Server and MySQL databases.

SQL Server IDE: dbForge Studio for SQL Server

Oracle IDE: dbForge Studio for Oracle

MySQL IDE: dbForge Studio for MySQL

share|improve this answer
4  
I see you have given 4 answers across the Stack Exchange network and all of them mention this tool. You should state if you have any affiliation with the product. –  Martin Smith Oct 23 '13 at 13:03
    
It's just the answer to the question... I didn't find this tool among other answers and consider that this information may be usefull to users. –  Sergei Kharchenko Oct 24 '13 at 6:57
2  
I didn't say it isn't an answer to the question. I haven't downvoted or flagged as spam myself because the question does invite this kind of answer. But please see the FAQ. Specifically you must disclose your affiliation in your answers. –  Martin Smith Oct 24 '13 at 9:33
add comment

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