Product Training

Rename Function Based Indexes

5 May 2016 at 8:06pm
This macro iterates all indexes in a model and renames them to EntityName<number>_fb_i. 1. Download and install the package to Toad Data Modeler. How to import custom packages: http://www.toadworld.com/products/toad-data-modeler/b/weblog/archive/2010...
503 0 /

Create ToDo Items Macro

16 Oct 2015 at 10:20pm
This macro allows you to create ToDo items to all selected entities or relationships at once. Select multiple items in your model, right click one of the selected items and choose Macros | Add To Do Item. New form opens. Define Name, Category and Text and click...
689 0 /

Diagram to Web Page

15 Oct 2015 at 10:19pm
Details: http://www.toadworld.com/products/toad-data-modeler/b/weblog/archive/2015/10/15/how-to-generate-er-diagram-to-web-page How to import custom packages: http://www.toadworld.com/products/toad-data-modeler/b/weblog/archive/2010/10/10/how-to-import-custom...
897 0 /

Custom Excel Import - loading of custom properties from Excel files

9 Sep 2015 at 6:36pm
Details: http://www.toadworld.com/products/toad-data-modeler/b/weblog/archive/2015/09/09/user-defined-properties-and-import-from-microsoft-excel Target database: DB2 LUW v 10.5 Author: Petr Sklar How to import custom packages: http://www.toadworld.com/products...
723 0 /

Add Extended Properties

15 Jul 2015 at 7:07pm
This package contains macro for adding Extended Properties to all objects of selected object type. The package is valid for SQL Server 2005 - 2014 models. Blog article: adding extended properties to all objects sql server models
933 0 /

Package for Universal Model - Allow Null Attributes in Keys

22 May 2015 at 8:52am
This package enables nullable keys in Universal Model (Package was created for Toad Data Modeler version 5.4) Details: Toad Data Modeler supports database platforms that allow NULL attributes in keys as well as databases that require all attributes in keys...
785 0 /

Customized DDL code generation for Oracle

14 Apr 2015 at 1:14pm
The package allows you to modify generation of DDL script for Oracle Databases (Oracle 10g and above). Steps: 1. In Settings | Options in section General enable Expert Mode . 2. Import the package via Package Explorer 3. Edit the source code and make...
1148 0 /

Customized DDL code generation for Microsoft SQL Server

17 Mar 2015 at 4:16pm
Example that shows how to modify generation of DDL for Microsoft SQL Server 2008, 2012 and 2014.
874 0 /

Fix for PER Report Generation

22 Jul 2014 at 4:47pm
This package fixes problem reported here: http://www.toadworld.com/products/toad-data-modeler/f/30/t/22369.aspx Instructions: Unzip the archive and replace both original application files in the folder where you installed Toad Data Modeler. Default path...
973 0 /

Fix for LER Report Generation

21 Jul 2014 at 1:00pm
This package fixes problem reported here: http://www.toadworld.com/products/toad-data-modeler/f/30/t/22369.aspx Instructions: Unzip the archive and replace original application file in the folder where you installed Toad Data Modeler. Default path: C:\Program...
948 0 /

Set Attribute Focus to Caption

11 Feb 2014 at 12:07pm
This package contains a specific customization. It changes focus from Data Type combo box to Caption on Attribute Properties form in physical model.
1123 0 /

JavaScript Snippets for Eclipse IDE

6 Feb 2014 at 4:00pm
This ZIP archive contains XML document with JavaScript Snippets that can be imported into Eclipse IDE and used for Macro / Scripts development.
1309 0 /

External Storage for Stored Procedures and Functions

23 Jan 2014 at 4:18pm
This package add new tab External Storage to Stored Procedures and Functions. Use this package to export stored procedures and functions to files, check modified files via comparison of File.DateLastModified and load content back to Toad Data Modeler.
1232 0 /

Report Entities on WS

28 Dec 2013 at 9:54pm
Download and install this small package to find entities that exist in your model, but are not on any workspace. After you install the macro, restart Toad Data Modeler, open you model and choose Marcos | Find Entities not on WS . Note: change commented...
1172 0 /

Rename FK Column

20 Dec 2013 at 11:29am
This small macro allows you to rename FK attributes. In case you use e.g. ID attribute as a primary key in all tables in your model and need to name FK columns with parent table names, e.g. CUSTOMER_ID, ORDER_ID and so on, use this macro and change names of...
1371 1 /