TDM and MySQL

Toad Data Modeler
1

Does TDM import and export comments (table /columns) to the information schema ?

Is there any way to generate the scripts (DDL) to MySQL with the “auto increment” option ?

(questions on behalf of Maria Fernanda L.)

2

Hello,

Does TDM import and export comments (table /columns) to the information schema ?

Yes, it does. Please feel free to check it out. E.g. in the latest Beta 3.1.6.

Is there any way to generate the scripts (DDL) to MySQL with the "auto increment" option ?

Yes, there is. You have to set up the autoincrement to generate it.
See the Attributes Properties dialog, tab General and the Autoincrement checkbox -available for particular data types (e.g. Integer).
See the Entity Properties form, Table Options tab and box Initial AUTOINCREMENT.
(New in latest versions. Let me recommend you to download the latest Beta.)

If you have any questions, please write me back.
Thanks.

Regards,

Vladka + TDM Team

3

Hi Vladka,

Another question:

Is there any way to generate the scripts (DDL) to MySQL with the ENGINE option.

Thanks again.

4

Hello Maria,

Yes, final DDL script generated in TDM3 includes the ENGINE information.

Open a MySQL model in TDM3, edit an entity to open the Entity Properties form | General tab and see the combo box Table Type. Select a Table Type (e.g. InnoDB) and click the SQL Preview tab to preview the SQL code:

– Table Entity1

CREATE TABLE Entity1
(
) ENGINE = InnoDB;

If you have any questions, please write me back. Thanks.

Regards,

Vladka + TDM Team

5

Hello again Vladka,

Tks a lot for your attention !

More questions / doubts :slight_smile:

  1. Is there any way to compare the current model with a script (SQL) ?
  2. May I compare the current model with the database directly or just with another model ? In other words, how do I do to compare the model with the database ? Must I always load the database in a model to do the comparison ?
  3. I was testing the reverse engineer with some tables and I realized that TDM3 cannot “understand” the FKs / relationships correctly, he brings just the index, but not the FKs. Did you realize it ?
  4. Is there any available version that runs with LINUX (CEMT OS) ?

Thanks in advance,

Maria Fernanda.

6

Hello Maria,

  1. No, TDM3 doesn’t allow you to compare model with sql script.
  2. No, TDM3 doesn’t allow you to compare current model with database directly.

TDM3 can only compare models. If you make a change in db, you need to do RE again. -> A new ERD will be created (modified). Then you can compare the two models (original and modified) and merge them. You can either apply the changes in the original model or merge them to a new model.
Let me recommend you to open the Help file | Index tab and write ‘Synchronization’, appropriate topic will be displayed. There, you can learn about the options and see other references - model update, convertor, model merge, alter scripts etc.

See also the Manual for an example - Model Update topic.

Movie on Convertor is also available:
http://modeling.inside.quest.com/entry.jspa?externalID=1624&categoryID=273

  1. All relationships (FKs) that physically exist in the database should be loaded to TDM3 properly.
    What connection method do you use? If you use Native connection, please try also ODBC.
    Also, what version of MySQL exactly do you use?

Thanks for this information.

  1. No, version that runs with Linux is not available.

I look forward to hearing from you.

Regards,

Vladka + TDM Team