Welcome to the Toad Data Modeling Community

 

Archive for August, 2008

Convertor - Part VI - Model Conversion

Thursday, August 14th, 2008

Hello,

Let me close our series on Convertor in Toad Data Modeler with the last part about model conversion - LER to PER and PER to PER model conversion.

The .pdf is available at:
http://modeling.inside.quest.com/entry.jspa?externalID=2152&categoryID=159

Well, I do hope now you can better understand how the Convertor works. If there is anything unclear or if you miss any information, please do not hesitate to write me - post a comment here or write to our Modeling community forum.
Thanks very much.

I look forward to hearing from you.

Regards,

Vladka

Convertor - Part V - Model Update and Alter Script Generation

Thursday, August 14th, 2008

Hello TDM users,

Today, I’m bringing another part of the series about Convertor. This time, you will see how to update your model (Model 2 ) in Convertor and at the same time generate alter script (for Model 1).

The .pdf document is available at:
http://modeling.inside.quest.com/entry.jspa?externalID=2151&categoryID=159

Any feedback will be greatly appreciated. Thanks in advance.

Regards,

Vladka

Convertor - Part IV - Model Merge

Tuesday, August 12th, 2008

Hello,

Our series about Convertor continues. Today, you can learn about how to merge models - Model 1 and Model 2, how to rewrite the existing model or how to merge the two models to a new model.
Same example as in parts on alter script generation has been used.

Please feel free to download the .pdf document from:
http://modeling.inside.quest.com/entry.jspa?externalID=2143&categoryID=159

Next time, you will see how to update your model (Model 2) and generate alter script (for Model 1) at the same time.

Regards,

Vladka

Convertor - Part III - Generate Alter Script for Model 1 and Model 2 at The Same Time

Thursday, August 7th, 2008

Hello,

Today I’ve published the last part about alter script generation in Convertor. In this part, you will see that it is possible to generate alter script for Model 1 and Model 2 at the same time. The PDF document is available at:
http://modeling.inside.quest.com/entry.jspa?externalID=2131&categoryID=159

Just a note: In Toad Data Modeler full v., you can generate alter scripts for Oracle db only. In latest Beta 3.3.1.1, you can also generate alter script for MS SQL 2005 database.
————

In any case, our series about Convertor doesn’t finish. - As you already know, in Convertor you can also perform model merge and model conversion. So, we will continue next week.

If you have any questions, please feel free to write me. Thanks in advance for your feedback.

Regards,

Vladka

Convertor - Part II - Alter Script Generation for Model 1

Wednesday, August 6th, 2008

Hello,

How are you doing? I can see in my calendar it’s Wednesday today. Wednesday is called a hump day, isn’t it? - We are at the halfway point of the workweek. And it’s all downhill from here. :)
————–

I’m not sure if you had the time to read the first part of the Convertor series. Anyway, today I’m bringing another part, this time about alter script generation for Model 1 - modified model.
Again, it is available in .PDF document at:
http://modeling.inside.quest.com/entry.jspa?externalID=2121&categoryID=159

Enjoy and please let me know your feedback.
Thanks in advance.

Well, have a nice day and put a smile on your face. :)

Regards,

Vladka

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

Tuesday, August 5th, 2008

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

Toad Data Modeler 3.3.1.1 BETA Released!

Friday, August 1st, 2008

Hello,

Let me announce another Beta release of Toad Data Modeler - v. 3.3.1.1.

=========================
Enhancements in Beta 3.3.1.1:
=========================
Alter Scripts for MS SQL 2005
Possibility to select objects by category or schema/owner on Workspace
Enhancements in customization
Support for Oracle 11g client

and other resolved issues and bug fixes.

The BETA 3.3.1.1 Release Notes document is available at:
http://modeling.inside.quest.com/entry.jspa?externalID=2092&categoryID=29

==============
BETA Download
============== 
Download the new Beta from:
http://modeling.inside.quest.com/ann.jspa?annID=150

Uninstall of the previous Beta version is NOT necessary.

Feel free to download the latest Beta and test its enhancements and resolved issues.
Please do not hesitate to share your experience with us!

We look forward to hearing from you.

Regards,

Vladka & TDM Team