Welcome to the Toad Data Modeling Community

Convertor and Sync & Convert Wizard Comparison - II

Hello,

Today I will show you differences  relating to the selection of actions you can perform, and model conversion.

Select Action to Perform

Convertor
Look at the old Convertor dialog. There are icons next to each model – Model 1 and Model 2. Using the icons you define your desired actions. Generation of alter script, model merge, model merge to a new model.

Sync & Convert Wizard
It allows you to select the desired action in first step on page Action.

Model Conversion

Convertor
In the Model 2 combo-box, you could see besides a list of all databases also a list of all currently open models (- what for when you want to convert your model to another database…)
On the right side of the grid – items of Model 2, there were all objects listed with status ‘Not Exists’, which was confusing.

Questions you probably asked:
•   What icon should I enable to make model conversion? The Save Merged Model 2 to New Model icon?
•   Why do I see all opened models in combo-box next to the Model 2 box. All I need to do is just to convert  a model from one db to another and I don’t care about other open models.
•   Why are all the objects on right side with status ‘Not Exists’? 
•   Where do I define name for the final model?

Sync & Convert Wizard
The new Sync & Convert Wizard answers all the questions easily.
In first step you simply select Convert Model to Another Target Database System.
On page Select Left Side you select the model that you want to convert.
On page Select Right Side, you select the target database platform for the model conversion.

On page Settings, you can even select whether database specific items should or should not be commented out. In the  past, all objects were commented out automatically, even when doing conversion from Oracle 10g to Oracle 11g. Now the choice is up to you.

When you finally reach the Select Items page, an overview of available objects will be displayed. You will see no blue or grey arrows, no objects on right side with the Not Exists status. Use checkboxes on the left to select individual objects for the conversion. (At the bottom of the wizard, you can see additional information about the highlighted item, incl. Name, Caption and Fullname).

In last step, you can define a new model name.

Summary: Clear and easy to understand GUI without redundant options.

Well, next time we will compare the model merge function.

Regards,

Vladka + Vaclav

Leave a Reply