Using the 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 more information about tasks you can perform on a SQL Anywhere database while in Design mode, see Working with database objects.

  • 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.

    For more information about using Debug mode, see Debugging procedures, functions, triggers, and events.

  • 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.

    For more information about using Application Profiling mode, see Application profiling.

 Viewing SQL statements and utility commands generated by wizards
 See also

Copying database objects in the SQL Anywhere 12 plug-in
Viewing entity-relationship diagrams from the SQL Anywhere 12 plug-in
Monitoring database health and statistics
Documenting a database
Configuring the left pane in Sybase Central
Logging database changes