Database Development

Database Development provides visual tools to create and debug database objects. You can create, edit, save, debug, and execute procedural objects, real-time messaging statements, and SQL files. From stored procedures, you can derive database services to integrate with business process services, message services, or Web services using Sybase WorkSpace Service Development.

New and changed features include:

For all databases:

Database Explorer view has been integrated into the Enterprise Explorer view.
SQL Scrapbook provides a view (or interface) that is similar to Interactive SQL, and lets you easily enter and execute SQL commands and queries to any target server, as well as create procedural objects without creating a SQL file.
You can now generate DDL for one or more selected objects.
Permissions support (grant/revoke) is available on database objects.
Life cycle (create, edit, drop, rename) support is available for additional database objects: rules, defaults, user-defined datatypes, and constraints.
Use F3 key to open the definition for a table, view, default, or user-defined datatype in SQL File editor.
Visual SQL dialog enhancements:
- Support for CIS proxy objects.
- Support for Sybase Data Federation as a database server.
- Support for DML round-tripping for select, insert, update, and delete statements.
SQL statement templates that enter predefined SQL code, including automatically determined table columns, into a SQL file or procedural object at the desired location. Content Assist provides return/input variable list and any necessary if statements to handle the errors and return codes.
- insert statements: include all table columns and default values once the user enters the value for the table variable.
- select, delete, and update statements: include where clause that includes conditions based on primary key columns.
Ability to add insert statements using the Temporary Table Creation wizard, which allows you to automatically create and populate temporary tables when you are debugging stored procedures.
New cheat sheets:
- Developing a SQL Anywhere Table
- Developing a Sybase IQ Table
- Developing an ASE Table
- Getting Started With Database Development

For Adaptive Server Enterprise 15.0:

Support of computed columns and functional index.
Visual SQL dialog supports new datatypes and large identifiers.
Real-time messaging support for both WebSphere MQ 5.3 and 6.0.
Support for Component Integration Services (proxy table awareness)
- Display proxy tables under the ASE database connection profile in Enterprise Explorer.
- Proxy table awareness in the Visual SQL dialog.
- SQL File editor support of proxy table syntax, including proxy table objects in Content Assist.

For Sybase IQ:

Index creation wizard, and table schema editing using the Table Schema editor.
Support for the index advisor which can help you select the best possible index attributes.
Support for global temporary table creation, manipulation, and interaction in debugging mode.

For RepConnector:

Support for the RepConnector connection profile.
Ability to view and edit Event schema using Service editors.
Ability to create RepConnector formatters and senders.
Better handling of database event messages in a business process.

For Replication Server:

A wizard to help you execute or generate a script to mark tables and procedures for replication.
Ability to simultaneously drop multiple artifacts.

For additional information on using Database Development, see the WorkSpace 2.0 Database Development online documentation.