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.

There are many ways to create a new SQL Server database. A common method is to use an SQL-based Management Console such as Microsoft SQL Server Management Studio, which provides a convenient graphical user interface to create databases, execute scripts, and perform backups and restores.  However, the exact method used is not important to this discussion, and you can use the most convenient or familiar method at your disposal.

Having created your SQL Server database, use the SQL script provided by Sparx Systems to create the required table definitions for Enterprise Architect. The EASchema_1220_SQLServer.sql script is freely available on the DBMS Based Repositories page on the Sparx Systems website.

SQL Server Management Studio example

Step

Action

1

In SQL Server Management Studio, locate the server on which to create your new repository (such as DBSERVER02\SQLEXPRESS) and login with administrator privileges.

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

  • 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