DB PowerStudio XE2, Developer Edition is an intuitive, highly-visual toolset that helps developers build and tune mission-critical database applications. DB PowerStudio XE2, Developer Edition comes complete with support for all popular DBMSes, including Oracle, SQL Server, Sybase ASE, DB2, and more. Designed for developers that work in mixed DBMS environments, DB PowerStudio XE2 complements native tools with critical capabilities such as an easy-to-use SQL IDE, database change management and SQL optimization and tuning.
Database developers can take their development capabilities to the next level with visual diagnostics that not only help pinpoint problematic queries, but also determine the best solution. Unique capabilities such as a Visual SQL Tuner can save hours or days of time when tuning problematic SQL statements. Deep change management functionality helps to successfully coordinate database changes across the development life cycle.
DB PowerStudio XE2 provides database developers with Embarcadero’s industry-leading XE database tools at an unbeatable value.
This Developer Edition includes:
-
Rapid SQL XE2 – the fastest way to write quality SQL
-
DB Optimizer XE – analyze and tune complex SQL statements with the Visual SQL Tuner
-
DB Change Manager XE2 – simplify, automate, and report on database changes
DB PowerStudio XE2, Developer Edition provides data management professionals with everything they need to:
-
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 application performance and compliance
Enjoy these DB PowerStudio XE2, Developer Edition capabilities:
Write High Quality SQL Code Faster with Rapid SQL
-
Simplify SQL scripting, query building, object management, project management, and version control in live databases or offline source repositories
-
Debug programmable objects such as stored procedures, functions and triggers
-
Pinpoint performance problems with SQL code by performing detailed response time analysis on the execution of stored procedures and functions
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 database 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 in order to comply with privacy laws
Maintenance
Price above does not include Maintenance, which is required to be purchased on the first year. 1 Year Maintenance costing $624 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
Rapid SQL XE2, DB Optimizer XE and DB Change Manager XE2 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
Rapid SQL XE2 also adds support for:
-
DB2 for OS/390 and z/OS 8.x and 9.x
-
MySQL 4.x
-
InterBase 2007, 2009
-
Firebird 1.5, 2.0
-
Generic ODBC
DB Change Manager 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