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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just downloaded the freeware version of Toad for SQL Server. Toad's download site says: "the Freeware edition has certain limitations, and is not intended to be used as a TRIAL for the Commercial edition of Toad for SQL Server." It also says that no more than 5 people from my organization can use the freeware version, and that I'm not entitled to hard-copy documentation, phone assistance, tech support or upgrades.

Is the product fully functional besides that?

share|improve this question

closed as too localized by Jon Seigel, Max Vernon, Mark Storey-Smith, Paul White, Derek Downey Apr 5 '13 at 13:30

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Why would you want to use Toad over SSMS for SQL Server? I believe SSMS is free and unlimited for any edition of SQL Server. – Nick Chammas May 2 '12 at 5:54
I want to use it in addition to SSMS, not over SSMS. Toad has some useful utilities, including optimizing multiple sql statements in batch mode, recommending indexes, and testing for scalability under simulated user loads. See Toad for SQL Server Functional Matrix for a full list. – Head of Catering May 2 '12 at 12:51
I can't speak for the other features, but I know off the top of my head that starting in 2008 SSMS recommends indexes too. – Nick Chammas May 2 '12 at 15:14
Thanks, Nick. If the Toad freeware was fully functional, I'd probably use both. Since it isn't, I'll stick to SSMS. – Head of Catering May 2 '12 at 16:16
Try this tool for SQL Server Physical models. Info can be found here... or here... – Carter Feb 13 '14 at 3:18
up vote 3 down vote accepted

The Toad site has documentation on the limitations of Toad Data Modeler but not for Toad for SQL Server or Toad for Oracle. I found a blog post "I love the new Toad freeware!" on their site as well claiming that the new freeware is no longer "crippleware" the way it used to be.

I've used the tool for a few days now, and there are lots of menu options disabled, so no, the product is nowhere close to fully functional.

share|improve this answer
can you describe the data export options in the freeware version. – userJT Apr 2 '13 at 19:20
@user56, it's been almost a year since I stopped using the trial. I don't remember what data export options were available. – Head of Catering Apr 3 '13 at 4:32
Here is something that looks like a canonical link to a feature comparison matrix.… – LosManos Oct 3 '14 at 7:43
Here's an applicable comparison from Dell on ToadWorld:… – Abraham Oct 17 '14 at 23:42

No. The freeware version is limited.

However is it not too bad.

For example, data import and data export wizards are there fully. (only a templated export can not be defined (paid feature)).

share|improve this answer

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