NEW FEATURES SUMMARY
Unicode support
DBArtisan now includes Unicode support throughout the application, allowing you to
work with data in different languages and display the text correctly on screen.
Datasource Explorer tree filtering
This release introduces a number of techniques for filtering the Datasource Explorer
view. On-the-fly filtering lets you filter tree nodes as you work. Object filters, defined
and enabled at either the DBMS or datasource level, let you filter display by object
name/schema. Node filtering lets you hide or display object types by DBMS platform.
ISQL Editor updates
The SQL parsing components have been upgraded for this release. The new
components provide the following benefits when creating or editing scripts:
• Increased performance – Parsing activity is much faster than in previous
releases.
• Platform concurrency – The ISQL editor now supports syntax and features of the
most recent DBMS versions supported by DBArtisan.
• Accuracy – Syntax issues in previous releases of DBArtisan have been corrected.
New editor features are also provided. The ISQL Editor has been enhanced with a set of
automated validation and code assistance features. On-the-fly syntax-checking locates
and diagnoses syntax errors as you type. Semantic validation eliminates typographical
errors and helps avoid outdated references in specified object names. Code assist
analyzes statements as you type and offers intelligent suggestions with regard to object
names
Query options customizing the execution environment can now be saved and loaded.
The frequency with which the options are sent to the server has been optimized.
Microsoft SQL Server exploitation
Index support in DBArtisan has been upgraded to account for newer Microsoft SQL
Server index functionality. You can now rebuild, reorganize, and disable indexes,
primary keys, and unique keys. As well, when creating, dropping, or rebuilding indexes,
primary keys, or unique keys, online options are available with these operations. This
release also offers sparse columns, MAXDOP support, and page and row locking.
IBM DB2 for Linux, Unix, and Windows exploitation
DBArtisan now supports the following recent upgrades to IBM DB2 for Linux, Unix, and
Windows functionality:
• IMMEDIATE and DEFERRED options when editing buffer pools
Embarcadero Technologies 4