ER/Studio 8.0.1 ReadMe

Welcome to ER/Studio® 8.0.1

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

Thank you for using Embarcadero ER/Studio, the award-winning data modeling application for logical and physical database design and construction. ER/Studio's 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'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.

WHAT'S NEW IN VERSION 8.0

Client Enhancements and Updates

LDAP and Active Directory Integration

Visual Data Lineage (VDL)

Attribute-Level Submodeling

Object-Level Compare Flags

Database Management Systems Updates

Expanded Database Platform Support

Documentation Improvements

Automation Interface Reference

Online Help

Licensing Procedural Changes

Sanctuary Licensing

Release Notes

Important Installation Notes

Important Advisory Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in ER/Studio Version 8.0

Customer requests continue to guide us in our quest to bring to market the best database tools available. Thank you for your support.

For instructions and more detailed descriptions of new features, please see the ERSNewFeatures.pdf file in your installation Readme directory or download the most-recent from Embarcadero ERStudio New Features Guide.

Client Enhancements and Updates

Visual Data Lineage (VDL)

Visually analyze and document how data flows through your organization without needing to inspect code. For more information, see "Documenting Data Extraction, Transformation, and Load" in the User Guide.

LDAP and Active Directory Integration

Manage user authentication to the Repository using Lightweight Directory Access Protocol (LDAP) and Active Directory integration. For more information, see "Creating and Managing Users" in the Administrator's section of the User Guide.

Attribute-Level Submodeling

Choose which attributes/columns to include in the entities/tables in the submodel on the new Attributes/Columns tab of the Create Submodel editor and also describe submodels on the new Definition tab of the Create Submodel editor. You can then create queries to search on these definitions. For more information, see "Creating and Editing Submodels" in the User Guide.

Object-Level Compare Flags

Indicate intentional discrepancies when comparing models by choosing which properties to ignore on the newCompare Options tab available on the editors for entities, tables, attributes, columns, and relationships. Thisenables you to indicate discrepancies the Compare Wizard should ignore.

Expanded Database Platform Support

New DBMS Support

ER/Studio now supports SQL Server 2008, Sybase IQ, and Interbase. These platforms are supported in all ER/Studio functions such as Add New Physical Model, Reverse-engineer an existing database, Change Physical Model, and the Automation Interface. For a list of all supported databases, see "Supported Database Platforms" in the User Guide.

Documentation Improvements

Automation Interface Reference

Descriptions in the AIRef have been edited to complement the syntax diagrams, providing more concise information that is easier to access.

Online Help

The online help and and user guide have been reorganized and completely rewritten to provide fast access to concise but comprehensive information to help you accomplish common and not-so-common tasks."

Licensing Procedural Changes

Santuary Licensing

ER/Studio, a DatabaseGear product from Embarcadero, now shares the same strong licensing scheme used by all CodeGear products, such as Delphi® and C++Builder®, which are also Embarcadero Technologies products.

Release Notes

Important Installation Notes

To install ER/Studio on Windows XP Professional, Windows XP Home Edition or Windows Vista, you must have administrative privileges. Once you have installed ER/Studio, you can then log in as a standard or limited user and use the application without having administrative privileges.
The first time you run the program, you will see a product registration dialog. Enter the serial number from the beta download page, then click the "I need to create a DN account" link and follow the instructions.
When you install ER/Studio, 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\ERStudio_X.X\DatatypeMapping
Windows Vista: C:\ProgramData\Embarcadero\ERStudio_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\ERStudio_X.X\Macros
Windows Vista: C:\ProgramData\Embarcadero\ERStudio_X.X\Macros

For sample model files, for which a shortcut is generated in the ER/Studio program group:

Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudio_X.X\Sample Models
Windows Vista: C:\ProgramData\Embarcadero\ERStudio_X.X\Sample Models

When the application is run for the first time, the following directories are created by ER/Studio:

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 Vista:

C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\RepoIn
C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\RepoOut

Default directory for Report files:

Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\Reports
Windows Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\Reports

Default directory for SQL scripts:

Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\SQLCode
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 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\ERStudioX.X\Sample Models
Windows Vista: C:\Users\<user>\Documents\ERStudioX.X

Known Issues
ERS-14561	The new Description and Bound Attachments features for User Defined Mappings have not yet been implemented in Reports.
ERS-15429	On-screen editing for Transformation names has not yet been implemented.
ERS-15555	The Display Levels for Data Lineage objects are currently mutually exclusive.
ERS-15585	Drag and drop within the Data Lineage tree is not yet supported.
ERS-15592	The Transformations.Add method currently does not support specifying position coordinates.
ERS-15841	The Automation Interface does not yet have a method to add inputs and outputs to Transformations.
ERS-15921	Data Flows are not supported in Repository partial diagrams.
ERS-15936	Currently it is possible to create Data Flows with the same name in Repository models.
ERS-15974	Currently it is not possible to copy and paste Data Lineage objects.
ERS-16009	The Update Data Flow Display permission in the Repository Security Roles currently does not allow users to use the Display Options settings in the Data Lineage view. For now, applying the Update Display Properties permission under Physical Submodels will allow users to modify the Display Options for Data Flows.
ERS-16053	When logging in as a DS user, the application currently does not prompt to close any models that were opened by another user.
ERS-16056	After checking out a Data Flow in a Repository model, the status icons in the Data Lineage tree are not updated properly.
ERS-16067	Objects in Data Flows in Repository models can be resized when the user only has Update Physical Model Display permissions. This should be restricted to the Update Data Flow Display permission.
ERS-16068	The Check Out Object context menu item in the VDL tree currently does not work properly for Transformations.
ERS-16439	In the InstantOn version of ER/Studio, Help cannot be invoked from within the SaxBasic edit control.

Bug Fixes

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

Bugs Fixed in ER/Studio 8.0.1 Build 5940

Bugs Fixed in ER/Studio 8.0 Build 5910

Bugs Fixed in ER/Studio 8.0

Bugs Fixed in ER/Studio 8.0.1
ERS-10692	A column option has been added to ignore collation when comparing a model to the database for SQL Server.
ERS-11420	Invalid DDL is no longer produced after updating a second table defined within a union view.
ERS-11906	Empty domain definitions can now be deleted from the definition tab for an attribute or column bound to a domain.
ERS-12477	Required CREATE VIEW privileges are now properly granted to new Repository schema owners on Oracle 10.2.
ERS-13514	SQL Server procedures with subqueries now validate correctly.
ERS-13575	Constructor functions with 'result' as parameter names are now handled correctly when validating an object type.
ERS-13659	Extra spaces are no longer inserted before index columns when function-based indexes are reverse-engineered.
ERS-13710	The BIGINT data type is now supported for Teradata.
ERS-13762	The same name can now be used for relationships in different schemas.
ERS-13796	Support has been added for using duplicate constraint names in the same schema (but on different child tables) in DB2.
ERS-13832	Functions and procedures defined with NOCOPY are no longer reported as invalid during validation.
ERS-13995	The Review Changes dialog now ignores identity seed and increment values when identity is not on during check in.
ERS-14056	Oracle object types using identifiers like 'password' now validate correctly.
ERS-14093	The Compare/Merge utility no longer creates "global" partition indexes when settings for the table indexes are configured to be "local".
ERS-14124	Use of 'default' as function arguments, common table subexpressions for DELETE, and server internal procedures are now supported during reverse engineering for SQL Server 2005.
ERS-14154	ER/Studio no longer hangs when importing ERWin Saphir ERX files.
ERS-14155	Commas are no longer rquired between the clauses of an identity column when importing a DB2 script.
ERS-14157	Compare/Merge now places brackets around special characters like '&'.
ERS-14288	Report image hyperlinks are now correctly generated for entities nested within shapes.
ERS-14383	The view editor now supports nested SQL with multiset columns casted to custom defined object types.
ERS-14476	Entity links from model images generated when using custom Quick Launch settings are no longer missing.
ERS-14538	The 'Not for Replication' attribute for columns can now be excluded during compare/merge via the Identity Properties option.
ERS-14576	CHAR and CHAR(0) column types are now converted to CHAR(1) for UDB platforms when loading a model that was imported from an ERWin file via the MetaWizard.
ERS-14586	SELECT statements containing DB2-specfic VALUES query expressions can now be successdully saved in the trigger editor.
ERS-14608	Non-unique indexes are no longer displayed as Alternate Keys in the diagram.
ERS-14670	Note shapes are now drawn properly at any zoom level.
ERS-14672	Foreign keys are now automatically matched within the Compare/Merge utility when self-referencing relationships exist.
ERS-14680	Owner name prefixes for procedures are no longer discarded by the procedure editor after validation.
ERS-14756	Problems parsing stored procedures using 'PATH' syntax on SQL Server 2005 have been resolved.
ERS-14771	Constraint names with mixed case are no longer enclosed in quotes when generating DDL for DB2.
ERS-14858	The maximum size is now used as the upper boundary for projected size in the capacity planner.
ERS-14863	The 'Repository > Releases > Delete Named Release' menu option is now enabled regardless of whether a model is open.
ERS-14935	Differences are no longer incorrectly reported during compare/merge when the "Update target model when merge is executed" box is checked.
ERS-15016	Problems parsing XML datatypes in procedures have been resolved.
ERS-15017	Support has been added for OUTPUT clauses in INSERT, UPDATE, and DELETE statements for SQL Server 2005 procedures.
ERS-15018	The 'noexpand' hint option is now supported for SQL Server 2005.
ERS-15249	Non-specific relationships that are not in the submodel are no longer added to the tree.
ERS-15310	Parsing problems with variable names like 'account', 'type', and 'error_code' have been corrected.
ERS-15748	Report titles saved in quicklaunches are now used correctly when creating a report via a macro.
ERS-15373	The Data Lineage tree now supports multiple selections of components using the Shift key.
ERS-15374	You no longer need to hold down the Ctrl key when attempting to drag multiple components to the Data Lineage view.
ERS-15509	The Automation Interface now has a method to set the current active Data Flow.
ERS-15512	The Models collection in the Automation Interface no longer includes Data Flows.
ERS-15541	The Models.Remove method no longer removes Data Flows.
ERS-15791	Duplicate index column sequence numbers for PK indexes are now removed when a diagram is loaded.
ERS-15818	The Colors & Fonts dialog has been updated for Data Lineage objects.
ERS-15857	There no longer performance issues when performing a Get Latest on large Repository diagrams.
ERS-15866	Ctrl-A and Ctrl-Shift-A are now supported in the Data Lineage view.
ERS-15875	New views are now always available in the Local Models node of the Data Lineage tree.
ERS-15887	Data Lineage components can now be deleted from Repository models using the tree context menu.
ERS-15899	Internal quicklaunches in the Import Source wizard are now working properly.
ERS-15925	Sources and Data Movement Rules are no longer linked to the Data Movement Properties option under Diagrams in the Diagram tab. They have been moved to the Data Lineage tab.
ERS-15926	You can now add definitions and attachments to Data Flows.
ERS-16003	Data Flow images are now supported in the Report wizard.
ERS-16021	The About Box is now refreshed when you add another single platform license until the application is restarted.
ERS-16039	Data Flow objects in Repository models currently are no longer automatically marked for Delayed Check Out.
ERS-16123	Oracle procedures that contain variables named ERROR_CODE now validate correctly.
ERS-16126	The submodel synchronization utility no longer crashes the application when it encounters certain corrupt DM1 files.

ERS-16055	The DataFlows.Remove automation method now works correctly and no longer requires the active view to be the Data Lineage view.
ERS-16158	Partition tablespace information is now properly reverse-engineered.
ERS-16159	SQL Server views that have platform specific syntax such as "PARTITION" and "varchar(max)" now validate correctly.
ERS-16200	DM1 files that have been imported from ERWin and contain subtype relationships that have been modified to use an AK index as the parent key will no longer crash the application.
ERS-16211	Correct DDL is now generated when both "Generate Column Comments" and "Enclose Names in Brackets::Enclose All Names" options are selected.
ERS-16228	Errors when attempting to check in a new binding between an attachment and a domain no longer occur.
ERS-16235	User name checking when logging into the Repository is now case insensitive.
ERS-16243	Errors no longer occur when importing ERX files which contain "UNION ALL" syntax.
ERS-16244	Errors no longer occur when installing the Repository on a DB2 UDB 8.x database.
ERS-16245	Errors no longer occur when installing the Repository on a DB2 UDB 8.x database.
ERS-16281	The Compare Wizard no longer displays differences between entities in the logical and split tables in the physical after checking out the diagram from the Repository.
ERS-16282	The Compare Wizard now properly merges relationships from the logical to denormed tables in the physical.
ERS-16285	Correct DDL for views containing UNION ALL syntax is now produced when generating a physical data model.
ERS-16293	The compare wixard no longer erroneously reports differences when both the "Generate .sql for changes merged to target model." and the "Update target model when merge is executed" options are enabled.
ERS-16310	Errors no longer occur when launching the License Manager on German Windows XP.
ERS-16322	The TextLabel and SystemName properties are now deleted properly after deleting a column in an iSeries model.
ERS-16340	GBP CACHE values are now matched correctly when comparing a diagram with a SQL file extracted from the same DB2 database.
ERS-16368	LDAP authentication is now done only for log in operations.
ERS-16369	LDAP repository users can now be created with names containing punctuation characters.
ERS-16376	The tab control order for the "Directory Services User" check box in the 'Create Repository User' dialog has been corrected.
ERS-16414	Repository authentication for Directory Service users now consults four different ports instead of just the default one.
ERS-16456	SQL statement delimiters are no longer repeated incorrectly for triggers and procedures.
ERS-16494	The Report Wizard no longer generates a "Parameter is incorrect" error.

Bugs Fixed in ER/Studio 8.0 Build 5910
ERS-16138	The datetime datatype is now available in SQL Server 2008 models.
ERS-16275	Default overrides on columns bound to domains are now retained when upgrading from a previous version of the Repository.

Bugs Fixed in ER/Studio 8.0
ERS-13929	The Submodel Synchronization Utility now remains stable when synchronizing submodels.
ERS-14008	ER/Studio now performs better when reverse-engineering from SQL Server 2005.
ERS-14085	ER/Studio now performs better when reverse-engineering from Oracle 10g.
ERS-14445	HTML Reports now properly include all submodel images.
ERS-14522	The Submodel Synchronization Utility now remains stable when synchronizing submodels.
ERS-14685	ER/Studio now properly reverse-engineers Oracle 9.2.0.1 databases.
ERS-14710	The Infer Foreign Keys From Names option in the Reverse-Engineering Wizard is now case sensitive.
ERS-14722	The Diagram Grid settings in Diagram Display Options now works properly.
ERS-14732	The Validate Model wizard no longer flags items that are not errors.
ERS-14735	The Generate Physical Model wizard now uses the correct view column names.
ERS-14741	ER/Studio now remains stable when editing an entity on a French or German system.
ERS-14943	The Automation Interface now allows the creation of DB2 Aliases when the referenced table name is longer than 18 characters.
ERS-14966	The Add Physical Model wizard now remains stable when adding a model from another DM1 file.
ERS-14972	The DDL Wizard now properly generates composite PK indexes.
ERS-15046	The DDL Wizard now properly generates Pre-SQL that contains DROP PROCEDURE statements.
ERS-15109	The Add Physical Model wizard now remains stable when adding a model from another DM1 file.
ERS-15152	The Automation Interface now performs better when running macros with large models.
ERS-15176	The Repository Rename Diagram feature now works properly when the Repository model contains overflow data.
ERS-15182	The PrintOptions.Margin property in the Automation Interface now works properly.
ERS-15183	The PrintOptions.BoderWidth property in the Automation Interface now works properly.
ERS-15184	The PrintOptions.PrintObjectBackground property in the Automation Interface now works properly.
ERS-15185	The PrintOptions.Margin property in the Automation Interface now works properly.
ERS-15226	The Compare Wizard now properly matches foreign attributes.
ERS-15269	ER/Studio now properly parses DB Aliases that have "K" as an owner name.
ERS-15275	The correct Project Information is displayed in Reports generated by the Automation Interface.
ERS-15445	The Compare Wizard now properly merges subtype relationships.
ERS-15446	The SQL Server index editor now allows indexes of the same name on different tables.
ERS-15469	Text entry in the Tablespace control in the Oracle Subpartition Editor is no longer limited to the width of the control.
ERS-15508	The DDL Wizard now generates the DDL that runs properly in Oracle SQL*Plus.
ERS-15550	The Compare Wizard now properly matches foreign attributes.
ERS-15582	The Generate Physical Model wizard now remains stable.
ERS-15684	The DDL Wizard now properly generates functions named AT when brackets are included.
ERS-15720	The Overview Window no longer displays objects that are not visible in the model.
ERS-15729	Set Named Release now works properly on Repository models that contain logical models in Dimensional notation.
ERS-15730	Set Named Release now works properly on Repository models that are modified when loaded.
ERS-15980	SQL Import now supports Oracle scripts that contain columns named DIMENSION.

Additional Resources

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. To license your product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, FAQs, discussion groups, and the Embarcadero KnowledgeBase. Go to www.embarcadero.com/resources, or click any of the links below, to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with EmbarcaderoTechnologies, the Embarcadero Technical Support team is available to assist youwith any problems you have with our applications. Our maintenance contract alsoentitles registered users of Embarcadero Technologies products to download freesoftware upgrades during the active contract period. Evaluators receive freetechnical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Technical Support request form at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on our Web site.

Embarcadero Technologies on the Web

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