Welcome to ER/Studio Data Architect® 9.6  

ER/Studio Home | ER/Studio Documentation | Embarcadero Technical Support | www.embarcadero.com

Read Me Last Updated: Aug. 13, 2013. Any updates to these Read Me notes will be available at docs.embarcadero.com.


Thank you for using Embarcadero ER/Studio Data Architect, previously known as ER/Studio, the award-winning data modeling application for logical and physical database design and construction. ER/Studio Data Architect's (ER/Studio DA) powerful, multi-level design environment addresses the everyday needs of database administrators, developers and data architects who build and maintain large, complex database applications.

ER/Studio DA's progressive interface and processes have been logically organized to effectively address the ease-of-use issues that have plagued data modeling tools for the past decade. The application facilitates your ability to create, understand and manage the mission-critical database designs within an enterprise. It offers strong logical design capabilities, bidirectional synchronization of logical and physical designs, automatic database construction, accurate reverse engineering of databases, and powerful HTML-based documentation and reporting facilities. Before you use ER/Studio, please read the information below.

See the most recent documentation at Embarcadero's Web site, http://www.embarcadero.com/resources/documentation.html.


WHAT'S NEW in 9.6

Embarcadero Connect

New Platform Version Support

New InterBase Object Types

SQL Server Sequences

Oracle Named NOT NULL Constraints

Release Notes

Important Installation Notes

Important Release Advisory

Known Issues

Bug Fixes

Upgrade Instructions

Upgrading from ER/Studio Portal to Embarcadero Connect

Upgrades for ER/Studio Repository 6.5 users

Upgrades for version of ER/Studio Repository prior to 6

Additional Resources

Embarcadero Technologies Technical Support

What's New in 9.6

Embarcadero Connect

Connect is a new Embarcadero product. For ER/Studio Data Architect, Connect provides the following:

New Platform Version Support

As of this release, ER/Studio Data Architect functionality is available against TeraData 14, IBM DB2 for Linux, Unix, and Windows Version 10, Netezza 7, as well as InterBase XE and XE3 data sources.

New InterBase Object Types

Against InterBase 2009, XE, and XE3 datasources, object types generators, triggers, and procedures are now supported.

SQL Server Sequences

Sequences, introduced in SQL Server 2012, are now supported by ER/Studio Data Architect.

Oracle Named NOT NULL Constraints

ER/Studio Data Architect now provides dedicated support for Oracle's named NOT NULL constraints.

Release Notes

Important Installation Notes


Important Release Advisory


ER/Studio Portal is no longer supported by ER/Studio Data Architect. Most functionality formerly provided by ER/Studio Portal is now provided by Embarcadero Connect. Users that formerly used the Repository tab to browse the portal can use a Web browser instead.

Known Issues


ERS-21891 Partial layout should only affect the edges between the selected nodes.
ERS-22022 Universal Mappings for objects in the same file don't show up in Reports.
ERS-22037 Universal Mappings between objects in the same file aren't displayed properly in the Where Used.
ERS-22202 Generated by default option does not work correctly in logical to physical compare.
ERS-22206 Unmatching objects in the Compare Wizard does not automatically delete mappings between the objects.
ERS-22230 Problems with Universal Mappings in the View Editor Where Used tab.
ERS-22632 Not Null Constraint name is not emptied when adding additional columns.
ERS-22691 The Data Source list is not populated properly in Compare/Merge when ODBC connection is the default.
ERS-22720 Cannot copy/past database objects between different versions of InterBase.
ERS-22775 SQL parse problem when trying to copy/paste a SQL Server sequence.
ERS-22818 Partitions are reverse engineered as separate tables on Greenplum.
ERS-22836 Cannot select catalog and owner when no password is used in the Data Source Mappings dialog

Bug Fixes


Use your browser Find feature to locate a particular bug number or click a link below to see the issues addressed in a specific build.

Bugs Fixed in ER/Studio DA 9.6
ERS-19031 The tab order is now correct in the Phrases tab of the Relationship editor.
ERS-20895 Defaults bound to domains are now maintained when generating physical models.
ERS-21174 The Repository will no longer allow cross-dictionary bindings.
ERS-21271 A diagram with a missing default name property will no longer cause the Repository to crash.
ERS-21609 The Repository has been certified to run using SSL 3.0.
ERS-22334 SQL Server sql import now properly imports nvarchar(max) columns.
ERS-22395 The Repository now properly maintains dictionary bindings between main and branched diagrams.
ERS-22492 HTML Report performance has been improved when the Attribute Where Used option is selected.
ERS-22522 The application now remains stable when the Help button is clicked in the Denormalization Mapping wizard.
ERS-22534 The Repository now remains stable and returns an error when an operation requires more than the available memory.
ERS-22535 The Repository services now use a quoted path upon installation.
ERS-22587 Long stored procedure text is no longer truncated in the Compare Wizard.
ERS-22659 The Repository Branch/Merge feature now properly handles attachment text lists
ERS-22666 Custom physical datatype mappings are now preserved when exporting through the MetaWizard to an ERWin physical-only model
ERS-22667 z/OS v10 physical models can now be reverse-engineered.
ERS-22668 The Repository now properly handles diagrams with Universal Mappings.
ERS-22686 It is now possible to edit a table that contains both single and multi-byte characters (Japanese version only)
ERS-22697 The line numbering in the Constraints tab of the Table Editor has been fixed.
ERS-22740 VARCHAR datatype widths are now reverse-engineered properly from Paradox databases.
ERS-22753 ER/Studio now supports z/OS v10 triggers and views.

Upgrade Instructions

Upgrading from ER/Studio Portal to Embarcadero Connect


For detailed instructions on upgrading to Connect, see Connect Upgrade Notes.

Upgrades for ER/Studio Repository 6.5 users


Keep the following in mind when updating for this release:

Upgrades for version of ER/Studio Repository prior to 6


Use the following checklist to ensure ER/Studio Repository is correctly upgraded.

Upgrade Checklist

Important Notes

Preparing to Upgrade the Repository

  1. Ensure you have backed up all your .dm1 files.
  2. Check in all your diagrams and objects. Note:If you try to check in a file from the previous version with the same name as a current file, the current file will become corrupted.
  3. Rename all local copies of Repository diagrams in the active file directory as follows:
  4. Ensure no one is logged into the Repository.
  5. Backup the current Repository database.
  6. Restart the Repository host computer.

Upgrading the Repository

Note: This procedure is for ER/Studio Enterprise installations only, which include the Repository. When you upgrade ER/Studio Data Architect you must also upgrade ER/Studio Repository to correspond with the same build date as ER/Studio Data Architect.

  1. Log on to Windows with local administrator privileges.
  2. Start the Repository installation program and select Repair Repository Services. The installation program starts the following services:

The Repository services and your existing database will be upgraded to the current version.

Note: If you are upgrading from a Repository version prior to 4.0, you can delete the C:\Program Files\Embarcadero\Repository\Data directory. This directory is not used with Repository versions 4.0 and later.

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, our Support team will 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. To download evaluations of Embarcadero Technologies products go to the www.embarcadero.com.

To contact Support, go to Support.