Datasheet : DB PowerStudio

IDERA DB PowerStudio is a complete database tool suite for comprehensive administration, development and performance tuning capabilities across multiple platforms. Designed for mixed DBMS environments, DB PowerStudio complements native tools with innovative solutions to build and maintain mission-critical database applications, streamline the database change management process, and quickly pinpoint and fix performance bottlenecks.

Why DB PowerStudio?

DB PowerStudio enables customers to design, build, run and maintain their databases and applications in the environments they choose, free from the constraints, costs, and learning curves associated with multiple platform-specific tools.

Product Highlights

DBArtisan is the central console for database administration. It streamlines common tasks and generates critical insight for longterm performance. From a single interface, DBArtisan facilitates the management of major database platforms. The tool’s highly effective wizards arm users with the ability to efficiently perform migrations, monitor database environments, and plan around space, capacity, and performance.

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.

DB Optimizer 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.

DB Change Manager’s 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.

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.

Download This Datasheet Start a FREE Trial of DB PowerStudio
Share This
Contact IDERA:
+1 (713) 523-4433