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.