Last modified 12 years ago Last modified on 09/21/2007 01:39:16 PM

How to import SQL to EA

You need to have a local database that EA can connect to. In many cases this will mean

  • installing MySQL
  • installing ODBC driver for EA
  • loading schema
  • setting appropriate privileges

on Windows. I found this link useful while installing the ODBC driver:

Once the database is set up, in EA:

  • create new package
  • create a diagram within new package
  • select Project -> Database Engineering -> Import DB Schema from ODBC

Be aware that some types (like UNSIGNED) are not correctly handled by EA, see

The diagram often needs to be rearranged, in particular the names next to the foreign key relations.

Related EA help: "Import Database schema from ODBC".