DB PowerStudio

Relational Database Management and Development Tools for Multiple Platforms

Database professionals need to minimize the time and effort spent on the routine management and development of databases across the organization. To address this challenge, benefit from IDERA’s bundle of top tools for managing and developing multiple database platforms.

Perform database administration
Automate and manage complex database schema changes
Automate SQL query tuning and profiling
Develop SQL code efficiently

DB PowerStudio provides complete database management and development, from administration and change management to query tuning and development, for multiple database platforms. Save by bundling versus buying each product separately. Plus, save an additional 20% when you purchase in the online store.

Info

What is DB PowerStudio?

DB PowerStudio is a highly-intuitive toolset that helps simplify cross-platform database administration, development, and performance tuning.

Designed for database teams that work in mixed DBMS environments, DB PowerStudio complements native tools with critical capabilities such as database change management and SQL optimization and tuning. DB PowerStudio supports all popular DBMSes, including Oracle, SQL Server, Sybase ASE, DB2, and more. Whether producing on-the-fly, DBMS-specific language conversions or creating new users across the entire enterprise, consistent workflows make it easy to extend one’s expertise into less familiar DBMSes.

Take your database administration and development capabilities to the next level with visual diagnostics that not only help you pinpoint problematic queries but also determine the best solutions. A unique Visual SQL Tuner saves hours or days when tuning problematic SQL. You’ll also enjoy deep change management functionality for coordinating database changes across the development life cycle or enforcing database configuration standards across your entire enterprise.

News

What’s new in DB PowerStudio?

PowerStudio Developer Edition

The Visual Advantage – Fast, Accurate, SQL Code with Rapid SQL
Fast, Visual SQL Tuning with DB Optimizer
Database Change Management Made Simple with DB Change Manager

PowerStudio DBA Edition

Faster, Smarter Database Administration and Change Management with DBArtisan and DB Change Manager
Maximize Database Performance and Availability with DBArtisan and DB Optimizer
Tune your database with DB Optimizer.

Editions

DB PowerStudio Editions

PowerStudio is offered in two versions, Developer Edition and DBA Edition

DB PowerStudio, Developer Edition

DB PowerStudio, Developer Edition includes everything you need to improve quality and performance at
each stage of the application development life cycle.

Write High-Quality SQL Code Faster with Rapid SQL®

Move effortlessly from managing a SQL Server or Sybase ASE schema to managing an Oracle schema and vice-versa.
Debug programmable objects such as stored procedures, functions and triggers.
Simplify SQL scripting, query building, object management, project management, and version control in live databases or offline source repositories. Visually Tune SQL against the database with DB Optimizer.
Relate resource utilization to specific queries and visually tune the problematic SQL using Visual SQL Tuning Diagrams.
Analyze and tune complex SQL statements, including bind variables
Access robust reporting with execution statistics, profiling details, predicate analysis, and explain plans. Simplify Database Change Management with DB Change Manager.
Work with multiple DBMS brands and versions from a single toolset
Compare your development and test servers to quickly identify changes and generate the synch scripts to correct any problems
Mask test data to comply with privacy laws

DB PowerStudio, DBA Edition

DB PowerStudio, DBA Edition provides DBArtisan® for advanced database administration capabilities, as well as the ability to schedule and run multiple change management jobs at any time.

Simplify Database Administration and Change Management with DBArtisan and DB Change Manager

Work with multiple DBMS brands and versions from a single toolset
Easily carry out complex actions such as schema extraction, schema migration, and data load and unload
Compare a live database to a schema or configuration “snapshot” to quickly identify changes and correct problems
Maximize Database Performance and Availability with DBArtisan and DB Optimizer
Use the optional DBArtisan Performance Analyst, Capacity Analyst and Space Analyst to see detailed metrics that identify performance, capacity planning, and storage management issues before they become problems
Eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times), by relating resource utilization to specific queries, and by helping you visually tune problematic SQL
Use powerful database monitors, intelligent diagnostic information and strong drill-down details to find and fix performance issues quickly

Support

Resources

We recommend these online support pages and resources to make the most of your product.

Support

We offer technical support to all Alfasoft customers. We recommend visiting our Help Centre and Knowledge Base, where you will find helpful resources, including solutions to frequently encountered issues and a wealth of additional information.

If you cannot find the answer, please submit a support ticket at the Help Centre and Knowledgebase. When creating your ticket, please provide as much detail as possible. This will help us better understand the issue and provide a more accurate solution. Always remember to provide information about your product version and operating system.