Introducing SQL Anywhere Studio
Introducing SQL Anywhere Studio
With SQL Anywhere Studio, you can deliver information to workgroup, mobile, and embedded database systems throughout an entire organization.
SQL Anywhere Studio includes the following components. More information on each component can be found later in this book.
Adaptive Server Anywhere The relational database at the core of the product is a transaction-based SQL database designed for personal and workgroup use. Adaptive Server Anywhere runs on a wide range of operating systems, including many flavors of Windows and UNIX, as well as on Novell NetWare. It runs on hardware ranging from multiple-CPU workgroup servers to the most modest PCs, as well as on Windows CE devices.
UltraLite For building and deploying relational database applications on small devices, including the Palm Computing Platform and Windows CE. UltraLite has built-in support for MobiLink synchronization.
UltraLite lets you build relational databases with less than 50 kb of disk space, and is specifically intended for small devices.
MobiLink For two-way synchronization of data between a central database and many remote UltraLite or Adaptive Server Anywhere databases. The central database can be Adaptive Server Anywhere, Adaptive Server Enterprise, or another DBMS such as Oracle, Microsoft SQL Server, or IBM DB2.
SQL Remote For two-way, message-based replication of data between a central database and many remote databases. With SQL Remote, you can replicate data between laptop computers and a central database, using e-mail or dial-up access.
Replication Agent For replicating data from Adaptive Server Anywhere databases to other databases via Sybase Replication Server.
InfoMaker For querying databases and creating sophisticated and effective custom reports of data. InfoMaker is also a personal data assistant that lets you work with data in many ways.
PowerDesigner For designing, generating, documenting, and maintaining databases.
Management and development tools SQL Anywhere Studio includes the Sybase Central database management tool and the Interactive SQL database utility, as well as a query editor and a stored procedure debugger.
SQL Anywhere Studio includes an optionally-installable accessibility enablement module. This component provides the Sun AccessBridge module, which is loaded whenever you use Sybase Central or Interactive SQL. Third-party software such as screen readers make use of this module to provide access to software features.
InfoMaker and PowerDesigner are available only on Windows operating systems. However, they can be used as clients of a server running on any supported operating system.
The following components are separately licensable and must be ordered before you can install them. To order these components, see the card in your SQL Anywhere Studio package or see http://www.sybase.com/detail?id=1015780.
Java option The Java virtual machine and runtime classes that enable the use of Java in the database must be ordered separately.
Security option The software for data encryption (transport-layer security) between an Adaptive Server Anywhere or MobiLink server and a client, as well as MDSR database file encryption must be ordered separately. AES database file encryption is included in the base package.