Create a SQL Server Repository

Creating a SQL Server database is fully documented in the product information provided with your SQL Server installer.

Having created your SQL Server database, use the SQL script (SQLServer_EASchema.sql) provided by Sparx Systems to create the required table definitions for Enterprise Architect. You can obtain the script from the Sparx Systems website, on the:

Registered Corporate edition Resources page (Registered users)
Corporate edition Resources page (Trial users)
 

If you are unfamiliar with SQL Server and DBMS systems in general, you might want to consider a suitable front end tool, such as SQL Enterprise Manager.

SQL Enterprise Manager example

Step

Action

1

In SQL Enterprise Manager, locate the server on which to create your new project; for example: DBSERVER02\SQLEXPRESS.

 

2

Right-click and choose the New Database context menu option.

 

3

Enter a suitable name for the database. Set any file options as required.

Ensure that the database collation is set to the alphabet you use, such as Latin or Cyrillic, and case-insensitive.

 

4

Click on the database to select it, then select the New Query menu option.

 

5

In the Query window, use the Open File dialog to locate the SQLServer_EASchema.sql script file.

 

6

Click on the Open button. In the drop-down menu, check that you have selected the correct database to run the script in.

 

7

Click on the Execute button; SQL Server executes the script, which creates the base tables for an Enterprise Architect project.

 

Notes

This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions
When creating a project in a SQL Server database you must have db_ddladmin permission in order to execute the SET IDENTITY_INSERT ( table )  {ON | OFF} command

Learn more