Chart Cross-Database Relationships in SAP ASE

SAP Adaptive Server Enterprise — Sybase ASE to the teams that have run it for decades — packs dozens of databases into one server, joined by T-SQL procedures and cross-database queries. DbSchema reverse-engineers all of them and untangles the dependencies visually.

Foreign-key dependencies traced across database boundaries
T-SQL editor with stored procedures, batch separators, ASE functions
HTML documentation for compliance audits, no live access needed
Reverse engineering and the T-SQL editor cost nothing — Pro adds environment diffing

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema charting SAP Adaptive Server Enterprise databases as ER diagrams

Trusted by teams at

Decades of Sybase OLTP
Split Across One Server's Databases

A large ASE installation is rarely one database — it is dozens on a single server, with stored procedures reaching sideways and joins that cross database boundaries. Tracking those relationships means querying system tables by hand, one sysobjects at a time.

DbSchema reads the catalog of every accessible database on the server and lets you place their tables side by side on the same diagram.

Chart, Edit & Document
ASE Schemas Visually

The system catalog, turned into something a team can navigate.

Reverse engineer SAP ASE databases across the whole server

Cross-Database Dependencies, Drawn

Drag tables from multiple ASE databases onto one canvas and trace the foreign-key dependencies that reach across database boundaries.

Edit SAP ASE table structures visually in DbSchema

Edit Structures Without Sysadmin SQL

Change tables and column definitions through dialogs, and keep sprawling schemas readable with focused, color-coded diagram layouts.

Generate compliance-ready documentation of SAP ASE schemas

A Record Auditors Can Review Cold

Generate HTML documentation of tables, columns, indexes, and foreign keys — a static, shareable snapshot for compliance reviews without live access.

One Model File
for a Whole ASE Server

The reverse-engineered schema lands in a design model you keep locally — browse it offline, version it, and use it as the baseline Pro diffs against a second environment.

Work with the SAP ASE model while disconnected

Work Disconnected

Open the stored model when the ASE server is unreachable or off-limits.

Compare two SAP ASE environments in DbSchema Pro

Diff Two Environments

Pro compares development against production ASE and works out exactly what differs.

Review the generated ASE migration script before running it

Migration Script Included

The gap between environments becomes a script you read before it runs.

A Versionable Artifact

Being a file, the model drops into the version control your team already runs.

Driver Choice and Server Details

Two JDBC drivers reach ASE: the open-source jTDS driver from SourceForge (class net.sourceforge.jtds.jdbc.Driver) or the SAP JDBC4 driver from the SAP Support Portal (class com.sybase.jdbc4.jdbc.SybDriver). Register the JAR under Connections > Manage Drivers, then enter host and port — 5000 by default — for a URL like jdbc:sybase:Tds:host:5000/dbname.

Network connections must be enabled on the ASE server, and the login needs access to each database you want in the diagram. Full steps are on the SAP ASE JDBC driver page.