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, probably the most common is to use a SQL based Management Console like Microsoft SQL Server Management Studio, which provides a convenient graphical user interface to enable the creation of databases, the execution of scripts, and backups and restores.  However the exact method used is not important to this discussion, therefore you are free to 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 (ie. 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