Toad for SQL - Worth it?
-
I'm doing my budget requests and I was looking at Toad for SQL. I'm currently playing with the trail version but I have to write up my request ASAP so I was wondering if anyone here is/was a user. Is it worth it? I'm a programmer who's untrained as a DBA but who is now functioning as a DBA as well as a programmer (without training of course). I've searched around for reviews but I can only find sales pitches for the freebie version. And any other SQL tool suggestions are welcome :) Thanks! (Sorry if this is the wrong forum for this post, it seemed like the best one since it's not a technical/programming question).
-
I'm doing my budget requests and I was looking at Toad for SQL. I'm currently playing with the trail version but I have to write up my request ASAP so I was wondering if anyone here is/was a user. Is it worth it? I'm a programmer who's untrained as a DBA but who is now functioning as a DBA as well as a programmer (without training of course). I've searched around for reviews but I can only find sales pitches for the freebie version. And any other SQL tool suggestions are welcome :) Thanks! (Sorry if this is the wrong forum for this post, it seemed like the best one since it's not a technical/programming question).
I can't really see the point, Enterprise Manager, Query Analyzer and Management Studio are all pretty good. TOAD makes sense against Oracle because the supplied tools are woeful, but SQL Server has never had that problem. The only things really missing are difference tools for which I recommend Red Gate's SQL Compare[^] and SQL Data Compare[^]. I think we picked up one license of an older version of the SQL Toolbelt[^]. If you're using SQL Server 2005 Express Edition start by downloading the free SQL Server Management Studio Express[^].
DoEvents: Generating unexpected recursion since 1991 -
I can't really see the point, Enterprise Manager, Query Analyzer and Management Studio are all pretty good. TOAD makes sense against Oracle because the supplied tools are woeful, but SQL Server has never had that problem. The only things really missing are difference tools for which I recommend Red Gate's SQL Compare[^] and SQL Data Compare[^]. I think we picked up one license of an older version of the SQL Toolbelt[^]. If you're using SQL Server 2005 Express Edition start by downloading the free SQL Server Management Studio Express[^].
DoEvents: Generating unexpected recursion since 1991Thanks for the info! Too bad, I like the skinning options.