Welcome to the Toad Data Modeling Community

« Convertor and Sync & Convert Wizard Comparison - II
Convertor and Sync & Convert Wizard Comparison - IV »

Convertor and Sync & Convert Wizard Comparison - III

Merge Models

Hello,

Today we will compare the model merge functionality.

Convertor
One of the strengths of the old Convertor was the possibility to compare models of two different database platforms. That seemed to be a powerful feature, however, it also brought some confusion.

Questions you probably asked:

  • How to get changes from a model created for Oracle db and put them to a model for MS SQL Server?
  • What happens if I define different settings on tabs Settings for Model1 (settings for Oracle in this case) and Settings for Model2 (settings for MS SQL Server) ?
  • What happens with objects that I did not select on tabs Settings when the objects depend on other objects I selected on tab Models? (E.g. Turn-off domains and try to apply a change in attribute where the domain is used.)

  • On the screenshot below there are settings for Oracle. The second tab Settings for Model2 contains settings for MS SQL. What happens if I clear checkbox Functions here and leave the checkbox selected on tab Settings for Model2?

    Sync & Convert Wizard
    The new Sync & Convert Wizard allows you to compare and merge only models of the same database. If you want to compare models Videorental Oracle with Videorental MS SQL Server, you have to convert the Oracle model to MS SQL and then compare two MS SQL Server models. It may seem to be an extra step, however, on the other hand the possibility that you make a mistake during the direct comparison is very low. The direct comparison is surely safer and returns better results, which are of benefit to you all, Toad Data Modeler users.Look at the new GUI. The following screenshot shows the Select Items page of the wizard.

  • No blue or grey arrows
  • Clear overview of items that have different properties or exist in the Source Model and are missing in Destination model or vice versa ( see the blue color for the difference, green ‘plus’ icons, or red ‘minus’ icon).
  • Standard checkboxes for making selection of objects
  • Details at the bottom of the form


    • Note: I recommend to watch the following movie explaining the objects and shapes issue during the model merge:
    http://modeling.inside.quest.com/entry.jspa?externalID=3055&categoryID=158

    In last step you can define if you want to update the Destination Model or if you want to save the changes to a new model.

    Summary: Easy to understand GUI with clear overview of items that are different, new or missing.

    Tomorrow we will continue, this time comparing the alter script generation functionality.

    Regards,

    Vladka + Vaclav

    This entry was posted on Wednesday, September 2nd, 2009 at 7:19 am and is filed under General, Tips & Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

    Leave a Reply