|
Following is a list of additions to Sybase Central and Interactive SQL introduced in version 10.0.0.
This section describes new features in Sybase Central. Changes and additions made to the Sybase Central plug-ins are described in the following sections:
Sybase Central Task list You can choose to view tasks in the left pane of Sybase Central, instead of a tree structure of the database. The Task list shows common tasks related to the object that is currently selected. The Task list includes common tasks, navigation options, and links to the documentation. See Panes.
New Connections menu In previous releases, you could press F11 to open the New Connection dialog that let you choose the plug-in you wanted to connect with. Sybase Central now provides a Connections menu where you can choose the plug-in you want to use. The New Connection dialog has been removed, but pressing opens the Connections menu where you can choose the plug-in you want to use for your connection.
Connection profile enhancements You can now add descriptions to Sybase Central connection profiles. Connection profiles can also be imported and exported.
Plug-in searches You can now search for objects that contain specified text within the plug-ins and databases in Sybase Central by choosing View > Search Pane.
Context dropdown list The new Context dropdown list shows you the object that is currently selected in the object tree to make it easier to navigate through plug-ins, especially when the object tree is not open in the left pane.
Deadlocks database tab When you are connected to a SQL Anywhere database in Sybase Central, you can view information about deadlocks on the Deadlocks tab. See Viewing deadlocks from Sybase Central.
Entity-relationship diagrams Sybase Central displays entity-relationship diagrams for databases, showing the tables in the database and their foreign key relationships. See Viewing entity-relationship diagrams from the SQL Anywhere plug-in.
New Create Schedule wizard and other enhancements to the Events folder For each scheduled event, the Events folder now displays the next scheduled time when the event will be triggered. For each conditional event, the folder displays the system event and optionally the trigger conditions that trigger the event. Schedules are created using the new Schedule Creation wizard. When creating a new scheduled event, the Event wizard allows you to create a single schedule, but you can later add additional schedules to an event if required. See Defining schedules.
Maintenance plans You can set up a schedule for validating and backing up a database automatically and have the output log emailed to you. See Creating a maintenance plan.
New Restore Database wizard You can now use the Restore Database wizard to restore a database from an archive backup. See Restoring an archive backup.
Editor enhancements for Sybase Central and Interactive SQL You can choose the font used in the editor windows of Sybase Central and Interactive SQL on the Format tab of the Options dialog.
A typing completion option has been added to the editor for database object names. See Using text completion.QAnywhere plug-in The QAnywhere plug-in provides an easy-to-use graphical interface for creating and administering your QAnywhere applications.
See New QAnywhere plug-in for Sybase Central.UltraLite plug-in The UltraLite plug-in allows you to create, modify, and administer your UltraLite databases in a graphical user interface.
See Graphical administration tools.MobiLink Create Synchronization Model wizard and Model mode You can now create a synchronization model using a wizard, and edit your model in the MobiLink plug-in using the new Model mode. You can also set up MobiLink server-initiated synchronization. The old features of the MobiLink plug-in have also been enhanced and are preserved in Admin mode.
See Enhancements to the MobiLink plug-in in Sybase Central.Interactive SQL can connect to UltraLite databases You can now use Interactive SQL to develop and test SQL statements with UltraLite databases. The ulisql utility has been deprecated. See Graphical administration tools.
Interactive SQL integrates with third party source control systems Interactive SQL can integrate with third party source control systems, allowing you tp perform a number of common source control operations on files from within Interactive SQL, such as checking in, checking out, and comparing against old versions. See Source control integration.
New Interactive SQL options The isql_maximum_displayed_rows option lets you specify the number of rows that appear in the result set in Interactive SQL, while the isql_show_multiple_result_sets option specifies whether multiple result sets can appear in the Results pane in Interactive SQL. See isql_maximum_displayed_rows option [Interactive SQL] and isql_show_multiple_result_sets [Interactive SQL].
Text completion Interactive SQL now includes a typing completion option that can fill in the names of the following object types: tables, views, columns, stored procedures, and system functions. See Using text completion.
DESCRIBE statement now supported by Interactive SQL The DESCRIBE statement enables you to obtain the following information about a specified table or procedure:
Interactive SQL supports the @data option When starting Interactive SQL from a command prompt, you can specify the @data option to read in options from the specified environment variable or configuration file. See Interactive SQL utility (dbisql).
SQL Anywhere Console supports the @data option When starting the SQL Anywhere Console from a command prompt, you can specify the @data option to read in options from the specified environment variable or configuration file. See SQL Anywhere Console utility (dbconsole).