Importing MySQL data model

[alauzon]

Hi there Enterprise Architect is a wonderful tool.  

I would like to know if somebody tried to import the data model from a MySQL database through an ODBC link or any other way ?

Can you share with me your results since I don't understand how to do that ?

Thanks

Alain Lauzon

[Englisito]

Hi,

I just did an import today so its fresh in my head:

• First setup the ODBC data source on your machine.
  
  
• Create a package to put it in and a class diagram. I used the default deployment view, its deployment model and deployment diagram.
  
  
• Open the diagram.
  
  
• Select Project->Database Engineering->Import from ODBC.
  
  
• Set the database name using the "...". It should be in the 'Machine Data Source' tab of the dialog.
  
  
• Then Import.
  
  
• Here you can select the Tables you want then OK it.
  

The table elements etc. are created and displayed in your diagram.

I think it works out its MySql automatically and uses the data types as defined in Configuration->Database Datatypes.

The only problem I had was it seemed to lose some data type definitions and I could not work out how to edit things like field length. Looking into both of these.

Once this is solved I should be able to use the models to generate DDLs.

Hope this helps