Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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
