SQL Anywhere 12 plug-in

You can use the SQL Anywhere 12 plug-in to upgrade existing databases, create new databases, and administer databases. You can choose the mode from the Mode menu or by clicking the toolbar button for the mode.

The SQL Anywhere 12 plug-in can operate in any of the following modes:

  • Design mode   While working in Design mode, you can create and modify database objects such as tables, users, triggers, indexes, remote database servers, and so on. You can also add data to tables, create new databases, and upgrade existing databases.

    For information about tasks you can perform on a SQL Anywhere database while in Design mode, see Tables, views, and indexes.

  • Debug mode   While working in Debug mode, you can use the SQL Anywhere debugger to assist you in developing SQL stored procedures, triggers, and event handlers.

    See The SQL Anywhere debugger.

  • Application Profiling mode   While working in Application Profiling mode, you can configure application profiling or diagnostic tracing for your database. The data that is generated helps you understand how applications interact with the database and can also help you identify and eliminate performance problems.

    See Application profiling.

 Viewing SQL statements and utility commands generated by wizards
 See also

Database objects in the SQL Anywhere 12 plug-in
Comparing database schemas
Converting a database schema to match another
Viewing entity-relationship diagrams from the SQL Anywhere 12 plug-in
Database health and statistics
Documenting a database
Configuring the left pane in Sybase Central
Database change logging