VI

Database

IDERA DB PowerStudio 18.0.0 DBA

DB PowerStudio combines four innovative solutions to help build and maintain mission-critical database applications, streamline the database change management process, and quickly pinpoint and fix performance bottlenecks.

DBArtisan

Perform Multi-plat...

Description

DB PowerStudio combines four innovative solutions to help build and maintain mission-critical database applications, streamline the database change management process, and quickly pinpoint and fix performance bottlenecks.

DBArtisan

Perform Multi-platform Database Administration

Manage multiple platforms (Oracle, SQL Server, Db2, Sybase) from one UI

Proactively manage space, data and performance with built-in analytics

Easily find and fix performance issues using intelligent diagnostics

Move schema and table data across different platforms with ease

Protect data security with view, grant and revoke of permissions

DB Change Manager

Automate and Manage Complex Database Schema Changes

Quickly roll out and reconcile database changes

Reveal, track, and report on database changes

Comply with database audit and reporting requirements

Protect data privacy within the database environment

Track changes from multiple major database platforms

DB Optimizer

Automate SQL Tuning and Profiling

Streamline tuning of SQL code on major DBMSs from one interface

Tune SQL like a pro with automated performance optimization suggestions

Tackle complex SQL queries with visual SQL tuning diagrams

Pinpoint problem SQL with database profiling of wait-time analysis

Load test alternative SQL queries in simulated production environment

Rapid SQL

Develop SQL Code More Efficiently

Create high-performing SQL code on major DBMSs from one interface

Easily build complex SQL statements with visual query builder

Quickly construct, analyze and execute SQL code with code analyst

Simplify debugging SQL code, functions, and stored procedures

Collaborate effectively across development teams with version control

DB PowerStudio is available in two editions: The DB PowerStudio DBA edition includes all four of the products listed above. The DB PowerStudio Developer edition includes Rapid SQL, DB Optimizer and DB Change Manager.

Additional Information