Upsize to SQL Server

You upsize your model repository to a SQL Server database in the following stages:

Stage One: Create an Empty Database and Repository

  1. Install SQL Server.
  2. Create an empty database. Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic.
  3. Using a tool such as the SQL Query Analyser, load the SQLServer_EASchema.sql file from the Sparx Systems website.
  4. Make sure the new database is the currently active database.
  5. Run the script to create all required data structures (that is, create the repository).


See the Create a SQL Server Repository topic.

You now have an empty database repository, into which you can transfer an existing model.

Stage Two: Perform Integrity Check

Run the project integrity check tool (select the Tools | Data Management | Project Integrity Check menu option) on the base project that you intend to upsize to the SQL Server repository, to ensure the project data is 'clean' before uploading.

Stage Three: Transfer the Data


When transferring a project you must have db_ddladmin permission in order to execute the SET IDENTITY_INSERT [table] {ON | OFF} command.

  1. Open Enterprise Architect and select the Tools | Data Management | Project Transfer menu option. The Project Transfer dialog displays.
  2. In the Transfer Type panel, select the .EAP to DBMS radio button.
  3. In the Source Project field, type the name of the .EAP file to upsize to SQL Server.
  4. At the right of the Target Project field, click on the [ ... ] (Browse) button. The Data Link Properties dialog displays, showing the Provider tab.
  5. Select Microsoft OLE DB Provider for SQL Server from the list, then click on the Next>> button. The Connection tab displays.
  6. Type or select the Server name.
  7. Select the Use a specific user name and password radio button, then type the User name and Password.
  8. Click on the Select the database on the server radio button and on the drop-down arrow. From the list, select the repository to connect to.
  9. Click on the Test Connection button to confirm that the details are correct.
  10. If the test does not succeed, revise your settings. If the test succeeds, click on the OK button. The Project Transfer dialog redisplays.
  11. If required, select the Logfile checkbox and type a path and filename for the data transfer log file.
  12. Click on the Transfer button to begin the data transfer process.

Once this process is complete, the content of the .EAP model exists on the SQL Server repository and you can now open the repository from Enterprise Architect.


You cannot transfer a source .EAP file that was created using a version of Enterprise Architect earlier than 3.5.0.