Welcome to ER/Studio® 8.0.3  

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)

LDAP and Active Directory Integration

Attribute-Level Submodeling

Object-Level Compare Flags

Expanded Database Platform Support

New DBMS Support

Documentation Improvements

Automation Interface Reference

Online Help

Licensing Procedural Changes

Santuary Licensing

Release Notes

Important Installation Notes

Known Issues
ERS-14561The new Description and Bound Attachments features for User Defined Mappings have not yet been implemented in Reports.
ERS-15555The Display Levels for Data Lineage objects are currently mutually exclusive.
ERS-15585Drag and drop within the Data Lineage tree is not yet supported.
ERS-15921Data Flows are not supported in Repository partial diagrams.
ERS-15974Currently it is not possible to copy and paste Data Lineage objects.
ERS-16067Objects 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-16068The Check Out Object context menu item in the VDL tree currently does not work properly for Transformations.
ERS-16439In 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.3 Build 6063

Bugs Fixed in ER/Studio 8.0.3

Bugs Fixed in ER/Studio 8.0.2

Bugs Fixed in ER/Studio 8.0.1

Bugs Fixed in ER/Studio 8.0 Build 5910

Bugs Fixed in ER/Studio 8.0

Bugs Fixed in ER/Studio 8.0.3 Build 6063
ERS-13536 The MetaWizard now imports smalldatetime data types.
ERS-16283 The MetaWizard now imports datetime data types.
ERS-16546 The MetaWizard now imports attachments bound to indexes.
ERS-17265 The MetaWizard now imports the physical name of ERWin domains.
ERS-17368 The Sax Basic Help item in the Help menu now works properly.
ERS-17382 The Repository now successfully checks in Enterprise Data Dictionaries after adding or moving domains under domain folders.
Bugs Fixed in ER/Studio 8.0.3
ERS-10553 The ENABLE ROW MOVEMENT option is now supported for tables on Oracle.
ERS-11120 Defaults are no longer propagated to child keys when the 'Propagate Default to Child Keys' option is deselected in the table editor.
ERS-13583 View validation no longer fails due to syntax errors related to aliases in nested FROM clauses on DB2.
ERS-14941 Table prefixes from the Naming Standards Tool are no longer added to foreign key constraint names after logical/physical comparison.
ERS-15429On-screen editing for Transformation names has been implemented.
ERS-15592The Transformations.Add method now supports specifying position coordinates.
ERS-15841The Automation Interface has new objects and methods to add inputs and outputs to Transformations: TransformationField, TransformationFields,Transformation.LineageInputs, and Transformation.LineageOutputs.
ERS-15936It is no longer possible to create Data Flows with the same name in Repository models.
ERS-16009The Update Data Flow Display permission in the Repository Security Roles now allows users to use the Display Options settings in the Data Lineage view.
ERS-16053When logging in as a Directory Service user, the application now prompts the user to close any models that were opened by another user.
ERS-16056After checking out a Data Flow in a Repository model, the status icons in the Data Lineage tree are now updated properly.
ERS-16104 All unified attributes are now properly renamed when an attribute is renamed by the Naming Standards Tool during physical model generation.
ERS-16122 Hidden attributes from denormalization mappings no longer appear in tool tips.
ERS-16424 When editing the details of a non-directory service user, it is now possible to update the username or description without having to specify a new password.
ERS-16487 Attachment values are now properly saved when focus is shifted to another field in the editor.
ERS-16503 Licenses for the MetaWizard are now only checked out if/when the functionality is accessed.
ERS-16505 Free Page values for primary keys are now properly matched when comparing a physical model with a SQL file.
ERS-16588 The performance of closing a diagram file has been improved.
ERS-16643 The automation interface now provide access to the inputs and outputs of a transformation.
ERS-16682 The Text Image File Group option in the physical model generation wizard is now properly saved in the quicklaunch settings.
ERS-16694 Parser errors no longer occur when importing SQL that casts sysdatetimeoffset to datetimeoffset on SQL Server 2008.
ERS-16701 The 'Use File-Based Quick Launch Settings' in the physical model generation dialog is now "sticky".
ERS-16817 The application no longer crashes when opening diagrams that have unified attributes with user-defined mappings.
ERS-16818 User-defined mappings on hidden, unified attributes are no longer incorrectly deleted.
ERS-16832 The application no longer crashes when attempting to open a naming standards template with a missing Object Type value.
ERS-16904 The Repository no longer lose columns from multi-column function-based indexes on Oracle.
ERS-16942 The PostSQL is no longer lost for all tables when copying/pasting a table.
ERS-17014 The hyperlink for "Download Latest Macros" item in the Help menu is no longer incorrect.
ERS-17030 The application no longer crashes when using calling the EnableScreenUpdate method from the automation interface with 'True' as an argument.
ERS-17033 Addition of a diagram to the Repository no longer fails when deleting a synonym that is referenced by another synonym.
ERS-17034 The view editor and column validation code no longer use the role name for a native columns.
ERS-17039 Recursive relationships are no longer lost during a rollup denormalization.
ERS-17043 Access Violation exceptions no longer occur when invoking the EnableScreenUpdate method from the automation interface.
ERS-17094 The documentation has been updated to note that for proceudural logic such as triggers and procedures, the results of the logic must be stored in a variable named 'resultstring'.
ERS-17141 The documentation has been updated to describe the GenVerifyStatement property of the DDLGenerationObject object in the automation interface.
ERS-17143 The application no longer crashes when dragging and dropping unified attributes with user defined mappings.
ERS-17207 The application no longer generates an error when reverse-engineering a SQL Server 2008 database that contains table types with check constraints.
Bugs Fixed in ER/Studio 8.0.2
ERS-11093The CASESPECIFIC clause is now supported for columns in Teradata.
ERS-11261Name mangling (conversion of spaces into underscores) is now taken into account when comparing views.
ERS-13591The index column sequence is now preserved when merging non-identifying relationships with identifying relationships.
ERS-13927The 'Character Set' clause is now supported for columns in Teradata.
ERS-13947The MetaWizard now correctly locates DM1 files that are saved without specifying a folder.
ERS-13992The file size no longer grows each time a model, which has been reverse-engineered from an Oracle database with cirular relationships, is loaded and saved.
ERS-14446Parsing errors no longer occur when '<>' is encountered while importing SQL on SQL Server.
ERS-14577Automation object values for IndentitySeed and IdentityIncrement are no longer returned into variable data types that are unsupported by SAX.
ERS-14646The file size no longer grows and load time no longer increases each time a model with unpropagated keys and circular propagation loops is loaded and saved.
ERS-14764Automation clients now export to Excel just as fast when a table editor is open as when it is closed.
ERS-14925Embedded comments no longer cause generated DDL to fail.
ERS-14955Obsolete ColorDefault and FontDefault information is now correctly removed when objects are deleted from a DM1 file.
ERS-14973An error message is now displayed after login and retrieval from the Repository is now disabled if a valid value is not specified for the Active File Directory.
ERS-15071The SQL statement delimiter for SQL generated during compare/merge on Oracle has been changed from ';' to '/'.
ERS-15072Compare/Merge no longer convert keys into non-keys if they will be promoted to PKs at the end of the merge.
ERS-15227Compare/Merge now properly matches foreign keys in circular relationships.
ERS-16092Alias displays are now implemented in the automation interface.
ERS-16185CROSS JOIN syntax is now supported in view DDL on Teradata.
ERS-16222The 'over' keyword is now supported in view DDL on Teradata.
ERS-16354Creating a group and assigning object privilege now generates a correct DDL Statement in DB2 LUW V9.
ERS-16409CROSS APPLY syntax is now supported in procedure SQL on SQL Server 2005.
ERS-16410RANK() OVER syntax is now supported in procedure SQL on SQL Server 2005.
ERS-16413Information is no longer truncated in the Get Diagram UI when there are a lot of users logged in with objects checked out.
ERS-16459Validation of view DDL not longer fails for valid tables/columns referenced in nested SELECT statements.
ERS-16465Stored procedures whose SQL contains the 'precision' keyword now validate correctly on SQL Server.
ERS-16556The automation interface now supports creation of Windows Authentication users without having to specify a password.
ERS-16589The parser for materialized views no longer fails on the 'replicated' MQT option and now handles common table subexpressions in MQT queries.
ERS-16602The application no longer crashes while reverse engineering a table and a public synonym for the same table when a naming standards template with a lowercase conversion is specified.
ERS-16609Whitespace at the end of view DDL no longer results in erroneous differences during compare/merge.
ERS-16623Submodel definitions are no longer lost when checking in a model on Oracle.
ERS-16642The "distinguished name" is now being correctly identified when given a short domain name during LDAP authentication.
ERS-16669When reverse engineering an existing Oracle database, columns are no longer missing from views that use derived tables.
ERS-16703The "Allow null" radio button is no longer greyed out for Integer columns in a PostgreSQL physical model.
ERS-16734An error no longer occurs while reverse-engineering constraints on a Sybase IQ 12.6 database that was upgraded from version 12.5.
Bugs Fixed in ER/Studio 8.0.1
ERS-10692A column option has been added to ignore collation when comparing a model to the database for SQL Server.
ERS-11420Invalid DDL is no longer produced after updating a second table defined within a union view.
ERS-11906Empty domain definitions can now be deleted from the definition tab for an attribute or column bound to a domain.
ERS-12477Required CREATE VIEW privileges are now properly granted to new Repository schema owners on Oracle 10.2.
ERS-13514SQL Server procedures with subqueries now validate correctly.
ERS-13575Constructor functions with 'result' as parameter names are now handled correctly when validating an object type.
ERS-13659Extra spaces are no longer inserted before index columns when function-based indexes are reverse-engineered.
ERS-13710The 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-15373The Data Lineage tree now supports multiple selections of components using the Shift key.
ERS-15374You no longer need to hold down the Ctrl key when attempting to drag multiple components to the Data Lineage view.
ERS-15509The Automation Interface now has a method to set the current active Data Flow.
ERS-15512The Models collection in the Automation Interface no longer includes Data Flows.
ERS-15541The 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-15818The Colors & Fonts dialog has been updated for Data Lineage objects.
ERS-15857There no longer performance issues when performing a Get Latest on large Repository diagrams.
ERS-15866Ctrl-A and Ctrl-Shift-A are now supported in the Data Lineage view.
ERS-15875New views are now always available in the Local Models node of the Data Lineage tree.
ERS-15887Data Lineage components can now be deleted from Repository models using the tree context menu.
ERS-15899Internal quicklaunches in the Import Source wizard are now working properly.
ERS-15925Sources 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-15926You can now add definitions and attachments to Data Flows.
ERS-16003Data Flow images are now supported in the Report wizard.
ERS-16021The About Box is now refreshed when you add another single platform license until the application is restarted.
ERS-16039Data 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-16055The 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-16138The datetime datatype is now available in SQL Server 2008 models.
ERS-16275Default 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-13929The Submodel Synchronization Utility now remains stable when synchronizing submodels.
ERS-14008ER/Studio now performs better when reverse-engineering from SQL Server 2005.
ERS-14085ER/Studio now performs better when reverse-engineering from Oracle 10g.
ERS-14445HTML Reports now properly include all submodel images.
ERS-14522The Submodel Synchronization Utility now remains stable when synchronizing submodels.
ERS-14685ER/Studio now properly reverse-engineers Oracle 9.2.0.1 databases.
ERS-14710The Infer Foreign Keys From Names option in the Reverse-Engineering Wizard is now case sensitive.
ERS-14722The Diagram Grid settings in Diagram Display Options now works properly.
ERS-14732The Validate Model wizard no longer flags items that are not errors.
ERS-14735The Generate Physical Model wizard now uses the correct view column names.
ERS-14741ER/Studio now remains stable when editing an entity on a French or German system.
ERS-14943The Automation Interface now allows the creation of DB2 Aliases when the referenced table name is longer than 18 characters.
ERS-14966The Add Physical Model wizard now remains stable when adding a model from another DM1 file.
ERS-14972The DDL Wizard now properly generates composite PK indexes.
ERS-15046The DDL Wizard now properly generates Pre-SQL that contains DROP PROCEDURE statements.
ERS-15109The Add Physical Model wizard now remains stable when adding a model from another DM1 file.
ERS-15152The Automation Interface now performs better when running macros with large models.
ERS-15176The Repository Rename Diagram feature now works properly when the Repository model contains overflow data.
ERS-15182The PrintOptions.Margin property in the Automation Interface now works properly.
ERS-15183The PrintOptions.BoderWidth property in the Automation Interface now works properly.
ERS-15184The PrintOptions.PrintObjectBackground property in the Automation Interface now works properly.
ERS-15185The PrintOptions.Margin property in the Automation Interface now works properly.
ERS-15226The Compare Wizard now properly matches foreign attributes.
ERS-15269ER/Studio now properly parses DB Aliases that have "K" as an owner name.
ERS-15275The correct Project Information is displayed in Reports generated by the Automation Interface.
ERS-15445The Compare Wizard now properly merges subtype relationships.
ERS-15446The SQL Server index editor now allows indexes of the same name on different tables.
ERS-15469Text entry in the Tablespace control in the Oracle Subpartition Editor is no longer limited to the width of the control.
ERS-15508The DDL Wizard now generates the DDL that runs properly in Oracle SQL*Plus.
ERS-15550The Compare Wizard now properly matches foreign attributes.
ERS-15582The Generate Physical Model wizard now remains stable.
ERS-15684The DDL Wizard now properly generates functions named AT when brackets are included.
ERS-15720The Overview Window no longer displays objects that are not visible in the model.
ERS-15729Set Named Release now works properly on Repository models that contain logical models in Dimensional notation.
ERS-15730Set Named Release now works properly on Repository models that are modified when loaded.
ERS-15980SQL 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 sales@embarcadero.com, or uk.sales@embarcadero.com 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.