DB PowerStudio® for Sybase ASE


Boost Performance Across All Versions of Sybase ASE

All the tools you need to build and maintain mission-critical Sybase ASE database applications.

DB PowerStudio for Sybase ASE is a highly-intuitive toolset that complements Sybase ASE Enterprise Manager with critical capabilities such as database change management and SQL optimization and tuning. Take your database administration and development capabilities to the next level with:

  • a full-featured SQL IDE that helps you write quality SQL faster
  • visual diagnostics that pinpoint problematic queries and determine best solutions
  • a single interface for working with multiple Sybase ASE versions and databases
  • robust analytics which provide insight into database health

Facilitate Data Governance Initiatives with Database Professionals

DB PowerStudio's suite of database tools empowers DBA's and database developers to align with data governance initiatives. Database administrators can ensure database performance, uptime, and availability with tools such as DBArtisan and DB Optimizer. To maintain data integrity, DB Change Manager helps organizations comply with data governance standards. Also, Rapid SQL gives database developers the functionality to improve data quality.

Download your 14-day free trial and you will quickly discover what thousands of database professionals have enjoyed for years— point-and-click workflows that help you get your jobs done faster.

DB PowerStudio Makes it Easy, with Developer and DBA Editions

DB PowerStudio for Sybase ASE, Developer Edition

Everything you need to build and maintain mission-critical Sybase ASE database applications.

Click to see full size

WThe Visual Advantage - Fast, Accurate, SQL Code with Rapid SQL

The rich visual environment found in Rapid SQL streamlines the task of creating SQL code. Rapid SQL includes visual tools for ad-hoc data editing and simple-to-complex query building. Prevent errors with scripting support features such as syntax checking and auto-complete. Quickly produce code with built-in hot keys, column lookup and code templates.

  • Simplify SQL scripting, query building, object management, project management, and version control in live Sybase ASE databases or offline source repositories
  • Debug programmable objects such as stored procedures, functions and triggers
  • Pinpoint performance problems with SQL code by performing detailed response time analysis on the execution of stored procedures and functions
Click to see video

Fast, Visual SQL Tuning with DB Optimizer

DB Optimizer XE3 takes SQL tuning beyond standard hint injections and SQL rewrites and offers innovative features for faster and more advanced SQL tuning and analysis. Graphical tools, like the Index Analysis feature, let DBAs and developers fully examine SQL execution paths to better understand which indexes are used, not used, or missing.

  • Relate resource utilization to specific queries, and visually tune the problematic SQL using Visual SQL Tuning Diagrams
  • Analyze and tune complex SQL statements, including bind variables
  • Access robust reporting with execution statistics, profiling details, predicate analysis and explain plans
Now it's easy to compare and synch your Sybase ASE databases
Click to see video

Database Change Management Made Simple
with DB Change Manager

DB Change Manager XE3 compare, synchronization, and auditing capabilities let you track and report on changes, roll out new releases, and pinpoint performance problems resulting from changes in data, schema and database configuration. By comparing a live database to a schema or configuration "snapshot" administrators can quickly identify changes and correct problems.

  • Work with multiple Sybase ASE versions from a single toolset
  • Compare your development and test servers to quickly identify changes and generate the synch scripts to correct any problems
  • Mask test data in order to comply with privacy laws

Products included in DB PowerStudio for Sybase ASE, Developer Edition:

Full-featured SQL IDE helps you write quality SQL faster. This easy-to-use SQL IDE also encourages team collaboration and can connect to source control systems.
Simplify, automate, and report on database changes. Manage database change across development, test and production environments and mask test data to comply with privacy laws.
Prevent, find, and fix performance issues via visual SQL profiling and tuning. Eliminate performance bottlenecks and fix in minutes what would have previously taken hours or days.

"With 500 users and six years of active use, Embarcadero's database tools help us maintain our Sybase ASE databases and applications at peak performance.

As just one example, Rapid SQL has proved to be an outstanding SQL IDE for our Sybase ASE SQL development teams"

- Senior Application Support Manager Fortune 1000 Mortgage Investment Company.