Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

SQL Server Repository

Before creating a SQL Server data repository, you must have SQL Server and MDAC 2.6 or higher installed, and access permission to create a new database. Creating a SQL Server database is beyond the scope of this User Guide - refer to your SQL Server documentation for assistance.

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 scripts from the Sparx Systems website, on the:

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

How to

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. The following example shows how to create the repository in SQL Enterprise Manager.




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



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



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.



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



In the Query window, use the Open File dialog to locate the supplied Enterprise Architect SQL Server Model script file.



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



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



This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions

Learn more