A Full Schema View for Edge-Deployed SAP SQL Anywhere

SAP SQL Anywhere runs where administrators aren't — embedded systems, mobile apps, remote sites. DbSchema gives the teams behind those deployments the complete schema picture: diagrams, queries, documentation, and reviewed change scripts.

Tables, views, foreign keys, stored procedures, and events in one diagram
Query the Transact-SQL-influenced dialect without Sybase Central
Publish an HTML schema reference for remote support teams
Compare development against deployed instances and script the difference

available for

ISO-27001 certified

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

Free Download

DbSchema rendering a SAP SQL Anywhere schema as an interactive ER diagram

Trusted by teams at

Self-Managing Databases
Still Deserve to Be Seen

SQL Anywhere is built to run unattended — at retail sites, on devices, inside packaged applications — with replication carrying changes back to central SAP environments. Unattended cuts both ways: the schema at the edge becomes the one nobody has inspected in years.

DbSchema connects through SAP's JDBC driver and renders the complete catalog — stored procedures and events included — as an interactive diagram any teammate can open.

Inspect, Document & Align
Every SQL Anywhere Deployment

From the central development database to the remotest embedded instance.

Reverse engineer a SAP SQL Anywhere catalog into a diagram

The Whole Catalog, Rendered

Tables, views, foreign key relationships, and stored procedure definitions load into the diagram canvas — a clear view of databases that are rarely inspected directly.

Generate an HTML schema reference for SQL Anywhere deployments

A Reference for Sites Without IT

Export a navigable HTML report — table definitions, column types, indexes, relationship diagrams — that support and maintenance teams consult instead of requesting a database login.

Compare two SQL Anywhere instances and generate migration scripts

Changes That Travel Safely

Compare two SQL Anywhere instances, review each difference, and generate the migration script that carries a change from development out to a remote embedded deployment.

Hundreds of Sites Run It
One Model Describes It

The schema lives in a design model file — the single source of truth, whatever each remote site happens to be running today.

Design the SQL Anywhere schema away from the server

Design Away from the Server

Model changes on a laptop long before any remote site is reachable.

Keep the SQL Anywhere model in Git with the application

Versioned Like the Application

Keep the model in Git next to the app that embeds the database.

Read generated SQL Anywhere change scripts first

Scripts You Read First

See the exact SQL a change generates before it leaves your desk.

Roll out SQL Anywhere changes site by site

Roll Out in Order

Apply the same reviewed change to each environment deliberately, one at a time.

SQL Anywhere Connection Facts — sajdbc4.jar, Port 2638

Download sajdbc4.jar from the SAP SQL Anywhere download center — matching the driver version to the server version in use — and add it in DbSchema's driver manager. The server listens on port 2638 by default, and the connection string takes the form jdbc:sqlanywhere:UserID=user;Password=pass;Host=host:2638;DatabaseName=dbname.

The database server must be running and reachable on that host and port before DbSchema connects. Setup details are on the SQL Anywhere JDBC driver page.