Prev Next

Create an Adaptive Server Anywhere Repository

Creating an ASA database is fully documented in the product information provided with your ASA installer.

There are many ways to create a new Adaptive Server Anywhere database, probably the most common is to use a SQL based Management Console like Sybase Central, which provides a convenient graphical user interface to enable the creation of databases, the execution of scripts, and backups and restores.  However the exact method used is not important to this discussion, therefore you are free to use the most convenient or familiar method at your disposal.

Having created your ASA database, use the SQL script provided by Sparx Systems to create the required table definitions for Enterprise Architect. The EASchema_1220_SybaseASA.sql script  is freely available on the DBMS Based Repositories page on the Sparx Systems website.

Notes

  • Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic

Learn more