Release Notes
Welcome to ER Studio Data Architect 9.7.1
ER/Studio Home | Documentation | Technical Support | Embarcadero.com
Read Me Last Updated: April 24, 2014.
|
|
|
|
|
|
|
|
Thank you for using 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 Data Architect'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.
Important Installation Notes
Important Release Advisory
Bug Fixes
Upgrading from Embarcadero Connect to ER/Studio Team Server
Upgrades for ER/Studio Repository 6.6 users
Upgrades for version of ER/Studio Repository prior to 6
Release 9.7.1 features summary:
- UI - Expand/Collapse in Get Diagram UI
- UI - "Retain View" setting in Get Diagram UI
- UI - Automatically Backup Local Files on Get
Teradata - NUMBER data types
The NUMBER datatype is now supported for Teradata 14.
Teradata - View syntax
The Teradata view syntax "count * over" is now supported.
Teradata - Table and Column definitions
Comparing against Teradata now supports table and column definitions.
UI - Expand/Collapse in Get Diagram UI
The product includes the option to expand a collapsed node in the Get Repository Diagram explorer showing all descendant nodes.
UI - "Retain View" setting in Get Diagram UI
The state of the explorer tree in the Get Repository Diagram dialog is now retained upon exiting.
UI - Automatically Backup Local Files on Get
An option to automatically/always backup local copy of a dm1 file during a get is now available.
Release Notes
Important Installation Notes
- To install ER Studio Data Architect on Windows 8, Windows 7, Windows Vista, Windows XP Professional, or Windows XP Home Edition, you must have administrative privileges. Once you have installed ER Studio Data Architect, you can then log in as a standard or limited user and use the application without having administrative privileges.
- In order to run ER Studio Data Architect, you must provide valid licensing information.
- When you install ER Studio Data Architect, certain files and directories that were previously stored under the Program Files folder are now by default installed to system-specified application data directories.
- During installation, the following directories are created:
- For Datatype Mapping Editor files, which is also the default location for user-generated Datatype Mapping files:
- Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\DatatypeMapping
- Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_X.X\DatatypeMapping
- For Automation Handler files, which is also the default location for sample macros:
- Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\Macros
- Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_X.X\Macros
- For sample model files, for which a shortcut is generated in the ER Studio Data Architect program group:
- Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\Sample Models
- Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_X.X\Sample Models
- For Datatype Mapping Editor files, which is also the default location for user-generated Datatype Mapping files:
- When the application is run for the first time, the following directories are created by ER Studio Data Architect:
- Directories used by the Repository client to transfer files to and from the Repository server:
- Windows XP:
- C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\RepoIn
- C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\RepoOut
- Windows 8, Windows 7, and Windows Vista:
- C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\RepoIn
- C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\RepoOut
- Windows XP:
- Default directory for Report files:
- Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\Reports
- Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\Report
- Default directory for SQL scripts:
- Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\SQLCode
- Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\SQLCode
- Default directory for Quicklaunch files:
- Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\XML
- Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\XML
- Default Save location for new diagrams:
- Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\Sample Models
- Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\Documents\ERStudioDA_X.X
- Directories used by the Repository client to transfer files to and from the Repository server:
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 ER/Studio Team Server. Users that formerly used the Repository tab to browse the portal can use a Web browser instead.
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 Data Architect 9.7.1
| ERS-23239 |
Foreign keys are now displayed with the correct attribute name in the model. |
| ERS-23257 |
Subtype descriminators are now merged properly between models. |
| ERS-23258 |
VARCHAR(max) domains are now displayed with the correct width in the model. |
| ERS-23269 |
Comparing against Teradata now supports table and column definitions. |
| ERS-23270 |
Unique Primary Indexes are now generated properly in DDL. |
Upgrade Instructions
Upgrading from Embarcadero Connect to ER/Studio Team Server
For detailed instructions on upgrading to ER/Studio TS, see ER/Studio TS Upgrade Notes.
Upgrades for ER/Studio Repository 6.6 users
Keep the following in mind when updating for this release:
- Only a service upgrade is required
- No diagram data version upgrade is required.
- There are no database changes from version 6.6
Upgrades for version of ER/Studio Repository prior to 6
Use the following checklist to ensure ER/Studio Repository is correctly upgraded.
Upgrade Checklist
- Download ER/Studio Enterprise Upgrade. To download the most current release, go to embarcadero.com.
- Review the ER/Studio ReadMe. For the most current installation and usage information, see the ReadMe at docs.embarcadero.com.
- Prepare to upgrade. For what to do before you upgrade to the latest version, see Preparing to Upgrade.
- Upgrade ER/Studio Repository. For ER/Studio Enterprise installations, which include the Repository. For ER/Studio Repository upgrade details, see Upgrading the Repository.
Important Notes
- The Repository upgrade must be done incrementally from one major version to the next until the target version is reached. You cannot skip major versions during the Repository upgrade as the installer for each major version only contains the database changes between the new version and the previous one. When upgrading from earlier versions, such as from 5.5 to Repository 6.6, you must first upgrade the Repository to version 6.0, update the database, then upgrade to 6.6 updating the database. Once the Repository upgrade is complete and you have installed the latest version of ER Studio Data Architect, then you should upgrade your diagrams with the latest version of ER Studio Data Architect. For more information, see online documentation Consult Embarcadero Technical Support when upgrading from versions prior to 4.5.
- If you are upgrading to ER/Studio Repository, upgrade your version of ER Studio Data Architect also. Ensure the build date of ER/Studio Repository coincides with the build date of ER Studio Data Architect.
- If you are also using ER/Studio Portal, you must also upgrade it to the latest version.
- You can install ER Studio Data Architect 9.x and an earlier ER Studio Data Architect version on the same workstation.
- Any *.dm1 files you use from the previous version will be copied and converted to 8.x format when you open them for the first time. You can then save the diagram with a different name or use the same name to write over the old file. Previous versions of ER Studio Data Architect will not read 8.x and higher files.
- Upgrading diagrams can be time consuming and memory intensive. The number and size of ER Studio Data Architect diagrams managed in the upgraded Repository dictates how long the upgrade process takes.
- Reference Models, supported in previous versions, are not supported in ER Studio Data Architect 7.x and later versions.
Preparing to Upgrade the Repository
- Ensure you have backed up all your .dm1 files.
- 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.
- Rename all local copies of Repository diagrams in the active file directory as follows:
- Choose Repository > Options.
- Make note of the Active File Directory.
- Switch to the Windows Explorer and rename all the diagrams in the Active File Directory.
- Ensure no one is logged into the Repository.
- Backup the current Repository database.
- 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.
- Log on to Windows with local administrator privileges.
- 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
To contact Support, go to embarcadero.com/support.
Comments: Email Us