Design and Manage SAP Adaptive Server Enterprise Databases Visually with DbSchema

DbSchema lets you design, manage, and document SAP Adaptive Server Enterprise databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the SAP Adaptive Server Enterprise database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download SAP Adaptive Server Enterprise JDBC Driver

Visual Schema Design for SAP Adaptive Server Enterprise

SAP Adaptive Server Enterprise (formerly Sybase ASE) is an enterprise relational database with a multi-database architecture and T-SQL as its query language. Large ASE installations often span dozens of databases within a single server instance, with stored procedures, triggers, and cross-database joins making schema relationships difficult to track. DbSchema renders these relationships visually, letting your team navigate the full schema landscape without querying system tables manually.

Visualize Cross-Database Relationships on a Single Canvas

DbSchema connects to SAP ASE and reads the system catalog across all databases on the server. You can drag tables from multiple ASE databases onto a single ER diagram canvas to document cross-database relationships and trace foreign-key dependencies that span database boundaries.

Designing and editing an SAP ASE schema visually in DbSchema

T-SQL Editor with ASE Syntax Support

The built-in SQL editor in DbSchema supports T-SQL syntax used by SAP ASE, including stored procedure calls, batch separators, and proprietary ASE functions. Run queries directly against your ASE instance and review results in a tabular view without leaving the schema designer.

Running T-SQL queries against SAP Adaptive Server Enterprise in DbSchema's SQL editor

Auto-Generated Schema Documentation for Compliance Teams

DbSchema generates HTML documentation from your ASE schema, including table definitions, column types, indexes, and foreign key relationships. This is particularly useful for compliance audits where teams need a static, shareable record of the database structure that can be reviewed without live database access.

Auto-generated schema documentation for an SAP ASE database in DbSchema

Connecting DbSchema to SAP Adaptive Server Enterprise

SAP ASE listens on port 5000 by default. The JDBC URL format is: jdbc:sybase:Tds:host:5000/dbname. Two JDBC drivers are supported: the open-source jTDS driver (available from SourceForge) and the SAP JDBC4 driver (available from the SAP Support Portal). After downloading the JAR, add it via DbSchema's driver manager under Connections > Manage Drivers. For jTDS, the driver class is net.sourceforge.jtds.jdbc.Driver; for SAP JDBC4, use com.sybase.jdbc4.jdbc.SybDriver. Ensure network connections are enabled on the ASE server and the target login has access to the required databases.

Why DbSchema for SAP ASE

  • Visualize schemas across multiple ASE databases on a single diagram canvas
  • Edit table structures and column definitions directly through the DbSchema interface
  • Generate shareable HTML documentation with diagrams for compliance and audit purposes
  • Compare schema versions between development and production ASE instances
  • Store schema models locally and work offline when the ASE server is not accessible