It is a comprehensive package that provides database management and enterprise database synchronization capabilities to enable the rapid development and deployment of database-powered applications.

SQL Anywhere Studio, a product of iAnywhere, a Sybase company, is the name of the package that contains SQL Anywhere, the UltraLite RDBMS, MobiLink synchronization software, and other components. This powerful database server is optimized for use on SMB servers, laptops and handheld devices, and supports both single user and multi-user implementations. SQL Anywhere is intended for use in mobile and embedded environments or as a server for small and medium-sized businesses (SMB). SQL Anywhere, is the industry-leading database management system (RDBMS)/relational database server component of SQL Anywhere Studio. When the process is complete, you have created a project on an ASA database and can now connect to it and open it from Enterprise Architect.In version 10, Adaptive Server Anywhere (ASA) was renamed SQL Anywhere. If required, select the 'Logfile' checkbox and type a path and filename for the data transfer log file.Ĭlick on the Transfer button to begin the data transfer process. The 'Project Transfer' dialog redisplays. In the 'Use Data source name' field, click on the drop-down arrow and select the ODBC Data Source you configured to point to your new database.Ĭlick on the OK button. Select 'Microsoft OLE DB Provider for ODBC Drivers' from the list. The 'Datalink Properties' dialog displays. EAP file has Replication enabled, this must be removed before performing the transfer.Īt the right of the 'Target Project' field, click on the button. In the 'Source Project' field, type the name of the project file to copy to the repository.

In the 'Transfer Type' panel, select '.EAP to DBMS'. Select the 'Configure > Model > Transfer > Project Transfer' ribbon option.

With Enterprise Architect open, ensure that it there is no project loaded, by selecting 'Close Project' from the button. These issues should be resolved before continuing with the project transfer. If Enterprise Architect detects that the existing model contains integrity issues, they will be listed in the main panel at the bottom of the dialog. In Enterprise Architect, open the existing repository and select 'Configure > Model > Integrity > Project Integrity' in the ribbon.Įnsure that the 'Action' panel is set to 'Report Only' and that all items in 'Checks to Run' are enabled, then click on the Go button.

Sybase sql anywhere 9