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?

closed as too localized by Jon Seigel, Max Vernon, Mark Storey-Smith, Paul White says GoFundMonica, 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.

  • 1
    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
  • 1
    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... facebook.com/DataModelerTool or here... plus.google.com/108968161662966473138 – Carter Medlin Feb 13 '14 at 3:18

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.


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

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