What's New in SQL Anywhere Studio
Welcome to SQL Anywhere Studio Version 9
SQL Anywhere Studio is a complete relational database management system. It includes the following major components:
Adaptive Server Anywhere A self-managing relational database with high reliability, high performance out of the box, and a full range of SQL features. It is available for Windows, Windows CE, Linux, NetWare, and several flavors of UNIX.
UltraLite A database system for small devices, including Palm OS, Pocket PC, and Java-based devices. Custom built for restricted environments, the UltraLite database management system can run in less than 100K while providing full transaction-processing support, a choice of development models, and synchronization with enterprise data stores.
MobiLink A synchronization technology for sharing information among relational databases. It integrates physically separate databases into a single information system, maintaining the integrity of transactions across the entire system.
SQL Remote A synchronization technology specifically for message-based synchronization. Dial-up links, e-mail, and ftp systems can be used to connect your databases.
SQL Anywhere Studio has many uses in the small and medium business (SMB) market, in mobile computing, and in embedded systems.
SMB server As a self-tuning, easy to manage, scalable and secure database server, Adaptive Server Anywhere is an ideal choice for an SMB database server. It scales all the way from handheld devices to databases in the tens of gigabytes accessed by hundreds of concurrent connections.
Mobile computing Adaptive Server Anywhere runs well in environments with restricted resources, making it ideal for desktop and laptop use, as well as on Windows CE devices. UltraLite provides a database with an even smaller footprint for Windows CE and Palm OS devices. MobiLink provides a scalable and secure synchronization system that ties many remote databases together into a single integrated system.
Embedded systems Adaptive Server Anywhere and UltraLite have self-management features that make them ideal for use in zero-administration environments such as embedded systems. MobiLink's server-initiated synchronization (new in this release) makes it possible to synchronize embedded databases from a central location.
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.
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.
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 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.
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.