MSDE Server Repository

This topic describes how to create a SQL Server MSDE repository.


  • This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions.
  • Before starting, you must have MSDE Server and MDAC 2.6 or higher installed, and the appropriate permission to create a new database. The process of setting up MSDE Server is beyond the scope of this User Guide; please consult your MSDE Server documentation for further guidance.

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.

Use the SQL Server 2000, 2005 or 2008 script for MSDE, and follow the steps in the Create a SQL Server Repository topic.


MSDE 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.