Simplify cross-platform database development,
administration, and performance tuning

DB PowerStudio XE3

powerpie_xe220220

The Multi-Database Toolset for Database Management Professionals

DB PowerStudio XE3 is the choice of today's database management professionals.

Demands for always-on, high-performing enterprise databases have never been greater. But with the need to achieve more with less, database professionals continually look for innovations to help them meet corporate expectations.

DB PowerStudio XE3 is the latest suite in a line of award-winning database tools for DBAs and database developers.

  • Connect to multiple, heterogeneous databases with no client required;
  • Automated SQL rewrites to quickly optimize queries;
  • Full-featured visual SQL tuning capabilities from inside the SQL editor.

DB PowerStudio XE3 is a highly-intuitive toolset that complements native tools with critical capabilities such as visual SQL optimization and tuning. It comes complete with support for all popular DBMS's, including Oracle, SQL Server, Sybase ASE and DB2.

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 XE3, Developer Edition

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

Step through the debugging process and get best practices along the  way
Click to see full size

The 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.

  • Support for all seven database platforms included in a single, affordable license
  • Go global with full Unicode character and enhanced currency support
  • Three new object filtering capabilities
  • On-the-fly SQL syntax alerts, semantic validation, and SQL parsing
  • Full object look-up through-out the SQL statement
  • Code complete with dynamic "walk-throughs"
  • Quick export and import of registered data source information
Unique VST capability allows you to see that this big statement is actually a materialized view
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

  • Stream profiling data into a central repository
  • Determine resource usage for stored procedures with visibility into underlying SQL usage for SQL Server and Sybase
  • Visual SQL tuning diagram displaying indexes and constraints, now enhanced with table statistics
Now  it's easy to compare SQL Server 2005 to 2008 R2, find a missing column and produce the synch script
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 database brands and 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, XE3 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.
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.
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.
 

"Most of our developers work on a single platform but have to go back and maintain legacy code on another platform,

XE gives us one tool, a single interface to streamline managing multiple database platforms, saving us time, money and hassle."

- Doug MacDiarmid, Applications Support Specialist,
Synarc
Read the full Case Study >>