Using the SQL Anywhere plug-in

You can use the SQL Anywhere 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 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.

See also

Copying database objects in the SQL Anywhere plug-in
Viewing entity-relationship diagrams from the SQL Anywhere plug-in
Monitoring database health and statistics
Documenting a database