Save an Enterprise Architect Model to a Database

If you do not have any EA model yet, create it (or open a sample one).

• In the Enterprise Architect application, start the Open Project command from the main menu (below the EA icon)
• Select Local File and find the file C:\Users\Administrator\AppData\Roaming\Sparx Systems\EA\EAExample.eap

If the EA project is not saved yet in a database (for example, because it has been just installed according to the previous chapters), then save it.

• Open the Project Transfer dialog using the Configure | Model | Transfer ribbon
• Select File to DBMS
• Enter C:\Users\Administrator\AppData\Roaming\Sparx Systems\EA\EAExample.eap as a Source Project
• As a Target Project, enter the following into Data Ling Properties:
  • On the Provider tab, select Microsoft OLE DB Provider for ODBC Drivers
  • On the Connection tab
    • In part 1 (… source name…), select the ODBC connection value, i.e. ea
    • In part 2 (… log on…), enter the name of the root user of the database (administrator) and its password. In our case root and P@ssw0rd
    • In part 3 (… catalog…), select the name of the database schema, i.e. ea
  • Test the connection and confirm
• Enterprise Architect copies the content of the project from the file to the database (and will be available for the EaInfoport system).
• The last step is to open the project from the database.
  • From the main menu (below the EA icon) start the Open Project… command
  • Select Connect to Server and fill in the same data as we used in the previous step to connect to the database.
  • After confirmation, we are connected to the project saved in the database.