Welcome to the Toad Data Modeling Community

Convertor - New Series, Part I - Alter Script Generation for Model 2

Hello TDM users,

From the post we receive from you, the TDM Convertor seems to be a real mystery to many of you. So, it’s a great theme to deal with on our weblog. ;)

In this new series on Convertor, I will show and try to explain how the Convertor works, what it can do, how to deal with it. I will suggest some practices and steps to take etc.

The first part of the series covers the following topics:
1. Convertor - Introduction
2. Alter Script Generation
    - Generate Alter Script for Model 2 (Model Original)
 
If you feel helpless to generate alter script in Convertor, please do read these topics. On a practical example, I’m explaining what, how, where, why etc. As the document contains a lot of screenshots and is quite comprehensive, I’ve made a .pdf file that is available at:
http://modeling.inside.quest.com/entry.jspa?externalID=2101&categoryID=159

Please download it. If any question comes to your mind or if you like to share your feedback with me and others, please do not hesitate to write a comment - here or our community forum.

Now let me quote some helpful and important information from the series (from this and next parts that will be published):
===============

A sample procedure for performing model merge or alter script generation in Convertor:

1. Selecting models as Model 1 and Model 2.
2. Defining settings of Object Types and Properties.
3. Selecting actions to perform in Convertor.
4. Selecting items for the action (modifying blue arrows).
5. Execution
——————

The first step you should take before you start any action in Convertor is to consider which model will be Model 1 and which model will be Model 2. Generally, for alter script generation and model merge it stands that Model 2 should be the model that you want to update/modify.

For faster and more comfortable work in Convertor I recommend to take advantage of the default behavior of Convertor:

Convertor has been designed this way:
* Convertor compares the models, marks the differences and automatically adds blue arrows to the items that:
  - 
are missing in Model 2 (target model),
   - exist in both models and are different.
* The blue arrows are automatically set up to apply changes from Model 1 (modified model) to update Model 2 (original model). (Direction from the left to the right).
* No manual changes are necessary here (if you do not want to make them on your own).

1. Open the Convertor from the modified model (Model 1)
2. In the Convertor dialog, select the model that you want to update as Model 2.

===============

Drop by our community library to read all parts of the series that will be published gradually.

Have a nice day.

Vladka

Leave a Reply