Quest Software Toad for SQL Server is a software program that targets servers and it provides database administrators with the tools to improve the efficiency of their daily tasks. With this tool, engineers can configure multiple SQL server connections and browse the database content.
It comes wrapped in a modern UI, that has a nice mixture of blue nuances, properly crafted buttons, and well-delimited page sections.
With Quest Software Toad for SQL Server, users can perform a wide variety of operations. It allows individuals to create complex scripts and execute them. Users can also run queries on more than one server or apply it to multiple connections.
More, it supports syntax highlighting and automatic code completion. Other embedded facilities allow users to extract objects, import and compare data into a certain database. Also, if you want to monitor background processes, you can use the Monitor tool.
All in all, Quest Software Toad for SQL Server is a reliable software program for managing multiple servers. It has a friendly interface and has lots of useful tools. However, its price is quite hefty, and sometimes when you try to load large files the application freezes.
v6.1 [Nov 13, 2013]
1. Object Explorer
- The Generate SQL | statement/script sub-menu now has a new option, Append To Editor. Use this command to add the generated SQL statement or script to the Editor at the location of your cursor within the Editor pane.
- The Tables tab now includes a Last Updated column. To display the column, right-click a column header and select Options | Extra Columns | Last Updated.
2. Object Management
- When detaching a database, Toad for SQL Server now includes the "SET SINGLE_USER" syntax in the script to put the database in single-user mode.
- You can now generate a Data Script from the Export menu. Select Tools | Export | Data Script. The Generate Data Script dialog opens for the select database.
- In the Alter Table dialog, the Columns page now supports multi-select on columns. Ctrl + click to select multiple columns. Then click the UP or DOWN arrows to move all selected columns.
3. Connection Manager
- You can now add parameters to a SQL Server connection in the Connection Properties dialog. Toad for SQL Server includes the application name parameter with value "Toad for SQL Server" by default. You can add additional parameters if needed.
4. Editor
- You can now easily select and execute the code within a single region of a script. In the Editor, right-click within the script region you want to execute and select Select Current Region. Then press F5 to execute the code.
- If you select the Include Actual Execution Plan option when executing SQL, in the Execution Plan window the tab now reads "Actual Plan" to indicate the actual plan is displayed. When the option is deselected, the tab reads "Estimated Plan" indicating the estimated plan is displayed.
- The SQL Server 2012 SQL statement CREATE SEQUENCE is now included in the Code Snippets.
Feature-rich relational database known for its high performance and excellent concurrency
Mall Creeps
