Welcome to ER/Studio Data Architect® 8.5.3  

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


Thank you for using Embarcadero 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.


WHAT'S NEW IN VERSION 8.5.3

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

Main Features

General Updates

DBMS Updates

Other Enhancements

The following customer requests have been addressed in this release.

Issues Addressed in ER/Studio DA 8.5
ERS-10340 The JPEG export now supports larger models than in previous versions.
ERS-10456 Export Image now supports GIF and PNG formats.
ERS-10575 The Dependencies tab of the Table/Entity Editor now displays views associated with the table. Views are also now listed in the Explorer tree in the Table/Entity hierarchy.
ERS-10822 Index-organized tables with compression are now supported on Oracle.
ERS-14338 TeraData 12.0 is now supported.
ERS-14381 Definitions and Notes now have separate formatting options in HTML reports.
ERS-15554 Drawing shapes are now supported for data flows on the Data Lineage tab.
ERS-15555 The Display Levels for Data Lineage objects are no longer mutually exclusive.
ERS-15557 In the Data Lineage explorer, the inputs and outputs under each transfromation lists columns and attributes.
ERS-16267 The list of diagrams in the Get from Repository dialog can now be filtered.
ERS-16365 Enable constraint for PK and FK is now supported on Oracle.
ERS-16366 Index-organized tables with compression are now supported for Oracle 10g.
ERS-16431 The Macro Editor now retains any new settings.
ERS-17100 Comments can now be added to model objects.

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

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-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.
ERS-16916The Portal View tree is sometimes not updated properly after dragging another window on top of it.
ERS-17255The ExportImageOptions automation object members currently do not work when exporting data flow images.
ERS-17279System overflow tables for Index Organized Tables are currently not hidden in the Reverse-Engineer wizard.
ERS-17680Comments currently are not supported in Repository Branches.

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 DA 8.5.3

Bugs Fixed in ER/Studio DA 8.5.2

Bugs Fixed in ER/Studio DA 8.5.1

Bugs Fixed in ER/Studio DA 8.5.0

Bugs Fixed in ER/Studio DA 8.5.3
ERS-2485 The Compare Wizard now properly merges logical/physical names when merging Views.
ERS-16506 The Compare Wizard now properly merges semantics changes on Oracle VARCHAR columns.
ERS-17276 Performance when selecting/deselecting objects to be reverse-engineered in the Reverse-Engineer Wizard has been improved.
ERS-17445 Performance when comparing large procedures in the Compare Wizard has been improved.
ERS-17516 The DDL Wizard no longer generates check constraints for columns that have their domains overridden.
ERS-17533 The Domain Update event handler is now triggered when you modify the Override Control settings of a domain.
ERS-17567 The file is no longer marked as changed if you simply scroll through the model using the Overview window.
ERS-17792 The CLUSTER property is now maintained on an index after performing a denormalization mapping.
ERS-17833 It is no longer possible to copy and paste a logical view into an AS/400 physical model.
ERS-17868 Performance accessing the Repository Security dialog has been improved.
ERS-17882Duplicate view names in the Dependencies tab of the table editor are now qualified by the owner name.
ERS-17973 It is now possible to add comments to Subtype Cluster objects.
ERS-18059 The SQL Server Synonym name-length restriction has been changed to 128 characters.
ERS-18098 The DB2 Alias parser now handles references to objects named DEVICE.
ERS-18100 Operations conducted prior to using Switch To in the Entity Editor are not added to the Undo stack.
ERS-18111 The Repository no longer creates duplicate attributes when checking in a diagram that has had relationships deleted with the Make Native option enabled.
ERS-18154 Performance logging into the Repository has been improved.
ERS-18168 The DDL Wizard now generates NUMERIC(0,0) columns as NUMERIC for Postgres.
ERS-18171 The domain and datatype are now displayed properly in the diagram.
ERS-18216 The SQL Server Procedure parser now handles the OVER clause.
ERS-18231 Long definition text is now clipped properly in the diagram display.
ERS-18238 It is now possible to set the Identity properly on a MySQL MEDIUMINT column.
ERS-18242 The SQL Server Index Partition editor now allows you to add any table column to the partition.
ERS-18279 The maximum number of allowed columns in a Sybase IQ table has been increased.
ERS-18315 The Capacity Planning dialog now correctly calculates dynamic growth on a per month basis.
ERS-18321 The Compare Wizard now includes the partition key when creating a new SQL Server table.
ERS-18322 The Automation Interface now remains stable when deleting a newly generated physical model.
ERS-18332 The Report Wizard now handles memory better when working with large models.
ERS-18333 The Automation Interface now properly reports any errors that occur while attempting to export to EMF.
ERS-18362 The DDL Wizard no longer generates an extra delimitier at the end of a PostgresSQL view.
ERS-18372 The Naming Standards Utility now properly converts names where the separator in the source is also designated as an invalid character.
ERS-18404 The GenerateSelectedEntities automation method now works properly in conjunction with the GenDDLUsingFileBasedQuickLaunch method.
ERS-18409 The Repository now properly checks in diagrams where colored data lineage components have been deleted.
ERS-18537 The Automation Interface now remains stable when deleting a newly generated physical model.
ERS-18549 The Colors & Fonts dialog no longer displays columns that are hidden due to denormalization mappings.
ERS-18550 The application now remains stable when dragging objects to the Visual Data Lineage pane.
ERS-18568 The Get Diagram dialog now correctly reports the check out status of a diagram.>/td>
ERS-18629 The performance in the Universal Naming Utility has been improved.
ERS-18636 The SQL Server procedure parser now properly handles DELETE statements.
ERS-18643 The Repository Merge now properly handles conflicts in attribute color/font overrides.
ERS-18671 The View Domain Bindings dialog now shows the correct binding information.
ERS-18701 The Compare Wizard no longer truncates DB2 index and foreign key constraint names.
ERS-18730 The Compare Wizard no longer displays differences in logical properties when comparing against an SQL script.
ERS-18751 The Compare Wizard no longer truncates DB2 Sequence names in GRANT statements.
ERS-18758 The Report Wizard now remains stable when generating a report for a diagram that has two data flows with the same name.
Bugs Fixed in ER/Studio DA 8.5.2
ERS-12621 The Macro Tree no longer displays hidden folders.
ERS-16806 The Oracle Sequence Editor now allows a Max Value of up to 28 digits.
ERS-17757 The Max Length feature in Naming Standards Templates now works properly.
ERS-18358 Attribute bitmaps are now clipped properly when exporting a model image.
ERS-18511 The Online Community link in the Help menu now links to the appropriate web page.
ERS-18512 Attribute bitmaps are now clipped properly when exporting a data flow image.
ERS-18517 The application now remains stable when dragging objects to a Data Flow.
ERS-18544 ER/Studio now remains stable when upgrading 8.0 files that have recursive relationships hidden by denorms.
Bugs Fixed in ER/Studio DA 8.5.1
ERS-18254 ER/Studio DA now remains stable when editing tables.
ERS-18293 ER/Studio DA now remains stable when logging out of the Portal.
ERS-18301 ER/Studio DA now remains stable when generating reports.
Bugs Fixed in ER/Studio DA 8.5.0
ERS-13727 ER/Studio DA now properly reverse-engineers TeraData primary index partition expressions.
ERS-13792 The XML Schema Generation wizard now displays Korean characters properly in the Preview window.
ERS-13994 Naming Standards are now applied properly to rolenamed foreign keys.
ERS-14381 The formatting options for definitions and notes are now separated in the HTML report wizard.
ERS-14521 The "Do Not Generate" flag for tables is now taken into consideration when generating DDL via automation.
ERS-14649 The DDLGenerationObject.GeneratePKByAlterStatement and DDLGenerationObject.GeneratePKByAlterStatementAndUniqueIndex automation interface properties now work properly.
ERS-14820 The Naming Standards Utility now applies invalid character handling before applying abbreviation and word separation rules.
ERS-14842 The DDL Wizard no longer quotes lower case owner names when generating aliases.
ERS-14855 The Branch Merge operation no longer reports that the Data Dictionary needs to be checked in when it is already checked in.
ERS-15101 The performance of the Repository Check Out Object operation has been improved.
ERS-15107 ER/Studio DA now properly parses SQL Server synonyms that include a database name.
ERS-15123 The automation interface now properly handles attachment text lists with duplicate entries.
ERS-15521 ER/Studio DA now supports Distribute By Hash partitioning for DB2 LUW 9.x.
ERS-16431 The Macro Editor now retains the last used settings when the editor is invoked.
ERS-16466 The table editor no longer automatically binds reference values to newly created columns.
ERS-16641 SRTF files are now deleted when upgrading a Repository database.
ERS-16720 The Create Associative Entity option state is now saved in the quicklaunch for the Generate Physical Model wizard.
ERS-16805 The application no longer shuts down after copying all objects in a submodel.
ERS-16693 ER/Studio DA now generates correct SQL Server scripts when the Generate PK By Alter Statement option is enabled.
ERS-16785 The Oracle View parser now supports the "UID" keyword.
ERS-16801 SQL Import now supports columns named "Nickname".
ERS-16834 It is now possible to specify "Unlimited" for Max Segments in the Oracle Lob Segment editor.
ERS-16850 Attachment bindings are now propagated to foreign keys when a relationship is created.
ERS-16864 SQL Import now handles the Enforced clause in DB Alter Table statements.
ERS-16866 SQL Import now handles DB2 functions with the ATOMIC clause.
ERS-16875 The performance of the Universal Naming Utility has been improved.
ERS-16954 The SQL Server view parser now handles table functions with '::" global qualifier.
ERS-16955 The DDL Wizard now generates the correct error message when attempting to overwrite an existing read-only file.
ERS-16970 The Report Title field in the Report Wizard is no longer disabled when the dialog is maximized.
ERS-16995 SQL Server view comments are now generated properly.
ERS-17044 ER/Studio DA no longer displays foreign keys that are hidden by denormalization mappings.
ERS-17160 The HTML Report wizard no longer displays duplicate Foreign Keys in the Relationship report.
ERS-17164 The DB2TbsPartitions automation collection now contains both defined and undefined partitions. A new Defined property was added to the DB2TbsPartition object to indicate whether the partition is defined or not.
ERS-17183 Moving attributes with user-defined mappings no longer causes errors in the DM1 file.
ERS-17193 The DB2 Procedure parser now handles different variations of CASE statements.
ERS-17261 The Naming Standard Utility now correctly modifies foreign key columss that are unified.
ERS-17264 The SQL Server function/procedure parser has been updated to handle value assignments in variable declarations.
ERS-17368 The Sax Basic Help menu item in the Help menu now works properly.
ERS-17392 The SQL Server View parser now handles views with the National Character Set prefix ('N').
ERS-17419 The Compare Wizard now remains stable when comparing models in separate DM1 files to generate alter SQL.
ERS-17449 ER/Studio DA now imports SQL Server 2008 scripts with computed columns.
ERS-17475 Deleting an attribute with User Defined Mappings no longer causes an error in the DM1 file.
ERS-17478 The DB2 table editor now allows users to specify strings of up to 128 characters.
ERS-17485 Enterprise Data Dictionary names are now preserved after checking in changes to the EDD definition.
ERS-17500 The MetaWizard now properly imports ERWin 7 files.
ERS-17512 The MetaWizard now properly imports COBOL Copybook files.
ERS-17524 The automation interface now maintains index column sequences after deleting a relationship.
ERS-17528 The Compare Wizard no longer shows differences in whitespace in procedures.
ERS-17577 The "Auto-Color All Entities With Foreign Keys" sample macro has been updated.
ERS-17582 The Compare Wizard now properly generates alter code for indexes with new columns.
ERS-17595 Duplicate parent keys are no longer displayed in the relationship editor after performing a copy and paste.
ERS-17626 The Compare Wizard now properly merges datatype changes when the source and target columns are bound to different domains.
ERS-17636 The automation interface Relationships collection has a new method, AddWithUnification that unifies new Foreign Keys with existing native attributes instead of deleting the native attributes.
ERS-17641 The Compare Wizard now properly sets the text list value to the default value when merging attachment bindings.
ERS-17666 The Compare Wizard now properly generates view comments for SQL Server.
ERS-17672 The MetaWizard now properly imports ERWin files that have relationships with no type set.
ERS-17732 ER/Studio DA now supports BINARY and VARBINARY datatypes for DB2 z/OS.
ERS-17741 The Compare Wizard now retains the domain folder structure when possible.
ERS-17748 Tables hidden due to denormalization mappings are now excluded from the Bound Objects automation collection.
ERS-17769 The MetaWizard now remains stable when selecting the Sparx Enterprise Architect (EA) via the UML 2.x XMI bridge.
ERS-17771 Foreign Keys are now properly inferred when reverse-engineering from MySQL.
ERS-17825 ER/Studio DA now remains stable when generating an HTML report with the Use Enhanced Version option enabled.
ERS-17826 The automation BoundObjects collection now works properly with unified attributes.
ERS-17845 The SQL Server Trigger parser now handles triggers with "FOR XML".
ERS-17869 Performance has been improved when displaying the Repository Delete Diagram and Repository Change Diagram Filename dialogs.
ERS-17941 Oracle Materialized View comments are now generated properly.
ERS-17952 The "Constraint Generator" sample macro has been updated to handle Reference Values with the "Values NOT Between" option set.
ERS-17997 The Index Editor now properly handles indexes that had the Piecesize set to an invalid value in the Generate Physical Model wizard.
ERS-18012 The Compare Wizard no longer shows differences in whitespace in functions.
ERS-18036 Some performance improvements have been made when expanding a diagram in the Repository Get Diagram dialog.

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, 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.