Welcome to ER/Studio Data Architect® 11.0

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

Read Me Last Updated: April 14th, 2015. Any updates to these Read Me notes will be available at docs.embarcadero.com.


DBTA100 SDT100_2014 SD Times Award

SD Times Award

CS Award

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 11.0


Change Management
Welcome Page
Auto-Naming Standards
New Installer
Enhanced Platform Support
Glossary Integration
User Interface Enhancements



Release Notes

Important Installation Notes

Important Release Advisory

Bug Fixes

Known Issues

Upgrade Instructions

Upgrading from ER/Studio Portal to Team Server Core

Upgrades for ER/Studio Repository 7.0 users

Upgrades for version of ER/Studio Repository prior to 6

Additional Resources

Embarcadero Technologies Technical Support


What's New in 11.0


Change Management

Allowing you to collaborate in an Agile environment, Change Management Center gives you the ability to easily track and manage the changes made by Repository check ins.


Welcome Page

Newly implemented in version 11.0 of ER/Studio Data Architect is the interactive Welcome Page. A starting point for new and more experienced users. Containing links to your recent files, plus the ability to create new models and open the reverse engineer or import wizards in a single click.
The Welcome Page includes a number of helpful videos to guide you through some of the more important features, and for new users, a simple getting started video.
If you do not have Internet connectivity, there is an auto-sensing offline page that shows limited interactive content, but is still filled with useful information and the same useful quick links to get you quickly back to where you left off.


Auto-Naming Standards

Naming Standards have been an effective method of keeping your models in line with any organizational naming conventions and compliance that is in place, however now the Auto Naming Standards feature allows you to create and modify while automatically applying your naming standard templates (NST) to your models.


New Installer

Streamlining the install process, the new WiX installer means you have an easier install, with less keystrokes.

Enhanced Platform Support


Glossary Integration

The business glossary is an extremely important source of information for collaboration between all stakeholders including data modelers, business analysts, developers, and subject matter experts. Your Team Server glossaries are now able to be linked directly in to the ERStudio interface. If a glossary term is used in the Name, Definition, or Notes of a model object, it is highlighted to identify that you have a definition in your Team Server Glossary. Holding your mouse cursor over the highlighted term pops up the short definition while clicking on the term will navigate to that term in the Team Server Glossary.

User Interface Enhancements

To ease keyboard navigation the tab order has been improved on the dialog boxes.








Release Notes

To ensure compatibility with ER/Studio Repository synchronization, this version of ER/Studio Data Architect requires at least ER/Studio Repository version 7.0 for all Repository operations.

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

License Enforcement

When working with the Repository, all users must use the same license type. ER/Studio now enforces this by marking the Repository as an Enterprise Team Edition Repository when a user with an Enterprise Team Edition license logs in. Subsequent log in attempts by users with a non-Team Edition license will not be allowed

Important Installation Notes


Important Release Advisory



Bug Fixes


Use your browser Find feature to locate a particular bug number.

Bugs Fixed in ER/Studio DA 11.0


ERS-24544 Entity Editor help links corrected
ERS-19764 Date attachments now stored in user locale specific format.
ERS-24475 Teradata Compare and Merge now generates correct diff script
ERS-24483 Constraint names formatting issue for MS SQL Server 2014
ERS-24482 VARCHAR(MAX) correction for MS SQL Server 2014
ERS-24344 API - SrcTrgtTableOwnerName now added to DataMovementColumnLink Class
ERS-23890 Fixed a forward engineering syntax issue for Teradata
ERS-23891 Fixed an index syntax issue for Teradata
ERS-22479 The Length of the Entity Name and Table Name display windows has been increased
ERS-24403 Added users checkbox in Objects comparison tab
ERS-23914 In some cases reverse engineering Hive datasource failed
ERS-24313 Constraint names now match in Create/Drop ForeignKeys
ERS-24151 Fixed truncated names issue during reverse engineering and compare/merge
ERS-23188 Fixed an issue with the attachments that are returned by macro
ERS-23860 It is now possible to drop on to Model node to bring nested submodels to root
ERS-23987 Fixed an issue with associative entities that are created for non-specific relationships
ERS-22517 Fixed an scrolling object duplication issue
ERS-24184 Updated the ImportAttributeAttachments macro to fix an update issue Attachments macro
ERS-24248 Export to Excel PK value error
ERS-24059 Type mismatch issue
ERS-24094 Modifications on 'Move-Up Key Columns' macro
ERS-23878 ActiveX Vulnerability fix
ERS-23689 Import erwin file issue.




Known Issues

ERS-23001 Performance issues when navigating and editing tables.
ERS-24062
Term hyperlinks are not shown with Firefox when first clicked.
ERS-24319
Oracle's COMPRESS option is not supported in SQL Import.
ERS-23678 Reverse engineering from MongoDB creates incorrect results with fields or arrays using different data types.
ERS-23791 Compare/Merge fails to properly merge MongoDB objects in some cases.
ERS-24419
Users must close and reopen the Entity Editor after applying a Naming Standards Template.
ERS-24577
Change Records are marked as completed even if the check in fails in the Repository server.




Upgrade Instructions

Upgrading from ER/Studio Portal to ER/Studio Team Server


For detailed instructions on upgrading to Team Server, see the Upgrade Notes.

Upgrades for ER/Studio Repository users


To use the repository with this release, you will need to be running at version 7.0 of Repository as a minimum.

Upgrades for version of ER/Studio Repository prior to 7.0


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 www.embarcadero.com.

To contact Support, go to http://www.embarcadero.com/support.