Welcome to ER/Studio Data Architect 20.0.x

ER/Studio Home | ER/Studio Documentation | IDERA Technical Support | www.idera.com


Thank you for using IDERA 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 the IDERA Web site, https://www.idera.com/support/productdocuments


WHAT'S NEW in version 20.0

Includes an improved Diagram Data Version Upgrade user interface

Repository Options dialog box now allows users to select whether to add DDL code to Team Server

Adds support for comments on View Columns in the View Editor

Includes the ability to change a relationship type for containment relationships in Google BigQuery and MongoDB

Release Notes

Important Release Advisory

Important Installation Notes

Bug Fixes and Known Issues

Upgrade Instructions

Upgrading from ER/Studio Portal to Team Server

Upgrades for ER/Studio Repository Users

Upgrades for version of ER/Studio Repository prior to 2016

Additional Resources

Licensing Your IDERA Product

IDERA Product Support

IDERA Technical Support

IDERA on the Web

What's New in Version 20.0

Includes an improved Diagram Data Version Upgrade user interface

ER/Studio Data Architect 20.0.0 includes an improved user interface for the Diagram Data Version Upgrade window. This window lets the user know which diagrams within the Repository require an upgrade and provides a checkbox next to each item for the user to select for a bulk update.

 

Simply check the appropriate box(es), and then click OK to begin upgrading those selected diagrams. Once complete, ERDA lets you know the number of diagrams upgraded, a list of any diagrams that failed, and the overall time taken to perform the process. For more information about this feature, see Diagram Data Version Upgrade.

 

Repository Options dialog box now allows users to select whether to add DDL code to Team Server

The Repository Options dialog box in ER/Studio Data Architect now includes an option under the Team Server selection that allows users to save the Table and/or View DDL to Team Server. The DDL information then appears when viewing the specific Entity type in Team Server. The following options are currently available:

        Save Table DDL with Physical Models for Team Server

        Save View DDL with Physical Models for Team Server

For more information about these options and more, see Repository Options Team Server tab.

 

Adds support for comments on View Columns in the View Editor

This release of ER/Studio adds support for comments in the View Columns area of the View Editor. When reverse and forward engineering views or importing views from SQL, the Comments property of the View Column is populated with comments from the database or SQL. This information now appears in the View Editor.

 

Includes the ability to change a relationship type for containment relationships in Google BigQuery and MongoDB

Google BigQuery and MongoDB users can take advantage of a new feature that allows you to easily change a relationship type for containment relationships. While viewing a containment relationship that you want to change the relationship type, click Switch Relationship Class in the ribbon bar. The following actions occur:

        If the line is referencing:

1.      ERDA removes the Foreign Key field/column in the child object/table.

2.      A dialog appears asking you to select the desired containing object, and offers Parent, Child, and Cancel options. Note that Child is the default.

3.      ERDA changes the relationship type to containing in the direction selected in the dialog.

4.      A new foreign Key property is created in the Parent object.

        If the line is containing:

1.      ERDA removes the Foreign Key field/column in the parent object/table.

2.      A dialog appears asking you to select the desired referencing object, and offers Parent, Child, and Cancel options. Note that Parent is the default.

3.      ERDA changes the relationship type to referencing in the direction selected in the dialog.

4.      A new foreign key property is created in the Child object, propagating the primary key of the parent.

For more information about using this type of relationship, see Containment Relationships.

Release Notes

Important Release Advisory


To ensure compatibility with ER/Studio Repository synchronization, this version of ER/Studio Data Architect requires ER/Studio Repository (Team Server) version 19.1 or later 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


Bug Fixes and known issues


For the more recent list of known issues and bug fixes in this release, see http://docwiki.embarcadero.com/ERStudioDA/200/en/Release_Notes.

Upgrade Instructions

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


For detailed instructions on upgrading to Team Server, see Install or Upgrade Team Server and Repository.

Upgrades for ER/Studio Repository users


To use the repository with this release, you will need to be running ER/Studio Repository (Team Server) 19.0 or later.

Upgrades for version of ER/Studio Repository prior to 2016


Repository is now installed as part of Team Server. To upgrade an earlier version of Repository, please see About Team Server and Repository Upgrade.

Additional Resources

Licensing Your IDERA Product

All IDERA 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 Quick Start Guide. If you have not yet purchased this product, contact [email protected].

IDERA Product Support

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

IDERA Technical Support

If you have a valid maintenance contract with IDERA, the Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of IDERA 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 Customer Support Center. For additional information about IDERA Technical Support, visit the Support section of our Web site.

IDERA on the Web

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