Adaptive Server Anywhere (ASA) Repository
This topic describes how to create a Sybase Adaptive Server Anywhere (ASA) repository.
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. However, if you are unfamiliar with ASA and DBMS systems in general, you might want to consider a suitable front end tool.
Sybase Central is one such tool, that can be installed along with the DBMS. It provides a convenient graphical user interface to enable creation of databases, execution of scripts and restores.
To get started with Sybase Central, follow the steps below:
- Create a new database.
- Open Interactive SQL and execute the AS SQL script.
The following example shows the tables created in the ASA repository after running the script in EMS ASA Manager.
ASA 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.