Design and Manage SAP SQL Anywhere Databases with DbSchema
Build a clearer workflow for SAP SQL Anywhere: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See SAP SQL Anywhere Features Download SAP SQL Anywhere JDBC Driver
What happens after you download?
Get to your first SAP SQL Anywhere schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to SAP SQL Anywhere or open a sample
Reverse engineer an existing SAP SQL Anywhere database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
Full-Featured Schema Tools for Edge and Embedded SAP Deployments
SAP SQL Anywhere is a self-managing relational database designed for edge computing, embedded systems, and mobile deployments where database administration overhead must be minimal. It supports stored procedures, triggers, events, and a replication system for synchronizing remote databases with central SAP environments. DbSchema connects via the SQL Anywhere JDBC driver and exposes the complete schema — including stored procedures and events — in an interactive diagram, helping teams manage SQL Anywhere schema evolution without requiring the SAP Sybase Central GUI.
Download DbSchema Free See SAP SQL Anywhere Features
Connect to SQL Anywhere and Explore the Full Schema
DbSchema reads the SQL Anywhere catalog and renders tables, views, foreign key relationships, and stored procedure definitions in the diagram canvas. The visual overview is particularly useful for SQL Anywhere databases in remote or embedded deployments where the schema is rarely inspected directly.
Write and Execute SQL Queries
The SQL editor supports SQL Anywhere's Transact-SQL-influenced dialect, including procedural extensions and event syntax. Write ad-hoc queries, test stored procedure logic, and inspect result sets directly in DbSchema without requiring Sybase Central or Interactive SQL.
Generate Schema Documentation
DbSchema's documentation generator exports the SQL Anywhere schema as a navigable HTML report including table definitions, column types, index descriptions, and relationship diagrams. For SQL Anywhere deployments at remote sites with minimal IT support, this report serves as an authoritative reference for support and maintenance teams.
Connecting DbSchema to SAP SQL Anywhere
SQL Anywhere listens on port 2638 by default. The JDBC URL format is
jdbc:sqlanywhere:UserID=user;Password=pass;Host=host:2638;DatabaseName=dbname.
Download sajdbc4.jar from the SAP SQL Anywhere download center — ensure the driver
version matches the SQL Anywhere server version in use — and register it in DbSchema's driver
manager. The SQL Anywhere database server must be running and reachable on the specified host and
port before DbSchema attempts to connect.
Why DbSchema for SAP SQL Anywhere
- Visualize SQL Anywhere schemas including stored procedures and events in a single view.
- Run SQL queries from a desktop client without Sybase Central or Interactive SQL.
- Synchronize schema changes between development and production SQL Anywhere instances.
- Generate documentation for remote SQL Anywhere deployments that lack local administrators.
- Track schema evolution with DbSchema's Git integration for version-controlled schema files.