Embarcadero DBArtisan XE2

New Features

What's new in DBArtisan XE2/9.0

IBM DB2 LUW v9.7 Support

• DBArtisan XE2/9.0 now provides support for IBM DB2 for Linux, Unix, and Windows v9.7. All current DBArtisan functionality is now available on this platform version.

SQL Server Feature Support

• Synonym support, fixed server role LOGIN member assignment, table and indexing partioning, full-text search support, DLL triggers.

Oracle Feature Support

• ASM disk group support, DBMS_STATS support, virtual columns, unusable index partition visibility, temporary tablespace group support, invisible indexes, read-only table support, online reorganise tables option, recycle bin support, flashback table action support.

Sybase Feature Support

• Login trigger support, support for sp_hidetext, INSTEAD OF triggers, user-defined functions, data cache partitions support, data cache object binding support.

DB2 z/OS Feature Support

• Additional status/performance information.

Datasource/Server Updates

• JDBC driver updates, current session role activation.

Unicode Updates

• Improved encoding detection and options when saving and opening files, additional UTF-8, UTF-16, and UTF-32 encodings with BOM and endian variations are now available, handling of surrogate paris and characters made up of multiple unicode (LTR scripts only) have been brought in line with Windows Vista and Windows 7 support.

SQL Editor

• Query Options supporting Sybase Set Option Text format messages.

Performance Analyst Updates

• Availability of 'sp_sysmon noclear' option against Sybase Datasources.

Features

General

• Supports all major DBMSs (database management systems) - IBM DB2 for LUW, z/OS and OS/390, Microsoft SQL Server, MySQL, Oracle and Sybase
• Graphical editors and wizards help to improve productivity and provide a common interface to manage multiple tasks on multiple database platforms, improving manageability
• Integration with Microsoft Windows Task Scheduler
• Unicode support

SQL Management

• SQL editor offers syntax checking for code and object names, object lookup and code completion
• ISQL facility for creating, saving and executing SQL statements against your database
• SQL analysis provides code explanation and performance execution analysis for SQL code
• Visual query builder makes it easy to construct even the most complex queries

Schema Management

• Visually create, drop or alter a wide variety of database objects

Data Management

• Visual data editor enables users to add, edit and delete data whilst retaining referential integrity
• Easily migrate schema objects and associated table data using wizards

Security Management

• Manage users and their associated information
• Manage roles, grant and revoke roles
• Migrate accounts between multiple database platforms
• Categorise data according to the level of security and privacy that should be applied to it

Performance Management

• Proactively monitors your database and provides warning on performance, capacity planning and storage management issues before they become major problems
• Monitor actively connected users and other session related data.

System Req.

• Windows XP (32-bit and 64-bit) , Windows Vista (32-bit and 64-bit), Windows 7 (32-bit and 64-bit)
• Support for 64-bit environments require installation of a 32-bit DBMS client
• 1024 MB memory
• 512 MB disk space
• DBMS Client connectivity utilities
• Embarcadero Performance Analyst requires Internet Explorer 5.5 or later
• Power User or Administrator privilege required to run software.