Sybase WorkSpace Database Development for ASE and SQL Anywhere

A sophisticated SQL development tool specifically designed for the ASE and SQL Anywhere platforms.

Sybase WorkSpace simplifies and unifies database development for the ASE and SQL Anywhere platforms with capabilities that support the complete development life cycle for database applications—from development, debugging, testing, to deployment.

Resources

• WorkSpace Database Development White Papers
  • Database Development in Sybase WorkSpace
  • Evaluation and Getting Started Guide For Database Development
  • Using Sybase WorkSpace on Eclipse with SQL Anywhere
• WorkSpace Database Development Videos
• WorkSpace Newsgroup
• WorkSpace Sample App
• WorkSpace Love SQL Development Webcast - On Demand
  View both Peter Thawley, ASE Evangelist and Mike Crocker, WorkSpace Engineering Director, as they discuss how Sybase WorkSpace can make development for ASE and SQL Anywhere faster and more flexible.

Benefits of WorkSpace Database Development for ASE and SQL Anywhere include:

• Visually create and edit database objects, including tables, stored procedures, events and user-defined functions (UDF)
• Navigate and manipulate database objects in the enterprise
• Export and import database objects and services to database servers
• Visually debug stored procedures, triggers, ASA events and UDFs
• Automatic detection and creation of required temp tables
• Leverages the extensibilty of the Eclipse ecosystem
• Support for ASE and SQL Anywhere

Database Development with Sybase WorkSpace provides user-friendly visual SQL development tools to generate and manage SQL code. Rich content assist functionality in data management tooling provides auto-completion for SQL keywords, tables, table columns, parameters, and so on, within the context of the tool used to edit various SQL artifacts (SQL Queries, Stored Procedures, etc.). This code generation can be controlled with a user-definable SQL code template to allow the reuse of repeated SQL code segments. By validating the syntax of the SQL construct before being deployed or executed on the database, Data management tooling reduces the round-trip delay caused by server-side verified SQL. Sybase WorkSpace tooling has the ability to run and debug procedural objects including stored procedures, triggers, events, and user-defined functions.