Sql navigator 5.5 keygen
Sql navigator 5.5 keygen
Welcome to Toad.
With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management and develop SQL more efficiently.
Toad also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.
New in This Release.
New Features in 6.6.
Test Data Generator.
Use the Test Data Generator to generate realistic test data to load into your databases.
To open the test data generator click File | New | Data Generator.
Create a Test Data Generator project.
Set the scope of the project by setting the Toad for SQL Server connection and database schema.
In the test data generator window.
Test data is generated for ticked tables and columns.
Select a table or column.
Set the settings for that selected table or column.
Preview and edit test data.
Generate test data.
Further configure and export.
The Background Processes pane now identifies the Query Builder or Editor document window (if any) associated with a running process. If you have multiple statements executing simultaneously, this makes it easier to match a running process to its associated document. Click the running process in the Background Processes pane to display the associated document window.
In addition, for each Query Builder or Editor document with an active background process, an animated progress icon displays in the window's tab. This allows you to quickly see which windows have executing statements.
Toad now provides a tool to help you analyze and visualize joins in the Query Builder or a Database Diagram. After building a query or a diagram, click the join between two tables in a diagram. Toad profiles the data based on the relationship between the tables and presents the information in a Venn diagram. Click a section of the diagram to view the values represented by that section.
The Venn diagram also indicates if a join is a Cartesian join. This gives you the opportunity to modify the join before executing the query.
You can now sort columns in a table diagram in the Query Builder. Right-click a table and select Sort . This is useful for finding a column when the table or view has a large number of fields.
View PDF Files in LOB Viewer.
You can now view PDF files in the LOB viewing pane in the Database Explorer, SQL Editor, or Query Builder. In the Data tab or Result Sets tab, in a LOB column, open the drop-down LOB viewing pane. If the LOB is a file, it is displayed in the PDF tab.
Throw Error Activity.
Automation includes a new activity that allows you generate an error and add a custom error message to the script execution log. In addition, you can instruct Toad to stop or continue after the error is logged. This can be useful if you want to terminate the script when a condition exists that would not normally cause an error.
Automation Reports and Container Activities.
In activities that allow you to select files created in previous activities in a script, reports generated in container activities are now visible in the File Collection Editor.
New Features in 6.5.
Health Checks, Spotlight™ Essentials and the Diagnostic Server.
Show health check results. Click Tools | Health Check.
Toad connections from the Connection Manager with health check results available are listed.
Connections needing the most attention are listed first. Click on the connection to open the System Health check page on the Spotlight Essentials web site. This provides a detailed analysis of the health checks performed.
A Spotlight Essentials account is required to check the health of your Toad connections. Registration is free.
Click Tools | Options | Spotlight Essentials | Setup Account.
Spotlight Essentials is an online service: Visit the web sit for a thorough analysis of all your connections.
The Diagnostic Server enables performance data from your Toad connections to be sent to your Spotlight Essentials account for analysis. The Diagnostic Server needs to be installed and configured.
Click Tools | Options | Spotlight Essentials | Configure Diagnostic Server.
Performance data is uploaded hourly to Spotlight Essentials - providing the Diagnostic Server is operational. You can check the current status of the Diagnostic Server from the Toad Status bar. Select Show Details on the status bar for the current status of the Diagnostic Server and possible solutions to any issues.
Spotlight Essentials - Configure Connections.
Manage the connections that upload data to Spotlight Essentials.
Click Tools | Options | Spotlight Essentials | Configure Connections.
This screen lists all the connections that are uploading performance data to Spotlight Essentials Add, remove and modify the connections on this screen. Note that this list of connections is stored with the Diagnostic Server. It is available only while the Diagnostic Server is connected and running. If you change the Diagnostic Server host then this list of connections will also change.
There is a simple way to add Toad connections from the Connection Manager to this list. In the Connection Manager . right click the Toad connection and select Add to Spotlight Essentials.
SQL Server 2014 Support.
SQL Server 2014 is supported for all existing functionality of Toad.
New Look User Interface.
Toad for SQL Server has a new look. This release includes a sleek new design for the main toolbar, as well as a few user interface enhancements designed to simplify your Toad workflow.
Main Toolbar: Large, easy-to-read icons make it easy to find and open your favorite Toad modules and tools.
Open Connections List: The Open Connections list has moved to the Connection/Navigation Manager pane.
Other Toolbars: For ease-of-use, individual module toolbars have moved to their respective windows. This keeps the Main Toolbar clean and display the functions you need only when you need them.
For example, the Query Builder toolbar now displays in the Query Builder window instead of the Main Toolbar.
Toad continues to provide maximum flexibility in the Toad workspace, of course. Move, float, and create new toolbars to fit your needs.
New Skins: Three new skins have been added: ToadBlue2014, ToadGreen2014, and ToadTan2014.
If you like the standard Toad skin, this look is still available. Go to Tools | Options | Environment | Interface and select the Default skin.
If you like the standard toolbar, this is still available, also. Right-click the Main Toolbar and deselect Use Large Icons.
Filtering database objects has several new enhancements.
When you enter a search string in the object filter field, the currently-specified Search Condition now displays in a blue banner below the field.
You can now specify a default Search Condition in Tools | Options | Explorer | General . If you don't specify a default, the field defaults to the search type you specified the last time you created or modified a filter (includes previous sessions.
The following new Search Conditions have been added: Contains (Exact), Starts With (Exact), and End With (Exact). Use these to include (in your text string) certain characters normally used in search logic, such as the underscore character (_.
The Connection/Navigation Manager now includes a search feature. Use incremental search to find connections quickly.
Zip/Unzip Activity: You can now unzip existing zip files using the Zip/Unzip activity (formerly the Zip activity.
New Features in 6.1.
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.
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.
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.
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.
New Features in 6.0.
Toad allows to run Schema Compare against multiple targets.
Specify Source and Target Databases page of the wizard was adjusted to allow source and target objects' selection within the same pane. Click Add to start selecting objects for comparison (snapshots or databases). Or you can drag drop objects from the Object Explorer.
Browse through the list of connections and check the objects you want to include in comparison. You can also assign colors and aliases for selected objects. Assigning aliases and colors is handy as helps easily distinguish targets.
To browse through the list of snapshots, select the Snapshots node and add a new snapshots' folder. Select the snapshots from the list, assign colors and aliases.
After specifying objects for comparison, the first one is automatically set as source. Click Set as source next to any object to make it source.
When reviewing multi-target comparison results, the columns at the right of the Objects pane display comparison status per target (source only, target only, different, etc.). The circle sign indicates that the object exists neither on source nor on selected target (while it is "target only" for another). The Targets pane gives you a tip what databases are compared and how they are ordered as columns in the Objects pane. The colored dots next to database names correspond to the colors selected in the Select Source and Targets page of the wizard.
To review object scripts in the Script pane select an object in the Objects pane and click on required target column (selected target column is highlighted). The colored lines at the left and right side of the Script pane correspond to the colors selected in the Select Source and Targets page of the wizard that make it easier to track what target script is currently being shown.
The Properties tab also provides information per selected source and target pair.
When synchronizing multiple targets, several synchronization scripts are built and you can switch between them using Targets pane in the Schema Synchronization window. To run synchronization for one or several targets click Execute script(s) . You will be prompted to explicitly select targets.
The information on databases and snapshots that you selected for comparison, aliases, colors, etc. is saved and stored within Schema Compare. The next time you open Schema Compare the wizard will be populated with your settings.
Data Diff Viewer.
Data Diff Viewer incorporated advantages of Data Compare. Right-click two tables in the Object and select Send to | Diff Viewer as Data . Or select Tools | Compare | Data Diff Viewer and drag drop tables to the pane. Also you can compare results sets from the Editor with right-click | Compare To | Set_number.
Toad automatically suggests column mapping and selects comparison key (primary or unique key), while you can map columns manually (according to their data types), include or exclude columns and add comparison keys.
After comparison, you can easily see the differences per record as Toad allows to organize columns of the source and target tables in pairs, highlights and marks them with "source only", "target only", "different" and etc. The toolbar at the top of the pane allows to filter, group and navigate through the records. The Row Viewer and Cell Viewer at the bottom show details for selected row or cell correspondingly.
Data Grid, Result Sets.
Toad allows to view multi-line text as one-line separated by spaces so that you can see all information contained in the grid right in front of you. Right-click a data grid and select Show | Multi-line text as one-line . When this option is cleared, to view multi-line text you have to hover a mouse over a data grid cell or expand it.
Foreign keys are now disabled instead of being dropped and recreated when inserting, updating or deleting data with synchronization script.
Text Diff Viewer was integrated into Cell Viewer and allows to see differences clearly.
Schemas are now extracted in parallel that significantly reduces comparison time.
Toad now allows to search through the script not only in the Editor window but also in SQL Script page of object's DOE (Database Object Editor) and Script tab in the object's DOV (Database Object Viewer). This feature can be handy when reviewing large automatically created DDL scripts. Press F3 or CTRL+F to invoke a search pane.
(SQL Server 2012) Toad allows to view databases configured for AlwaysOn support. Right-click a database in the Object Explorer, select Options | Extra Columns | Synchronization State or/and Availability Role.
Generate SQL submenu was reorganized. Now when you right-click an object and select Generate SQL you are offered to select a type of script to be generated (Create, Alter, Execute, etc.) first followed by To Editor / To Clipboard / To File options. The option you selected last time is remembered (and is marked with bold), so next time you can simply click straight on the type of script without having to select an option from the submenu.
WITH NOCHECK / CHECK syntax is available for the foreign keys and check constraints both in the DOE (Database Object Editor) and scripting. You can navigate to the Constraints page in the Table DOE and set a foreign key to "Trusted" . Trusted property is also shown for foreign keys in View Details | Constraints tab for Tables.
When generating execution script for the stored procedures to the Editor, SET @ parametername = statement is added for each declared parameter. This is handy when you have a lot of parameters declared and need to set them all manually. Just input parameter values without having to type SET statement every time.
When renaming a database you can select whether to keep backup and restore information or not. To omit it set Delete backup and restore information to True in the Rename Database DOE.
Toad allows to review generated script for TRUNCATE TABLE.
Toad provides possibility to import connections from Central Management Server. Now to add CMS connections to the Connection Manager pane you click Import Connections in the Connection Manager toolbar, select Central Management Server as import origin and specify connection from the list. Select Connections and Groups page of the Import Wizard displays a list of available connections, including CMS. You can either import the entire CMS Connections group or single connection.
Toad provides more security options when creating users in Contained databases (SQL Server 2012 only.
Service Broker has been completely redesigned and now can be configured for MS SQL Server 2005, 2008, 2008 R2, 2012. Service Broker allows to set up communication between databases on the same SQL Server instance or between SQL Server instances. Take advantage of secure, reliable messaging with Service Broker in Toad. Invoke Service Broker with Tools | Administer | Service Broker . select a database from the list and click Configure to enable Service Broker.
In the Endpoints tab you can either configure an endpoint for the current SQL Server instance or configure both source and target endpoints using the Transport Security Wizard.
To create Service Broker objects (e.g. message types, queues, notifications, etc.) select a corresponding tab in the lower part of the Service Broker window.
Storage Management has been significantly improved to become more user-friendly and easy-to-use. Select Tools | Administer | Storage Management to invoke it. In the Drives tab you can review information on free disk space and database parameters (size, total writes, total reads, etc). Click on the drive icon to see the list of databases located there. To move a database to another drive just drag it to drive's icon, specify new location on disk drive and follow the instruction in the pane below.
Toad Plug-in for Microsoft SQL Server Management Studio.
Toad provides a plug-in that integrates Toad features in Microsoft SQL Server Management Studio. Enjoy advantages of both products and ease of communication. Toad Plug-in is installed as a part of Toad for SQL Server installation process and supports the following versions of Management Studio.
Microsoft SQL Server Management Studio 2012.
Microsoft SQL Server Management Studio 2008 R2 SP2 or later.
Toad Plug-in allows to invoke key Toad features right from the Management Studio context menu and send data directly into Toad. Connection information and security settings are transferred automatically and Toad functionality is already up running.
According to the Toad Edition you run the following Toad features can be invoked from the Management Studio.
Importing and Exporting Data.
GO N syntax is supported. Add it to the end of your script to execute it N times.
Script generation has changed - fully qualified database names are now removed from tables, views, procedures and functions. This allows you to run scripts across multiple databases without having to adjust object names for each database. For example, if you have a production and test databases with identical structure and object names you can deploy the same script for both of them with just USE [ Database name ] statement.
(SQL Server 2012) Values now can be concatenated using CONCAT (value1, value2. valueN) syntax.
(SQL Server 2012) The following system functions are now supported.
Note: Review Microsoft documentation for more information on converting data types.
Toad recognizes and parses SQL more carefully and when you press F9 Toad now executes not all the statements in the current batch but exactly the selected statement. Write SQL as you are used to and do not be limited by necessity to use GO and etc. to separate statements. Toad will distinguish them for you.
Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
You can add XML declaration when saving XML data to file with a right-click in the Result Sets tab.
Schema Compare and Data Compare Activities.
Schema Compare and Data Compare Activities are now available as Database Activities in Automation.
Schema Compare and Data Compare activities allow to reuse comparison projects prepared in advance or run new comparison wizard right from the Automation. The interface for both activities is similar and easy-to-use.
When preparing an activity for automation you simply specify the comparison project, locations for report files and synchronization script. You can also select to execute scripts that will generated during data or schema comparison.
Automation button was added to the Data Compare and Schema Compare toolbar. After clicking this button you will be prompted to save your comparison project. Automation pane is invoked automatically and lists your project in Data or Schema compare file field.
This release of Toad for SQL Server includes many new enhancements to Automation variables. Automation variables are now more flexible and easier to use. Toad for SQL Server has expanded the number of places you can use variables in an Automation script.
When you create a new variable in Automation (using the Set Variable activity) you can now specify a variable type (String, Number, DateTime, Boolean, or SQL.
Built-in variables (variables specified by an activity, like the row-count variable) now have the same functionality and behavior as variables you create using the Set Variable activity.
You can use a built-in variable as a bind variable in a SQL statement.
You can include a built-in variable in the file name of an output file.
The format of the default name that Toad automatically assigns to all built-in variables has changed.
The name is composed of the activity’s name (which you can specify) and the variable’s purpose. So if you have an activity named SelectOrders, Toad now names this activity’s row-count variable SelectOrders_RCOUNT.
You can customize the name of a built-in variable if you don't want to use the default name.
Any bind variables stored in the Bind Variables dialog in Toad are now available to use in Automation. The stored bind variables are now accessible from the Variables list in the expression editors in Automation activities, and also in the Set value field in the Find and Replace activity (if Variable Value is selected.
For activities in which you can add a suffix to the output file, you can now select a variable from a previous activity or a bind variable stored in Toad for SQL Server to include as part of the suffix.
Formatting the value for a Date type variable is now easier.
The Date Functions list provided by the expression editor (in various activities) now includes more-flexible, easier to use functions.
You can now use a dash (-) in date/time formats used in Automation variables.
You can now use a colon (:) or a forward slash (/) in date/time formats used in Automation variables (except when the variable appears in a file name.
In applicable activities, Toad now limits the selection of variables to only those created in activities previous to the current activity.
In the Import Wizard and Export Wizard activities, you can now use a variable in the Import/Export template file name.
Loop Dataset Activity.
In the Loop Dataset activity, you can now select any previously created SQL-type variable to use as the dataset variable. For example, you can use the SQL variable from any Execute Script, Set Variable, or even another Loop Dataset activity that precedes the current activity.
The dataset variable in the Loop Dataset activity is now easier to use, and you no longer need to add a Set Variable activity to initialize and use the value stored in the dataset variable.
You can use the following format to filter data from the dataset variable when referencing it.
dataset variable name . filter parameter.
Example: where region_id is the column name.
Set Variable Value Activity.
In addition to the many new enhancements to Automation variables, this release includes the new Set Variable Value activity. You can use this activity to easily assign a new value to a previously-defined variable.
Loop Connections Activity.
This release includes a new Automation activity called the Loop Connections activity. You can use this activity to loop through multiple connections, executing one or more activities against each connection in the list.
Copy File and Delete File Activities.
You can now use standard wildcard characters in the file name to help you select one or more files to copy or delete. Previously, you could use the only the asterisk (*) in the file name to select multiple files to copy or delete.
You can now use a variable in the file name to select one or more files to copy or delete.
You can now generate and save detailed Object comparison reports created by the Data Compare activity.
You can also generate and run a synchronization script using the Data Compare activity.
Automation Guided Tour.
The Automation Guided Tour is a helpful wizard that guides you through the process of creating one of several different simple Automation scripts. Use this new wizard to help you create one of the following basic scripts.
Export Data and Email.
You can send a SQL statement to the Automation Guided Tour from the Editor or the Query Builder by clicking the Send SQL to Automation button in the toolbar.
In addition, the last page of the Import Wizard allows you to send your import template to the Automation Guided Tour.
After completing the wizard, your new script opens in an Automation window where you can further customize and enhance the script, if necessary.
General Automation Enhancements.
This release also includes several general enhancements to Automation activities.
In the Automation Toolbox, some activities have switched categories to better reflect their function. The Send Email and the Run Automation Script activities are now in the Systems Activities category.
For activities in which you can add a suffix to the output file, Toad now provides a convenient expression editor to easily build a customized suffix.
In the Select to File activity, selecting the options for your export file is now much simpler. If necessary, you can still specify the more advanced export file options by using the Export Wizard activity instead of the Select to File activity.
In activities that provide a File Collection Editor dialog for selecting files to attach or zip, etc. Toad limits the files to only those created in previous activities. In addition, if a previous activity is disabled, its output files are not available.
Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, a message informs you that the script will be upgraded so it will work in the current version of Toad.
Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\bak folder in the Application Data Directory under Help | About.
Validation Error Icon.
If you choose to upgrade an Automation script created in a previous version of Toad for SQL Server, after opening the script, look for the validation errors icon.
Expressions Used in Automation.
Some expressions might break in this release of Toad for SQL Server. For example, if you used a variable in an expression, you must now surround the variable name with the hash (#) symbol (#MyVariable.
Idea Pond is a site where you can submit your ideas to improve Toad and vote or comment on other people's ideas. Toad's development has always been driven by our customers, and now it is even easier for you to tell us what changes are most important. This site is free for all customers.
Resolved Issues and Enhancements.
Resolved Issues and Enhancements in 6.6.
The following is a list of issues addressed and enhancements implemented in this release.
(Windows Vista on Toad client only) If you initially start Toad when logged in as a standard user and enter a license key, the license key should be saved to.
C:\Program Files\Quest Software\Toad for SQL Server 6.6.
However, a standard user does not have write privileges in Vista to C:\Program Files so the key is saved to the following directory instead: C:\Users\ username \AppData\Local\VirtualStore\Program Files\Quest Software\Toad for SQL Server 6.6.
If you later start Toad as an administrator, you are prompted to enter the key again because it is not in the C:\Program Files directory.
If intending to hibernate the machine with the open connections to the servers that might be unavailable at the next startup, it is recommended to disconnect first due to risk of data loss.
When installing Toad using Quest Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message.
Third Party Known Issues.
In the following environment, Microsoft Framework 4 installed on Windows 7 or Windows Server 2008 R2, some users may experience that Toad unexpectedly closes while running certain Automation scripts. After the application closes, a "Toad has stopped working" message displays. You may also encounter this issue if you close Toad immediately after the successful execution of certain Automation scripts.
Install Microsoft Framework 4.5.
If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at.
Export Wizard/ One Click Export.
To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations.
Microsoft® Internet Explorer® 6.0 or later.
Copy/Move Database Wizard.
The SQL Server Backward Compatibility package is required to use the Copy/Move Database wizard.
The Log Reader requires version 8.0 DLL files in the Microsoft Visual C++ 2005 SP1 Redistributable Package. If these files do not exist on the client, you will need to install them to use some functionality in the Log Reader.
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements.
Limited support of SQL Server® 2000 (Service Pack 3 or later.
Note: The following features are not available.
Spotlight Essentials Performance Analytics.
Altering procedures, functions, views in the Editor.
SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express.
SQL Server 2008 and SQL Server 2008 Express.
SQL Server 2008 R2 and SQL Server 2008 R2 Express.
SQL Server 2012 and SQL Server 2012 Express.
SQL Server 2014 Enterprise and SQL Server 2014 Express.
SQL Server Compact Edition is not supported.
Storage Management is not available on SQL Server Express.
Cloud Database Service.
Note: To be able to utilize a majority of Toad functionality, please grant VIEW DEFINITION on the SQL Azure databases you want to work with.
User Requirements to Install Toad.
Only Windows Administrators and Power Users can install Toad.
If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User, Vista standard user—on the computer.
If a Power User installs Toad, a Restricted User cannot do the following.
Associate file extensions.
View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.
User Requirements and Restrictions for Running Toad.
The following describes the requirements and restrictions for users who launch and run Toad.
To create or modify the table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the table to use Toad Security features.
The commercial version of Toad for SQL Server comes pre-installed with a trial license key for your convenience. This allows you to use the application while waiting for your commercial key to be delivered.
The trial license key remains active for the designated trial period, even after you enter your commercial license key (the splash screen may continue to indicate your application is a trial version). This is helpful if you are previewing an upgrade or an advanced module.
To enter a license key.
Select Help | Licensing from the menu (ALT+H+L.
Review the following for additional information.
For More Information.