IDERA – DB PowerStudio

IDERA – DB PowerStudio

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.