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.
There are no reviews yet.