Following is a list of additions to Sybase Central plug-ins introduced in version 12.0.0.
View the SQL statements and utility commands created by wizards Most SQL Anywhere plug-in wizards that create a database object or run a database utility include a new page at the end of the wizard. This page displays the SQL statements and utility commands that are executed when you click Finish. Clicking Finish executes the SQL statements and/or runs the utility commands.
Alternatively, you can copy the SQL statement to the clipboard, click Cancel to exit the wizard, and then execute the SQL statements via Interactive SQL. This feature allows you to use the wizards to generate SQL scripts without modifying the database. See Viewing SQL statements and utility commands generated by wizards.
Support for spatial data For information about the new plug-in features, including wizards, related to spatial data, see Support for spatial data.
New database Fragmentation tab You can view a graphical representation of the fragmentation of base tables and indexes. The Fragmentation tab provides a graphical representation of the results from running sa_table_fragmentation system procedure on base tables. See The Fragmentation tab (SQL Anywhere plug-in).
Logging database changes You can log all SQL statements executed by the SQL Anywhere plug-in that modify the database. The log is stored in a .sql file. See Database change logging.
Support for WITH NULLS NOT DISTINCT clause, CREATE INDEX statement You can use the SQL Anywhere plug-in to, create, view, and alter indexes that use the WITH NULLS NOT DISTINCT clause. The Indexes folder contains a Nulls Distinct column. The value in the column is blank when the index is a primary key, foreign key, unique constraint, or a non-unique index.
See the UNIQUE clause of the CREATE INDEX statement.
Term breakers The SQL Anywhere plug-in supports external term breakers and prefilters for text configuration objects. See ALTER TEXT CONFIGURATION statement.
Improvements to database documentation When you use the Database Documentation Wizard, the generated documentation contains information about tables. The table information includes the owner name, procedures that modify the table, column information, and comments. See Documenting a database.
Improvements to the Configure Type Filter window The Configure Type Filter window lets you specify which database objects appear in the folder list in the left pane of Sybase Central. You can set your specifications to be the default type filter. Sybase Central uses the default filter whenever it connects to a database that does not have a type filter specified. See Configuring the left pane in Sybase Central.
Improvements to Create Maintenance Plan Wizard Maintenance plans contain user-defined operations. In the Create Maintenance Plan Wizard you can add user-defined operations as SQL statements that execute either before validation or after backup.
In addition, the Maintenance Plans folder now includes a Status column. See Maintenance plan creation.
Improvements to the Create Function Wizard Previously, the Create Function Wizard limited the return type to a built-in type. Now, you can choose either a built-in type or a domain within the wizard. See Creating user-defined functions.
Improvements to the Backup Database Wizard By default the Backup Database Wizard now enables free page elimination. See Making an archive backup with the Backup Database Wizard.
Overview tab enhancement The database Overview tab shows information about the health and statistics of copy servers along with information about database mirroring. See Database health and statistics.
Improvements to the Synchronization Subscription Properties window For databases created with SQL Anywhere 12 and later, the name of the synchronization subscription appears in the Synchronization Subscription Properties window, as well as on the Synchronization Subscriptions tab. For databases that are created with earlier versions of SQL Anywhere, the name appears as (unnamed). See Synchronization subscription creation.
New Synchronize Using Synchronization Profile window You can synchronize a SQL Anywhere database by right-clicking a synchronization profile, clicking Synchronize, and clicking OK. See MobiLink synchronization profiles.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|