This distribution is provided with a Developer’s Edition license that enables single-CPU operation, and restricts the number of concurrent users (client connections) to 25. All other available features are automatically enabled, and there is no expiration period. To enable usage authorized by your purchase agreement, you must provide license keys. This task is done by the License Manager application bundle that is contained in the /Applications/Sybase directory.
Besides Adaptive Server version 12.5.4, this release provides you with some interactive tools to help you use and configure your database:
jISQL – is an interactive query tool that enables you to submit SQL statements to the server, and view their results within a window. This program is an application that can be added to your Dock simply by using the Finder and dragging the jISQL icon from /Applications/Sybase/jISQL to the Dock.
SybaseCentral – is a tool that allows a Database Administrator to create tables, databases, users, and so on using an easy-to-use graphical interface. This can be dragged to the Dock, as before, from /Applications/Sybase/SybaseCentral.
Server Build – is an interactive graphical tool that allows you to change the default values for Adaptive Server installation. For example, if you wanted to locate the master database device somewhere besides the default (/Applications/Sybase/devices), you could do so with this utility.
Server Discovery – uses Rendezvous technology to show you the name and location of all servers running on your network. Each Sybase server registers itself with Rendezvous when it starts, and Sybase Server Discovery shows you where each of these servers is located. Also, the menu item Configuration allows you to automatically generate or update entries in the interfaces file, for each server selected in the list.
A new feature in this release allows you to establish an interactive SQL session with a remote server. While viewing the list of servers running in your network, just move your mouse to the entry of interest (it must be Adaptive Server), and click on it. You will notice that the hostname and port number are automatically entered into the login section of the window. Just provide an Adaptive Server login name and password, then click the Login button, and a new window should appear that accepts your SQL statements.
License Manager – allows to you enter information about your purchased software, and generates a software license key for you.
SybMigrate – is a utility that allows you to move schema and data from one Adaptive Server to another, primarily for the purpose of changing to a server that uses a different page size.
For those of you familiar with prior releases of Adaptive Server on other platforms, jISQL is a Mac OS X 10.3 application package that initiates execution of the jisql utility; SybaseCentral is an Mac OS X 10.3 application package that initiates execution of Sybase Central and the Adaptive Server plug-in.
The following Adaptive Server version 12.5.4 features are also provided with this distribution:
Server license (Developer’s Edition)
Java/XML in Adaptive Server
External File System
Component Integration Services
Row Level Access Control
Security
Backup Server
XP Server
ODBC Driver from Open Link Software, Inc.
Client Tools
Job Scheduler