Contents Index Welcome to SQL Anywhere Studio Version 9 Adaptive Server Anywhere highlights

What's New in SQL Anywhere Studio
  Welcome to SQL Anywhere Studio Version 9

Overview


SQL Anywhere Studio is a complete relational database management system. It includes the following major components:

SQL Anywhere Studio has many uses in the small and medium business (SMB) market, in mobile computing, and in embedded systems.

Version 9 

SQL Anywhere Studio version 9 brings a host of new features to the product, while maintaining the ease of use and self-management features for which it is known.

Web services and .NET 

With this release, SQL Anywhere Studio introduces XML and web services features. A web server is built directly in to the database. A flexible interface lets you retrieve data as XML and store XML data in the database. Integration with Microsoft Visual Studio .NET rounds out the web services offerings.

Version 9 takes advantage of the Microsoft .NET architecture. With the XML and web services features, an ADO.NET provider for Adaptive Server Anywhere, a .NET scripting capability for MobiLink synchronization, and an UltraLite .NET component for development of handheld database applications, SQL Anywhere is built to work with .NET.

Rapid application development for small devices 

The UltraLite .NET component is just one of a suite of UltraLite components that makes it easy to develop powerful database applications for small devices. Other components provide integration with rapid application development from a number of tools, including Pocket IE, eMbedded Visual Basic, AppForge MobileVB, and Borland JBuilder.

MobiLink synchronization 

MobiLink synchronization ties UltraLite or Adaptive Server Anywhere databases into an enterprise system, using configurable two-way synchronization. In this release, MobiLink provides such enhancements as server-initiated synchronization and file-based downloads.

Performance 

Version 9 continues to improve performance in the Adaptive Server Anywhere database. Improved cache management and other internal changes provide scalability to large numbers of users and more processors, and innovative algorithms in the optimizer provide better handling of complex queries. What's more, a 64-bit version of the software is available or planned for Linux, HP-UX, and for 64-bit Windows operating systems.

For those who really need to get the most performance out of their database, a graphical Index Consultant makes performance tuning easy. This is just one feature included in a redesigned Sybase Central administration tool. The new look puts more information within easy reach than ever before, and provides a suite of powerful design and administration tools, including the query editor, and a redesigned stored procedure debugger.


Contents Index Welcome to SQL Anywhere Studio Version 9 Adaptive Server Anywhere highlights