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
Release Notes
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
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.
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.
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
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.
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].
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:
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.
To download evaluations of other IDERA products or to learn more
about our company and our products visit us at www.idera.com.