wiki:howToImportSQLtoEA
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: http://sparxsystems.com.au/EAUserGuide/index.html?setupmysqlodbcdriver.htm

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 https://www.lsstcorp.org/docushare/dsweb/Get/Document-1385/EAbugs.doc

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".