Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.

Product Information

DB PowerStudio XE is an intuitive, highly-visual toolset with powerful capabilities such as database change management and SQL optimisation and tuning that complement native database management tools. With DB PowerStudio XE you get cross-platform database development and administration with support for all popular database management systems including Oracle, SQL Server, Sybase ASE and DB2.

Take advantage of DB PowerStudio XE and get:

• A full-featured SQL IDE that helps you write quality SQL faster
• Visual diagnostics that pinpoint problematic queries and determine best solutions
• Consistent workflows to more easily manage multiple database systems
• Robust analytics which provide insight into database health.

Documents & Downloads

Editions

DB PowerStudio XE - Developer Edition

Perfect for database developers who need to work with multiple database brands and versions from a single toolset. Includes:

• Rapid SQL XE - powerful SQL IDE with query building and editing capabilities, debugging functionality and more
• DB Change Manager XE - provides tracking and reporting on database changes, can compare schemas and data between databases and also mask test data to comply with privacy laws
• DB Optimizer XE - SQL performance optimisation tool to discover and optimise poorly performing queries.

DB PowerStudio XE - DBA Edition

Perfect for database administrators who need to work with multiple database brands and versions from a single toolset. Includes:

• DBArtisan XE - powerful database administration tool. Provides graphical editors and wizards to streamline routine tasks and reduce errors so you can manage larger, more complex databases
• DB Change Manager XE Enterprise - provides tracking and reporting on database changes, can compare schemas and data between databases and also mask test data to comply with privacy laws, plus adds a command-line generation wizard to generate batch or ANT scripts so that you can schedule and run change management jobs at anytime
• DB Optimizer XE - SQL performance optimisation tool to discover and optimise poorly performing queries.

DB PowerStudio XE - DBArtisan Analyst Pack

The optional purchase of the DBArtisan Analyst Pack provides additional functionality for DBArtisan:

• Space Analyst - analyse database space information to pinpoint space-related exceptions. Provides assistance in diagnosing and reorganising storage inefficiencies using an intelligent reorganisation wizard
• Performance Analyst - analyses real-time database and OS performance information to troubleshoot and remedy performance problems
• Capacity Analyst - collects and stores key database metadata and performance metrics and performs trend analysis to forecast database growth and usage.