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
Additional Resources
Licensing Your Embarcadero Product
Embarcadero Technologies Product Support
Embarcadero Technologies Technical Support
Embarcadero Technologies on the Web
Release Notes
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-17882 | Duplicate 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 [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, 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.