
	Home > SQL Server Tips > Database Development > SQL Server freebie: TOAD for SQL Server

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE DEVELOPMENT

SQL Server freebie: TOAD for SQL Server

Serdar Yegulalp, Contributor
11.10.2005
Rating: --- (out of 5)

Expert advice on database administration

Digg This! StumbleUpon Del.icio.us

Most SQL Server development is done using SQL Server Enterprise Manager or Query Analyzer. The former provides a nice, hierarchical view of the entire server and its attendant database objects, but has many limitations. The latter provides the power of a command line, but is strictly for experts only since it provides nothing like a query builder or object explorer.

Quest Software Inc.'s TOAD for SQL Server was written to address many of these problems and solve a few others for good measure. TOAD is a development environment for SQL Server that also works as an object explorer, dependency checker and object manager.

The interface is patterned loosely after Microsoft Visual Studio. One can explore several servers and databases at once through a tabbed interface; another layer of tabs lets you explore the different types of objects in each database. An additional tab brings you to the Toad Online portal, which provides program tips and information about the full version of the product.

When you bring up a table (or any other object), you can explore all the properties of that table through a set of tabs: columns in the table, the data itself, constraints, triggers and object dependencies in both directions. You can also generate scripts for the object ...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server Tools and Utilities
	Microsoft SQL Server Tools Guide
	How SQL Server 2008 components impact SharePoint implementations
	SQL Server Mailbag: Data restoration and DB property management
	SQL language crash course (just enough to be dangerous)
	Setting up SQL Server Service Broker for secure communication
	Microsoft SQL Server 2008 Resource Governor primer
	The sqlcmd utility in SQL Server
	Performance analysis tools for SQL Server
	Software security tools to improve your skills in a single day
	Surface Area Configuration and other security tools in SQL Server 2005

SQL Server Database Modeling and Design

Optimizing SQL Server indexes –- even when they're not your indexes

Top tips and tricks for SQL Server database development

Managing the development lifecycle with Visual Studio Team System 2008

A first look at Visual Studio Team System 2008 Database Edition

Testing transaction log autogrowth behavior in SQL Server

Top 10 SQL Server Tips of 2008

Tutorial: SQL Server indexing tips to improve performance

Tutorial: Learn SQL Server basics from A-Z

SQL Server database design disasters: How it all starts

Can you shrink your SQL Server database to death?

Database Development

Speed up reports in SQL Server Reporting Services with caching

Data Transformation Services vs. SSIS: The key differences

Working with IntelliSense in SQL Server 2008 Management Studio

Top tips and tricks for SQL Server database development

Managing the development lifecycle with Visual Studio Team System 2008

Processing XML files with SQL Server functions

A first look at Visual Studio Team System 2008 Database Edition

How to create a SQL inner join and outer join: Basics to get started

New datetime data types in SQL Server 2008 offer flexibility

Using DATEADD and DATEDIFF to calculate SQL Server datetime values

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

ACID (SearchSQLServer.com)

data aggregation (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

with many different options (to check for the object's existence, object permissions, foreign and primary keys, etc.). The Object Search function lets you find any object by name, regardless of what it is or which database it may be in.

The free version of TOAD is fully functional, but it expires after 90 days and must be reinstalled. The commercial version includes advanced features such as tuning and modeling functions, a powerful stored procedure debugger and more. A single-seat license is $470 and includes a year of maintenance.

About the author: Serdar Yegulalp is editor of the Windows Power Users Newsletter. Check it out for the latest advice and musings on the world of Windows network administrators -- and please share your thoughts as well!

More information from SearchSQLServer.com

Article: Free download expands features for SQL Server 2005

Tip: Free SQL Server monitoring with event forwarding

RSS: Sign up for our RSS feed on database development

Rate this Tip
To rate tips, you must be a member of SearchSQLServer.com. Register now to start rating these tips. Log in if you are already a member.

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

SQL Server Development - .NET, C#, T-SQL, Visual Basic

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy