SQL Anywhere includes a powerful suite of tools to assist in the design and development of data-driven applications and to simplify the management of database, synchronization, and mobile messaging environments.
Centralized Control and Administration
Sybase Central provides a graphical user interface to design, debug, and administer SQL Anywhere and UltraLite databases, and MobiLink and QAnywhere servers. In addition to facilitating routine tasks, Sybase Central also provides performance statistics, application profiling and the ability to manage events and schedules, synchronization system modeling, Web services, and connection profiles.
Integrated Design Environment
PowerDesigner Physical Data Model combines object-oriented, conceptual and physical data object modeling capabilities in a single environment. Developers can model the overall physical structure of a database, build a Physical Data Model (PDM) using diagrams, create and use business rules and other model objects, generate triggers, procedures, scripts and databases or reverse engineer existing databases.
Performance analysis is simplified with the Application Profiling Wizard. Using captured database activity, the Application Profiling Wizard recommends system changes based on profiles of stored procedures, functions, triggers and events, identification of deadlocks, database schema design, and more. Developers can review detailed analysis through a single graphical user interface.
Index Selection and Optimization
The Index Consultant streamlines the process of selecting indexes for a database or a query by creating many different sets of virtual indexes during its analysis. The queries and other requests for each set are then optimized and analyzed, resulting in a set of recommendations. A set of queries can be captured from a live SQL Anywhere database for analysis by the Index Consultant.
.NET Development and Integration
The SQL Anywhere Explorer gives developers quick access to SQL Anywhere databases right from Visual Studio and allows them to leverage their knowledge of .NET languages to create powerful applications. In addition, SQL Anywhere includes DataWindow .NET