SQL Server Repository
Note: |
This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions. |
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. Please note that setting up SQL Server and the issues involved are beyond the scope of this user guide. Consult your program's documentation for a guide to this.
Sparx Systems provide SQL scripts to create the required tables; how you create the database and execute that script are up to you.
- Registered users can obtain the scripts from the Registered Corporate edition Resources page of the Sparx Systems website at http://www.sparxsystems.com/registered/reg_ea_corp_ed.html
- Trial users can obtain the scripts from the Corporate edition Resources page of the Sparx Systems website at http://www.sparxsystems.com/resources/corporate/.
Create a SQL Server Repository
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.
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.
