Items in Gallery can be easily modified in a temporary model and the changes can be saved immediately.
This windows is capable of displaying all of your Galleries and their objects and it also allows you to change their structure.
The Explorer toolbar contains several options:
|New Gallery||Creates a new Gallery as described in Basic Actions.|
|Open Gallery||Opens an existing Gallery file (.txgall file format)|
|Save Gallery||Saves recent changes made to Gallery.|
|Properties||Displays Gallery Properties - Name, Decription, Path.|
Creates a new folder in the Gallery.
|Delete Selected Item||
Deleted the selected object.
|Close Gallery||Closes (not deletes) the selected Gallery.|
Items in the Explorer also have the following unique right-click options:
|Save as (Gallery)||Allows you to save Gallery as a .txgall file to the selected location.|
|Item properties (Item)||Allows you to modify item properties (Name, Author, Descriptio) and view its objects.|
|Modify (Item)||Allows you to modify the stored item in a separate model and synchronize the changes with the item in the Gallery. See Modifying Items for more information.|
Toad Data Modeler allows you to verify your models. You can choose the items you want to verify, find out what errors and flaws your model contains and use quick fixes to resolve any issues.
To verify your model
Model Objects tab - lists all objects and object group types in your model. Checked object are those that will be verified.
Verification Settings tab - Here you can enable/disable rules that should be considered during verification. Use the buttons on the top of the form to check/uncheck all errors/warnings/hints at once.
Rules are database dependent, the following screenshot shows rules for Microsoft SQL Server 2012.
Verify Model results are displayed in Verification Log.
Toad Data Modeleroffers Quick Fixes - recommended solutions for problems and issues found by Model Verification. Quick Fixes are accessible for problematic objects both in Verification Log and Physical Model Explorer, in right-click menu.
The Verification Log toolbar contains several buttons:
|Tree View||Switches Verification Log to tree view where the problem description, affected objects and quick fix suggestion can be all seen. Note that you cannot ignore messages or remove them from ignored in this view.|
|Show Errors/Warnings/Hints||When enabled, Errors/Warnings/Hints are shown in Verification Log.|
|Ignore Message||Marks the selected message as ignored.|
|Remove Message from Ignored||Removes the selected message from ignored list.|
|Show Ignored Messages||
Shows/hides ignored messages.
|Verify Form||Displays Model Verification dialog.|
|Verify||Verifies model using the last saved settings.|
|Save Verification Log||Saves all verification messages (including the ignored ones) to a CSV file.|
Errors, warning and hints can be displayed directly in the Object Properties form, at the bottom. Every time you make changes to the object and confirm, the object is verified and all issues are displayed at the bottom, similar to the screenshot below. Quick Fixes are not available in this mode.
On Form Verification can be enabled/disabled in Settings Menu | Options | Model . You can also decide what kind of verification messages should be shown - errors/warning/hints.
SQL Preview tab now highlights errors in SQL script syntax.
Model Verification can be configured for each specific database. Go to Settings Menu | Options | Model | Physical Model | *Target Database*.
In the Verificator frame you can enable/disable verification rules or change their category, e.g. Empty Object can be shown as an error instead of warning.
Syntax validity check may be disabled in Settings | Options | Model | Physical Model | <database> | Syntax Validity checkbox
Use Toad Data Modeler random data generation to quickly and easily create data for your databases. Data generation is supported for SQL Server 2005 and onwards
To generate data
To work with records
TIP: Click <%> to add application variables in Attributes in order to use them in your generated data