Prev Next

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 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 Corporate edition 'Resources' page.

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 Server Management Studio.

SQL Enterprise Manager example

Step

Action

1

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

2

Right-click and choose the 'New Database' 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 EASchema_1220_SQLServer.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, Unified and Ultimate editions
  • You should have ALTER permission on the t_image table in Enterprise Architect, to be able to import model images
  • 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