 Faster, Smarter Database Administration with DBArtisan
DBArtisan gives DBAs the capabilities to maximize availability, performance, and security of their databases by providing a consistent and unified view for all major database platforms in one tool. Comprehensive graphical editors and wizards boost productivity, streamline routine tasks, and reduce errors so DBAs can manage larger, more complex databases. Learn more >
 Fast, Accurate SQL Code with Rapid SQL
Rapid SQL helps developers and DBAs produce high performance SQL code at lightening speeds. With support for all major database platforms from a single interface, teams can standardize on one powerful heterogeneous SQL IDE tool. A rich development environment simplifies SQL scripting, query building, object management, project management, and version control in live databases or offline source code repositories. Learn more >
 Accelerate SQL performance tuning with DB Optimizer
DB Optimizer is a heterogeneous tool that accelerates performance tuning for DBAs and developers by quickly discovering, diagnosing, and optimizing poor-performing SQL. Prevent, find, and fix performance issues via visual SQL profiling and tuning. Eliminate performance bottlenecks and fix in minutes what would have previously taken hours or days. Learn more >
 Database Change Management Made Simple with DB Change Manager
Simplify, automate, and report on database changes. Manage database change across development, test and production environments and mask test data to comply with privacy laws. 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. Learn more >
Facilitate Data Governance Initiatives with Database Professionals
DB PowerStudio's suite of database tools empowers DBA's and database developers to align with data governance initiatives. Database administrators can ensure database performance, uptime, and availability with tools such as DBArtisan and DB Optimizer. To maintain data integrity, DB Change Manager helps organizations comply with data governance standards. Also, Rapid SQL gives database developers the functionality to improve data quality.
| DBArtisan |
|---|
| Schema management |
Create, drop, or alter objects such as tables, constraints, indexes, views, procedures, functions, triggers, packages, and more. Moves effortlessly among disparate database schemas using standardized, multi-tabbed editors for each database object type. |
| Security management |
Manage users, logins, profiles, groups, aliases, and password security. Creation and management of roles and accounts. |
| Space, Capacity and Performance Planning |
Provides analysis of database space, capacity and performance information to diagnose and reorganize inefficiencies using intelligent reorganization wizards |
| Data Migration |
Migrates schema objects and associated table data using wizard-driven utilities |
| Rapid SQL |
|---|
| SQL scripting and editing |
Allows users to create, save, and execute all SQL code against databases with ease. SQL editor offers on the fly syntax checking for code and object names, object lookup and code complete, bind variable support, selective statement execution. |
| Object creation and editing |
Create, drop, or alter objects such as tables, constraints, indexes, views, procedures, functions, triggers, packages, and more |
| Debugging and Performance Optimization |
Diagnose and correct both fundamental query errors and conceptual errors in query design that impact performance. Performs detailed response time analysis on the execution of stored procedures and functions. |
| Version Control |
Seamless integration with most commercial source code control systems |
| DB Optimizer |
|---|
| Profiling |
Drill down into the execution details for any given statement, including the SQL text, events, sessions, child cursors, blockers, procedures and other SQL details |
| SQL Tuning |
Create and run tuning jobs for a single statement or batch of statements. SQL rewrites and hint injection are used to generate all possible cases and find the best alternative to a given SQL statement. |
| Reporting |
Reports generated to present diagnostic information and issues related to database performance |
| Load testing |
Testing the performance and scalability of databases with varying user loads |
| DB Change Manager |
|---|
| Schema comparison and synchronization |
Comparison and synchronization capabilities across various DBMS schemas. DBAs often have to build a synchronization script to apply development changes to production. |
| Data comparison and synchronization |
The ability to compare data between tables or across entire schemas, report on differences and synchronize changes |
| Auditing |
Schema and configuration archives provide historical record for compliance auditing and reporting |
| Reporting |
Outlines what objects have actually changed, either between schema archives, live data sources or both. DDL differences are color-coded for easy comparison. |
DB PowerStudio Product Editions
DB PowerStudio is available in two editions – Developer and DBA edition, both of which have platform-specific and XE versions.
Developer Edition – Designed for Database Developers or Project DBAs in need of capabilities to monitor and manage database processes and to set up database work environments.
DBA Edition – Designed for Production or Operational DBAs for robust management of their database environments.
| DB PowerStudio, Developer Edition | DB PowerStudio XE, Developer Edition | DB PowerStudio, DBA Edition | DB PowerStudio XE, DBA Edition |
|---|
| Designed for |
Database Developer / Project DBA |
Developers working with multiple platforms |
DBA |
DBAs working with multiple platforms |
| Latest Version |
– |
XE3.5 |
– |
XE3.5 |
| Previous Version |
March 2013 |
March 2013 |
March 2013 |
March 2013 |
| DBArtisan |
|
|
‡ |
β |
| Rapid SQL |
✓ |
β |
✓ |
β |
| DB Optimizer |
✓ |
β |
✓ |
β |
| DB Change Manager |
✓ |
β |
† |
β |
| AppWave Licensing |
|
✓ |
|
✓ |
| Connect to all database platforms |
|
✓ |
|
✓ |
✓ denotes Professional Edition
† denotes Enterprise Edition
‡ denotes Workbench Edition for SQL Server and Professional Edition for other platforms
α denotes Professional Edition for SQL Server only
β denotes XE3.5 Edition
Platform-specific Versions – These products support one major platform. DB PowerStudio for Oracle, DB PowerStudio for SQL Server, DB PowerStudio for Sybase, and DB PowerStudio for DB2 are available.
XE Version – Grants the license holder the ability to connect to multiple supported database platforms within the same User Interface, with no need to purchase additional platform-specific software. These users can connect to Oracle, SQL Server, Sybase, and DB2 (LUW & z/OS) platforms simultaneously.
|
DB PowerStudio on Facebook
DB PowerStudio on Google+
DB PowerStudio on Twitter
Data Modeling Blog