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 Sybase Central navigation.
New Connections menu In previous releases, you could press F11 to open the New Connection window 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 window has been removed, but pressing F11 opens the Connections menu where you can choose the plug-in you want to use for your connection.
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 12 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 Schedule definition.
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 Maintenance plan creation.
New Restore Database wizard You can now use the Restore Database wizard to restore a database from an archive backup. See Restoring from an archive backup.
A typing completion option has been added to the editor for database object names. See Using text completion.
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.
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 to 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 in Interactive SQL.
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 option [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.
Interactive SQL supports the @data option When starting Interactive SQL at 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 at 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).
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|