DBArtisan ReadMe

Welcome to DBArtisan® XE6 and DBArtisan® 9.7.5

DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: May 08, 2015. Any updates to these notes will be available at http://docs.embarcadero.com.

Thank you for using Embarcadero DBArtisan, the award winning DBA tool for enterprise-wide database administration. DBArtisan empowers you to manage all of your critical databases running on current versions of IBM DB2, Oracle, PostgreSQL, Microsoft SQL Server, MySQL, Sybase and Teradata systems, from a single, consistent, user-friendly interface. Before you use DBArtisan, please read the information below.

What's New in Version 9.7.5/XE6

PostgreSQL Utilities

PostgreSQL Object Management

PostgreSQL Updates to the SQL Editor

PostgreSQL Tools Menu Updates

Welcome Window

Project Management, Version Control, and Script Library

Datasource Registration Updates

Trace File Logging

DBMS Platform Updates

Explorer and Database Monitor Updates

ISQL Windows Backup

Connectivity Improvement

Performance Analyst for SQL Server Improvements

Java Update

Improved Multi-Monitor Support

Technical Requirements

Browser Requirements

Hardware Requirements

Operating System Requirements

32-bit versus 64-bit Application Considerations and Restrictions

DBMS Support and Connectivity

Dedicated Support Connectivity Options

Generic JDBC/ODBC Connectivity

Specifically-tested JDBC/ODBC Connectivity Products: Apache Hive/Hadoop

Release Notes

Important Advisory Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in Version 9.7.5/XE6

PostgreSQL Utilities

The following Utilities menu features are now available against PostgreSQL datasources:

Database Monitor - provides details on locks, processes, and prepared transactions.
Database Backup - generates a pg_dump script, backing up one or more tables or views of a database.
Database Restore - generates a pg_restore operation, restoring data from backup.
Data Unload - lets you generate a pgadmin export data call, dumping database data to a file.
Data Load - lets you build and submit a COPY... FROM... call, copying data from a file to a table.
Schema Extraction - walks you through the process of building an extraction script, executing it for storage of the database or object schema in a file.
Schema Migration - migrates schema and table data from one DBMS platform to another.
Schema Publication - lets you generate HTML reports documenting the details of your schema, databases, and database objects.
Reverse Engineering - lets you analyze, control, and document existing database objects.

PostgreSQL Object Management

The following database object-based features are now available against PostgreSQL datasources:

Object Wizards/Editors - You can now create and edit objects of the following types: check constraints, domains, exclusion constraints, foreign keys, functions, indexes, primary keys, roles, rules, schemas, tables, tablespaces, triggers, unique keys, and views.
Object Actions - A new Refresh Materialized View action is available against views created using the CREATE MATERIALIZED VIEW statement. It lets you build and submit a REFRESH MATERIALIZED VIEW statement, to replace the contents of a materialized view. The Create Like action is now available against roles, rules, and tables.
Datasource Explorer - A Performance node is now available in the Datasource Explorer. As with other DBMS platforms, the PostgreSQL Performance node has Locks and Processes subnodes. A Prepared Transactions subnode provides details on transactions that have been prepared for two-phase commit.
In addition, a new Server > Logs node provides access to PostgreSQL logfiles. The associated Rotate Log action signals the log-file manager to immediately switch to use of a new output file.

PostgreSQL Updates to the SQL Editor

The Paste SQL Syntax and Paste SQL Statement features are now available against PostgreSQL datasources.

PostgreSQL Tools Menu Updates

The following Tools menu features are now available against PostgreSQL datasources:

Database Search lets you search for objects whose DDL contains a specified character string, across multiple databases.
Query Builder lets you construct, structure, and manipulate queries using a graphical interface.
Data Editor lets you edit table data in real time.

Welcome Window

The Welcome Window helps customers to get information about product features, news and upcoming events. This window also includes direct links to useful DBArtisan's features like New Project, Open Project or links to Recent Datasources.

Project Management, Version Control, and Script Library

DBArtisan project management facilities act as a repository to maintain all source code for a database project. When you create a new project (File > New > Project), you can initialize the project using one of four methods:

From an existing database
From one or more files (SQL/query scripts, DDL files, ER/Studio files, procedures, Java, Javascript or VB Script files, or text or HTML files)
From a version control project
Uninitialized.

A project opens in a dedicated Project window. In addition to basic project operations (New, Open, Close), Project menu and right-click options provide basic file and folder options. Other key options let you

Specify a build order for your project scripts
Execute the build.

The Project menu also provides access to version control support, also new for this release of DBArtisan. DBArtisan supports any source control product that uses the MSSCCI plug-in interface. Basic version control functions are provided: Get Latest Version, Check In, Check Out, Undo Check Out, Add to/Remove From Version Control, Show History, Show Differences, Version Control Properties, Share From Version Control, and Refresh Status.

NOTE: For the 64-bit version of DBArtisan, a 32-bit version of the MSSCCI Provider can be used for version control access. The feature is controlled from the Options Editor's Version Control tab (File > Options > General > Version Control).

The Script Library (View > Script Library) provides a drag-and-drop library interface of all supported DBMS syntax, SQL syntax, built-in functions, optimizer hints, and SQL-conditional syntax. Additionally, it provides the ability to create custom folders to store commonly-used code for quick and efficient access or execution, as needed.

Datasource Registration Updates

For connectivity purposes, DBArtisan is packaged with a native driver as well as a set of one or more JDBC drivers for each DBMS platform. In previous releases, the native driver for each platform was the default connection option when registering a datasource. The Options Editor's Connection page now has a tab for each supported DBMS platform. Options on each tab introduce two enhancements:

You can now designate one of the JDBC drivers as the default connectivity option for a DBMS platform.
You can universally change the definition for all existing, currently disconnected datasources for a platform to use either the native driver or a JDBC driver as the connection option.

Trace File Logging

As a new diagnostic tool, you can now generate a trace file consisting of the sequence of application event messages. The Options Editor’s Logging page now lets you activate and deactivate, specify a location for, and select a severity level of messages logged. In descending order of severity (and ascending order of total messages logged), Trace Level options are Fatal Errors, Errors, Warning, Info, Debug, Trace, and Max.

DBMS Platform Updates

Sybase IQ 16 - Functionality available for previous Sybase IQ releases is now available against Sybase IQ 16 datasources.
Apache Hive - This release presents a technical preview of Apache Hive support. As with other technical previews, minimal functionality is provided. Features include datasource registration and connection, a minimal Navigator/Explorer tree, and a minimal set of object management features.

Explorer and Database Monitor Updates

Improved numeric column filtering in Explorer and Database Monitor. Users can now filter numeric columns by using operators (>, =, <, <=, >=). When no operator is used, >= is assumed.

ISQL Windows Backup

For Windows Vista and higher, the auto save feature of DBArtisan is now connected to the Restart Manager. Also, unlike the previous version (o Windows XP) all modified ISQL windows will have a backup saved at a regular interval, even those ISQL windows that do not have a file name associated with them. In the event of a crash, those ISQL windows will automatically open up on the next restart. If the Restart Manager is able to detect the crash, it will attempt to automatically restart the application for you. On Windows XP, this feature will function as it did in past versions.

Connectivity Improvement

Connectivity has been improved to have a central location in the options page to set the driver for all datasources of a certain type to use. An individual datasource can override this setting, but by default all datasources will obey the global setting. No longer will customers have to change each individual datasource if they want to use a particular driver for their system.

Performance Analyst for SQL Server Improvements

Performance Analyst improves the space usage functionalities adding information about the database and object that are taking up the most space on the system.

Java Update

DBArtisan has updated to Java 1.7.

Improved Multi-Monitor Support

Users can now detach any MDI tab from the main application window. They can group these detached tabs together or keep them separate.

TECHNICAL REQUIREMENTS

Before using DBArtisan, please verify that your environment meets the requirements listed below:

NOTE: Users need full registry privileges during the installation and access to the keys under HKEY_CURRENT_USER in the registry after installation.

BROWSER REQUIREMENTS

DBArtisan requires Microsoft Internet Explorer 9 or later.

HARDWARE REQUIREMENTS

Embarcadero Technologies recommends the following minimum hardware requirements:

Pentium 4-level processor
1 GB of memory
1 GB of disk space
1024 x 768 display

OPERATING SYSTEM REQUIREMENTS

DBArtisan supports the following operating systems:

Windows XP SP2 (32-bit and 64-bit)
Windows Vista (32-bit and 64-bit)
Windows 7 (32-bit and 64-bit)
Windows 8 (32-bit and 64-bit)

XP Support Notes - Windows XP has two user security groups: Users and Power Users. Microsoft intentionally does not grant members of the Users Group the authority to install applications or make global changes to the system. Restricted Users are members of the Users Group. Standard users belong to the Power Users Group. Microsoft grants members of the Power Users Group the authority to install programs. You must be a member of the Administrators Group in order to install and use Embarcadero Technologies applications. Because Restricted Users are members of the Users Group, they cannot install and run Embarcadero Technologies applications.

Use the Group Membership tab to determine your group and review the Microsoft security guidelines. On the Control Panel, open User Accounts. On the Users tab, select a user and then click the Properties button. Click the Group Membership tab.

Vista and Windows 7 Support Notes - Windows Vista UAC and Windows 7 provide two user types: Standard users and Administrators. DBArtisan can be installed or uninstalled by an administrator or by a standard user using an administrator token. Standard users can run DBArtisan. For the purpose of running DBArtisan, default standard user token privileges should not be modified. Modifying standard user token privileges can result in licensing issues which will prevent DBArtisan from operating properly.

32-BIT VERSUS 64-BIT APPLICATION CONSIDERATIONS AND RESTRICTIONS

If you install the 64-bit version of DBArtisan and you are using custom drivers, you must be using 64-bit versions of those drivers when using the 64-bit version of DBArtisan. Similarly, 32-bit versions of custom drivers must be used with the 32-bit DBArtisan installation.

For version control integration, if you install the 64-bit version of DBArtisan, you can work with either a 32-bit or 64-bit MSSCCI provider. The feature is controlled from the Options Editor's Version Control tab (File > Options > General > Version Control).

DBMS SUPPORT AND CONNECTIVITY OPTIONS

DEDICATED SUPPORT CONNECTIVITY OPTIONS

DBArtisan provides dedicated connectivity to a specific version range of IBM DB2 for Linux, Unix, and Windows, IBM DB2 for z/OS, Microsoft SQL Server, MySQL, PostgreSQL, Oracle, Sybase, and Teradate databases. The following connectivity options are provided:

Native Embarcadero drivers - DBArtisan is packaged with a set of native drivers, each requiring a DBMS-specific client to be installed.
JDBC drivers - DBArtisan can connect to a datasource more directly using one of the packaged, third-party JDBC drivers. No additional connectivity components need to be installed. One or more third-party drvers, tested against DBArtisan, are installed with DBArtisan.

The following table provides a summary of resources/requirements for connectivity to dedicated DBMS platforms. For each platform, it lists supported versions, the client software that must be installed if using native Embarcadero clients, and the third-party, Type 4 JDBC drivers packaged with DBArtisan.

DBMS Platform Supported Versions Client Required for use with native Embarcadero drivers Packaged JDBC Driver

Apache Hive (Technical Preview) * 0.13.1 Simba Hive ODBC Driver ( v1.4.13.1013)
Hortonworks Hive ODBC Driver (v1.4.08.1008)
Cloudera ODBC Driver for Apache Hive (v2.05.10.1003)
Apache Software Foundation - Apache Hive JDBC v0.13.1

IBM DB2 for z/OS v8, v9, and v10 DB2 UDB Client for Windows 8.0 or later IBM Data Server Driver for JDBC

IBM DB2 for LUW Versions 9.0 - 10.0 IBM DB2 LUW Client for Windows 8.0 or later IBM Data Server Driver for JDBC

Microsoft SQL Server 2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64)
2008
2012
2014
Microsoft SQL Server Client Library jTDS Type 4 JDBC Driver for Microsoft SQL Server
Microsoft SQL Server JDBC Driver

MySQL 4.x MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver MySQL Connector/J JDBC Driver

Oracle Oracle 9i, 10g, 11g, and 12c Oracle SQL*Net Client Oracle JDBC Thin Driver

PostgreSQL 9.3 minimum
Specifically-supported PostgreSQL-based database products include Greenplum, Pivotal HAWQ, and BigSQL. PostgreSQL ODBC Driver (latest version recommended) PostgreSQL JDBC Driver

Sybase ASE Sybase 15.7 - Sybase 16 Sybase Open Client jTDS Type 4 JDBC Driver for Microsoft SQL Server
Sybase jConnect JDBC Driver

Sybase IQ 12.7 - 15.4, 16 SQL Anywhere ODBC drivers for Sybase IQ 12.7
Sybase IQ 32-bit ODBC drivers
Sybase jConnect JDBC Driver for Sybase IQ

Teradata (Technical Preview) * 13.10, 14.0, 14.10, and 15.0 Teradata ODBC driver for Windows (version 15 recommended) Teradata JDBC Driver

* About Technical Previews - Technical previews are intended to introduce a new DBMS platform only. Functionality available is typically minimal. For example, command Line startup, standard datasource registration and connection features, limited Datasource Navigator/Explorer tree functionality, a minimal set of object actions, as well as SQL Editor execution and related, common SQL Editor functionality such as Query Options, Paste SQL Syntax, and Paste SQL Statement. Access may not be covered under XE or trial licenses. Contact [email protected] to obtain a separate license for a platform designated as a Technical Preview.

DBMS Platform	Supported Versions	Client Required for use with native Embarcadero drivers	Packaged JDBC Driver
Apache Hive (Technical Preview) *	0.13.1	Simba Hive ODBC Driver ( v1.4.13.1013) Hortonworks Hive ODBC Driver (v1.4.08.1008) Cloudera ODBC Driver for Apache Hive (v2.05.10.1003)	Apache Software Foundation - Apache Hive JDBC v0.13.1
IBM DB2 for z/OS	v8, v9, and v10	DB2 UDB Client for Windows 8.0 or later	IBM Data Server Driver for JDBC
IBM DB2 for LUW	Versions 9.0 - 10.0	IBM DB2 LUW Client for Windows 8.0 or later	IBM Data Server Driver for JDBC
Microsoft SQL Server	2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) 2008 2012 2014	Microsoft SQL Server Client Library	jTDS Type 4 JDBC Driver for Microsoft SQL Server Microsoft SQL Server JDBC Driver
MySQL	4.x	MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver	MySQL Connector/J JDBC Driver
Oracle	Oracle 9i, 10g, 11g, and 12c	*Oracle SQLNet Client**	Oracle JDBC Thin Driver
PostgreSQL	9.3 minimum Specifically-supported PostgreSQL-based database products include Greenplum, Pivotal HAWQ, and BigSQL.	PostgreSQL ODBC Driver (latest version recommended)	PostgreSQL JDBC Driver
Sybase ASE	Sybase 15.7 - Sybase 16	Sybase Open Client	jTDS Type 4 JDBC Driver for Microsoft SQL Server Sybase jConnect JDBC Driver
Sybase IQ	12.7 - 15.4, 16	SQL Anywhere ODBC drivers for Sybase IQ 12.7 Sybase IQ 32-bit ODBC drivers	Sybase jConnect JDBC Driver for Sybase IQ
Teradata (Technical Preview) *	13.10, 14.0, 14.10, and 15.0	Teradata ODBC driver for Windows (version 15 recommended)	Teradata JDBC Driver

GENERIC JDBC/ODBC CONNECTIVITY

Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources is also provided. DBArtisan can connect to a datasource using a customer-provided, third-party JDBC version 4.0 or ODBC version 3.0 driver. Minimal DBArtisan functionality is provided, including a basic Explorer tree and SQL querying.

SPECIFICALLY-TESTED JDBC/ODBC CONNECTIVITY PRODUCTS: APACHE HIVE/HADOOP

DBArtisan has been successfully tested against Apache Hive/Hadoop datasources using the Hortonworks ODBC driver. Similarly, Cloudera Impala datasources have been tested using the Cloudera JDBC driver. In both cases, SQL querying and a Datasource Explorer/Navigator tree are available.

DBMS VERSIONS NO LONGER SUPPORTED

As of this release, DBArtisan is no longer being tested against Sybase ASE versions before 15.7.

RELEASE NOTES

IMPORTANT ADVISORY NOTES

If you want to run DBArtisan on Microsoft Windows 8.1, verify that third-party DBMS native drivers install properly. Consider using a JDBC connection.

KNOWN ISSUES

The current version of DBArtisan does not support the MySQL ODBC client that shipped with previous versions of DBArtisan. If DBArtisan crashes after connecting to a MySQL data source:

Close DBArtisan.
Uninstall the older MySQL ODBC client.
Restart DBArtisan and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
Follow the installation instructions to install the new driver.

Note that when debugging a procedure against an Oracle data source, DBartisan performs a compilation before debugging. During a compilation, Oracle invalidates referencing objects. For example, if procedures A2 and A3 both reference procedure A1, debugging procedure A1 in DBArtisan, will result in procedures A2 and A3 being invalidated.

In some situations the Database Monitor may prompt to connect to an already connected datasource if auto-connect is not enabled for that datasource

DBArtisan installs the incorrect stored procedures for Capacity Analyst for a Sybase 15 database. Please refer to this Knowledge Base article: www.embarcadero.com/jive/entry.jspa?externalID=1030&caID=2

For servers running on Sybase version 12.5.3a, the CREATE ENCRYPTION KEY and DECRYPT permissions do not display properly--they'll be shown as null. See Sybase's document CR392544 ("sp_helpprotect does not show privileges related to encryption keys."). This has been fixed in ASE version 12.5.3a/ESD#1 (now available as a download) and ASE version 12.5.4.

The SQL Server Agent failing problem is caused by the lack of permission to enumerate the status of the server service. To determine the status of the server, the user must have permission to check the status of the server service. If the user running DBArtisan at the client machine is a not a local user who can be authenticated at the server machine, the Server Agent jobs will fail.
Workaround:
a. If the user that runs DBArtisan is not a domain user, create the same user with the same password on the server.
b. If the user is a domain user, make sure the user can login to the server.

When you are using the Debugger:

The Debugger windows (Variables, Watch, CallStack, Dependency) cannot be undocked. This behavior is deliberate and is true only for the Debugger windows. The Output window can be undocked.
When running Windows XP SP2, SQL Server 2000 SP4 is required on both the client and the server.
When running the Debugger on SQL Server 2005 CLIENTS:

Verify that the file ssdebugps.dll is registered on the client machine. This file is REQUIRED for debugging and Microsoft only installs it on the server machine and not as a part of a client-only install.
Follow the instructions under the "Configure DCOM on the computer that is running Visual Studio. NET" heading from Microsoft to reconfigure the DCOM settings on your client machine: http://support.microsoft.com/default.aspx?kbid=833977.
On the Default Properties tab of the My Computer dialog box, make sure the Default Authentication Level is set to None and that the Default Impersonation Level is set to Impersonate.

When using the Embarcadero Sybase debugger against a Sybase database with multiple temporary databases (supported in Sybase ASE 12.5.0.3 and above), either the user or the debugger application must be bound to a specific temporary database.

To bind the Embarcadero Sybase Debugger:
sp_tempdb "bind" , "ap", "Sybase Debugger", "DB", "<tempdb name>"
To bind the user:
sp_tempdb "bind", "lg", "<login id>", "DB", "<tempdb name>"

The BCP (bulk copy) data movement option is disabled for cross-platform migration. In addition, to use the BCP in a Sybase-to-Sybase migration, the user must be logged in as System Administrator *or* the "select into/bulkcopy/pllsort" database option must be true on the target catalog. If this option is "false" on the target catalog, BCP will not appear as a data movement option for non-system users.

Schema migration jobs created in earlier versions of DBArtisan that were saved with a .migrate file extension must be re-created in DBArtisan 8.1 or later. Only migration jobs with a .sav extension can be reused.

DBArtisan is currently unable to create table names, column names, and check constraint names longer than 18 characters on an OS390 mainframe database.

On SQL Server 2005, the Browser component is disabled by default. With this service disabled, in DBArtisan you cannot reference SQL Server instances by name, only by port number. If you want the ability to reference SQL Server instances by name, you must enable this service on the server.

BUG FIXES

Bugs Fixed in DBArtisan 9.7.5/XE6
Issue #	Description	DBMS
DBA-32274	query_cache_type becomes invalid	MySQL
DBA-32175	Unknown system variable	MySQL
DBA-32017	[Enhancement][Oracle] semicolon not filtered when it should be	All
DBA-31951	[SQL Editor] Rule hint is causing a large consumption of the temp space	Oracle
DBA-31937	Oracle 12c Add IDENTITY data type support in table editors/wizards	Oracle
DBA-31935	[Schema Extraction] When extracting or compiling Function, the comments are missing from Function	Oracle
DBA-31873	[DBMS ACTION ] Table "Segment Usage" show incorrect values for tables/indexes	Sybase ASE
DBA-31850	[Enhancement] Oracle Database 12.1.0.2 user DDL extraction issue	Oracle
DBA-31814	[DBMS Actions] would like to be allowed the entry of -1 in the 'maximum login attempts'	Sybase ASE
DBA-31785	Performance Analyst Space tab has error message about sp_embt_ps_space_drill_tables Implicit Conversion from datatype INT	Sybase ASE
DBA-31780	DBArtisan does not generate the new 'create or replace' SQL	Sybase ASE
DBA-31778	[Sybase 16] Some Database options are not refreshing after being enabled	Sybase ASE
DBA-31769	Performance Analyst launches with errors, Ambiguous Column name Hostname	Sybase ASE
DBA-31754	Performance Analyst launches with errors, Procedure (sp_sysmon_collect) Invalid parameter '00:00:00' Attempt to insert NULL value into column 'value', table 'sybsystemprocs.dbo.embt_pa_monitor';column does not allow nulls. Update fails.	Sybase ASE
DBA-31672	Copy/Paste using CTRL-Mouse Click not consistent in SQL window	All
DBA-31638	[Schema extraction] DDL Extraction is not formatted correctly	DB2 for z/OS
DBA-31616	Function Call fails (with ORA-06550) on the last 2 versions of DBArtisan 9.6.1 build 13123, and 9.7.1 build 13242	Oracle
DBA-31602	[Schema Migration] The Option Overwrite Existing is not working	Sybase ASE
DBA-31577	[SQL Editor] Scripts fail to stop executing when an error is encountered	DB2 for LUW
DBA-31567	[DBMS Object Management] not able to select compatibility level for SQL Server 2014	SQL Server
DBA-31565	Ability to save 'Results' in same folder as opened SQL file	All
DBA-31458	Oracle 12c IDENTITY data type does not appear in table extraction	Oracle
DBA-31417	[Database Monitor] displaying incorrect info for Database column for Network Handler system processes	Sybase ASE
DBA-31410	Login Extract fails to execute due to this SQL line "ALTER LOGIN login here ADD AUTO ACTIVATED ROLES sa_role	SQL Server
DBA-31368	[DBMS Actions] Existing procedures are no longer ale to be compiled	Oracle
DBA-30853	[Drop] Application is freezing when trying to perform a multiple drop on PostgreSQL	PostgreSQL
DBA-30817	[Schema Migration] Schema Migration fails to import data when Identity column exists	SQL Server
DBA-30813	[Database objects] Does not show Views in tab "Dependencies", section "Referenced By" for Mviews	Oracle
DBA-29771	Need an option to assign a default driver to all	ALL
DBA-29764	Procedure not showing for SQL server 2012	ALL
DBA-29747	[Schema Migration] No data migrated when using Migration, error ORA-01005	Oracle
DBA-29746	The object permissions display keeps reverting to a particular database on datasource	Sybase ASE
DBA-29745	Logical Foreign key table column names blank	Sybase ASE
DBA-28844	[Datasource Registration] Username is not saved when unchecking "Auto connect"	ALL
DBA-25563	[Procedure Definition][Oracle] Schema name is replaced by spaces in definition of an invalid procedure	Oracle
DBA-20505	[SQL Editor]"Auto-Save File Every mins" option does not work.	ALL
DBA-18689	Extraction of proxy table is incorrect	Sybase ASE
DBA-18341	Request for better bookmark management menu	ALL
DBA-18192	ROLE is missing SYSTEM PRIVILEGE called CHANGE NOTIFICATION	Oracle
DBA-17897	extract on sybase 15 user datatype unsigned does not return the create statement	Sybase ASE
DBA-16931	Extracting particular Stored Procedure causes DBArtisan to hang freeze up and the process has to be killed in Task Manager	SQL Server
DBA-16870	Compound partition columns not displayed correctly	Oracle
DBA-16859	Currently connected datasource in drop down disappears after 8th or 9th execution of SQL script in ISQL editor	Oracle
DBA-16675	Serial Number is either invalid or expired (7013)	ALL
DBA-15060	Request to clear the User ID (Login ID) field when choosing to not "Auto Connect" to a datasource	ALL
DBA-14989	Double clicking a user name under Security does not return results	Oracle
DBA-14340	DB2 package drop fails due to wizard not getting the version identifier	DB2 for LUW
DBA-14292	Script is generated incorrectly for table of function indexes (new Sybase 15 feature)	Sybase ASE
DBA-13759	When opening and viewing table Attributes, then swapping over the Properties tab, the Properties tab information takes a long time to generate	DB2 for LUW
DBA-12846	In Database Manager, clicking on the Placement tab causes the Space and DDL View tabs to become disabled	Sybase ASE
DBA-12767	Datasource toolbar looses content after switching back and forth between DBArtisan and other applications	ALL
DBA-12592	When listing fields in Oracle VIEW, Customer would like decimal portion of NUMBER type to show up	Oracle
DBA-11850	Unable to rename index when both column and index are of the same value	Sybase ASE
DBA-11431	high memory usage until connection to database is disconnected and re-established	Sybase ASE
DBA-10615	When Data Unload all the "tables are skipped because they had zero rows", even they contain data.	Sybase ASE
DBA-9527	Tables and views are not listed for the databases that are linked using the linked server wizard.	SQL Server
DBA-9020	Missing column when performing an alter to the table	DB2 for LUW
DBA-8349	DB812 3216 Bug: when a table with dependent stored procedure is modified, the privileges on table got lost	ALL
DBA-7016	Request: graphic layout of an explain plan like that of Enterprise Manager	SQL Server

ADDITIONAL RESOURCES

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the DBArtisan Installation Guide. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.

Embarcadero Technologies on the Web

To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.