Microsoft Excel is a powerful tool. I think I can say it excels in many areas, but… can it be used for database modeling? Yes and No. As you probably know, Toad Data Modeler introduced support for im...
Workspaces in Toad Data Modeler can be used for splitting Entity Relationship Diagrams (ERD) to smaller parts.In case your model is large, it is always recommended to use workspaces to limit the amoun...
Toad Data Modeler contains many powerful synchronization features, incl. model comparison, model merge and generation of change scripts. In addition to the complex features, there is another possibil...
In SQL Server models you can define Extended Properties to various objects manually. In case you wish to add extended properties to multiple objects at once, download a small macro from here. Extract...
Learn how to create a model in Toad Data Modeler....
There can be various reasons why all primary key attributes in your database structure should be named identically. The most typical name is “ID”. But what if you start creating relationships? In Toa...
If you wish to generate localized HTML, RTF or PDF reports, download dictionaries from the following section: Run Toad Data Modeler and click Settings | Dictionaries. New tab Dictionaries opens. Mak...
In physical model you can define Data Warehouse Type for your tables and graphically distinguish the Fact and Dimension tables. Example: By default, the Data Warehouse options are not available and ...
Learn how to generate SQL code for your data models in Toad Data Modeler, the cross-platform database modeling tool....
Standard Method Toad Data Modeler allows you to divide large models to smaller parts – workspaces. If you already have objects on your workspace and wish to add missing relationships to it, right clic...
Watch how to manage database connections and how to create a new model from existing database via reverse engineering....
Download package TablespacesAssignment and import it to Toad Data Modeler. Select entities in Physical Model Explorer, right click on any of them and choose Macros | Tablespace Assignment. New cus...
