Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
SQL Server Repository
This topic describes how to create a SQL Server repository.
Notes: |
|
Sparx Systems provides SQL scripts to create the required Enterprise Architect repository tables, on the Sparx Systems website. You can execute the scripts in any way you prefer.
Create a SQL Server Repository
To use SQL Enterprise Manager to create a SQL Server repository, follow the steps below:
- In SQL Enterprise Manager, locate the server on which to create your new Enterprise Architect model; in the example below this is 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.
Note: |
Ensure that the database collation is 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. Check that you have selected the correct database to run the script in. In this example the tables are being added to the ea_sqlserver database as shown in the drop-down menu below.
- Click on the Execute button; SQL Server executes the script, which creates the base model for an Enterprise Architect project.
SQL Server repositories are created without any data, so you must perform a project data transfer in Enterprise Architect to copy a suitable starter project. If you are starting from scratch, EABase.EAP is a good starting point. If you are using an existing .EAP model, you can upsize it.
The material ("material" includes all pages, documents and on-line graphics) on this web site is protected by copyright law. (C) 1998-2010 Sparx Systems Pty Ltd.