Toad Data Modeler allows you to update models to synchronize changes between your database and your model.
Example: You loaded the database structure of your database to Toad Data Modeler (Reverse Engineering). - Model A was created. Then you made some changes in your database and now you want to update the Model A. For this purpose, you can use the Model Update feature.
Model Update includes operations such as Connections, Model Comparison and Model Merge
To update your model
Note: You might be prompted to enter a password to connect to the database. This can be changed by checking Save Password checkbox in specific Connection settings.
After you're done with selecting the objects, proceed to the next dialog.
Compare Tree Overview
|Import selection from a saved file.|
|Save selection to a file.|
Runs the verification process.
The verification might return a warning . Details are available in Verification Log.
|Checks all items.|
|Unchecks all items.|
|Checks all items that exist in the Source model, but not in the Target model (CREATE).|
|Checks all items that does not exist in the Source model, but exist in the Target model (DROP).|
|Checks all items that exist in both models, but are different (ALTER).|
|Opens the Wildcard Dialog where you can define settings for bulk selection/deselection of the Action box of the items listed on page Select Items.|
Refresh Necessitated Items
Explanation: Some objects are related together (e.g. entity and domain, entity and relationship). Let's say you uncheck a Domain in Select Object Types dialog. However you keep an Attribute of the Domain type checked for conversion. In the next screen the Domain will be selected for conversion (and highlighted in gray), even if you don't want it to. This is because of its relationship with the Attribute, which cannot exist without the Domain.
Now, if you uncheck the Attribute, the Domain will still be checked for conversion. This is where you use this button. It runs through all checked objects and removes the Domain highlighted in gray since the Attribute is no longer checked. That means the Domain is no longer necessary, since it has no relationships with currently checked objects and you unchecked it in Select Object Types dialog.
|Go to next object in the tree.|
|Go to previous object in the tree.|
|Display options for objects.|
|Display options for properties.Source|
|The source model (often the database).|
|Model to Merge||The model which is going to be updated.|
Check this checkbox toupdate the item.
Uncheck this checkbox to not update the item.
Compare Tree Icons
Difference between Source model and the updated model.
This object exists in Source model but does not exist in the updated model.
This object is missing in Source model but exists in the updated model.
Right-click an item to see the following options:
|Check All Children||Checks the Operation checkbox of all children items.|
|Uncheck All Children||Unchecks the Operation checkbox of all children items.|
|Check All Children to Add||
Checks the Operation checkbox of children items that exist in Source model but not in the Target model ( items) to generate the CREATE statement.
|Check All Children to Remove||Checks the Operation checkbox of children items that are missing Source model and exist in Target model ( items) to generate the DROP statement.|
|Check All Modified Children||Checks the Operation checkbox of children items where properties differ (items) to generate the ALTER statement.|
|Uncheck All Children to Add||Unchecks the Operation checkbox of children items that exist in Source model but not in the Target model ( items) to not generate the CREATE statement.|
|Uncheck All Children to Remove||Unchecks the Operation checkbox of children items that are missing Source model and exist in Target model ( items) to not generate the DROP statement.|
|Uncheck All Modified Children||Unchecks the Operation checkbox of children items where properties differ (items) to not generate Change Script for this change.|
|Wildcard Filter||Opens the Wildcard Dialog where you can define settings for bulk selection/deselection of the Operation box of the items listed on page Select Items.|
|Expand All Children||Expands all sub-items of the selected item.|
|Collapse All Children||Collapses all sub-items of the selected item.|
Toad Data Modelerhelps you with synchronization tasks and allows you to:
Situation A - Generation of Change Scripts
You have made changes in your physical ER diagram in Toad Data Modeler and now you need to apply the changes to your database.
Solution: Compare the models and generate Alter Script in Toad Data Modeler. Then use a third party software to connect to your database and execute the generated script. All your changes are now reflected in database. (Note: Change Script generation is not supported for all databases, for further information see Supported Databases.)
Situation B - Model Update
You or someone else made changes to your existing database (development version of database) and you need to transfer the changes to your model.
Solution: Use the Model Update or Model Merge features to update your physical model.
You have created a Logical model in Toad Data Modeler and need to convert the logical model to physical model for the selected database system.
Solution: Use the Model Convert or Simple Model Conversion feature for logical (LER) to physical (PER) model conversion.
Note: If you make changes in your LER model and need to update the existing PER model, perform the LER to PER conversion again and then compare the two PER models.
There are many factors that affect synchronization features in Toad Data Modeler. For example:
In result, the synchronization of your model and your database is more complicated than comparison of two physically existing databases. From technical point of view, the comparison is based on more complicated algorithm that requires more resources.
To define the page size on your own, select Custom from the Page box. Define Height and Width on the right.
- The measure unit can be set in Settings | Options | General | Select Unit of Length - inches or millimeters.
- Page Format settings are saved with a model.
Select this option to print the entire model on one page. This option is model-dependent.
Select a scale of your model for print.
The option selected in the Page Format dialog will be automatically set in the Printer Properties dialog. You can set a different orientation for every model, the option is model-dependent.
Select your printer.
Then in the Page box you can see formats that the selected printer supports (enabled items) and other formats (disabled items). (This feature should solve problem with printing on plotters.)