DB PowerStudio XE2, DBA Edition is a highly-intuitive toolset that helps simplify cross-platform database administration and performance tuning. DB PowerStudio XE2 comes complete with support for all popular DBMSes, including Oracle, SQL Server, Sybase ASE, DB2, and more. Designed for DBAs that work in mixed DBMS environments, DB PowerStudio XE complements native tools with critical capabilities such as database change management and SQL optimization and tuning.
DBAs can now take their database administration capabilities to the next level. Whether it’s 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. DB PowerStudio XE2’s deep tooling offers unique capabilities. Visual diagnostics not only help pinpoint problematic queries, but also determine the best solution. A Visual SQL Tuner can save hours or days of time when tuning problematic SQL statements. And deep change management functionality not only successfully coordinates database changes across the development life cycle, but also enforces database configuration standards.
DB PowerStudio XE2 provides DBAs with Embarcadero’s industry-leading XE2 database tools at an unbeatable value.
This DBA Edition includes:
-
DBArtisan XE2 – the industry’s premier database administration tool
-
DB Optimizer XE2 – visually profile key metrics inside the database and optimize SQL using the Visual SQL Tuner
-
DB Change Manager Enterprise XE2 – simplify, automate, and report on database changes
DB PowerStudio XE2, DBA Edition provides DBAs with everything they need to:
-
Work with multiple DBMS brands and versions from a single toolset
-
Develop, test, profile and tune SQL in an easy-to-use IDE
-
Eliminate performance bottlenecks in production databases and applications
-
Adopt reliable, repeatable and trackable database change management best practices
-
Ensure database performance and compliance
Enjoy these DB PowerStudio XE2, DBA Edition capabilities:
Simplify Database Administration and Change Management
-
Save time with its highly-visual, intuitive user interface that streamlines and automates common and repetitive tasks
-
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
-
Eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times), relating resource utilization to specific queries, and by helping you visually tune problematic SQL
-
Tune single statements or a batch of statements, including DML statements, stored routines, and entire SQL files
-
Use powerful database monitors, intelligent diagnostic information and strong drill-down details to quickly find and fix performance issues
Maintenance
Price above does not include Maintenance, which is required to be purchased on the first year. 1 Year Maintenance will be added to your shopping cart when you purchase the license.
Maintenance entitles customers to:
-
Unlimited technical support
-
All product upgrades
-
Closed beta programs
-
Product answer books
DBMS Support
DBArtisan XE, DB Optimizer XE2 and DB Change Manager Enterprise XE all include support for the following DBMSes:
-
Oracle 8i – 11g
-
SQL Server 2000 – 2008 R2
-
Sybase ASE 12.5 – 15.x
-
DB2 for LUW 8 – 9.x
DBArtisan XE2 also adds support for:
-
DB2 for OS/390 and z/OS 8.x and 9.x
-
MySQL 4.x and 5.x
DB Change Manager Enterprise XE2 adds support for:
-
DB2 for LUW 9.5
-
InterBase 2007, 2009
-
Firebird 1.5, 2.0
System Requirements
-
Windows 2003 - Windows 7; see product pages of individual products for more detailed system requirements information
File Size