Lançamentos do ER/Studio Data Architect for SQL Server
Released: Mar 19, 2024
Atualizações na 20.1
Recursos
- You can now allow user-defined names for the History Table.
Released: Nov 21, 2023
Atualizações na 20.0
Recursos
- Improved the 'Diagram Data Version Upgrade' user interface.
- Repository Options dialog box now allows users to select whether to add DDL code to Team Server.
- Added support for comments on View Columns in the View Editor.
Released: Sep 27, 2023
Atualizações na 19.3.5
Recursos
- Improved connectivity to Microsoft database platforms.
- Added support for Multi-Factor Authentication for Reverse Engineering of Azure SQL DB and Synapse - While generating a script file or database, reverse engineering an existing database, or using the Compare and Merge Utility, users can now choose from new authentication types for the following databases:
- Active Directory - Managed Identity.
- Azure Active Directory - Password.
- Azure Active Directory - Service Principal.
- Azure Active...
Released: Jun 15, 2023
Atualizações na 19.3.4
Recursos
- Added JSON modeling properties to COM API.
- Added the ability to select the number of items in an array in JSON - minItems and maxItems.
Correções
- JSON number field constraints must allow decimal values.
- JSON Strings with a format should not include width.
- Cannot set string without width in JSON.
- JSON format"date=time" incorrect syntax.
- Attachment binding disappears from foreign Key when deleting other attributes.
- Reverse engineer schema selection button is disabled when trying to select...
Released: Jun 14, 2023
Atualizações na 19.3.3
Recursos
- Security improvements.
- Parent and Child Entities are now listed for Relationship lines.
- REST API performance improvements.
Correções
- Role names are not propagated for Containment lines.
- Batch publishing diagram fails.
- Hide the Foreign Key property for Containment Relationships.
- Incorrect user email address for LDAP Single Sign-On users.
Released: Oct 12, 2022
Atualizações na 19.3
Correções
- In the Reverse-Engineer SQL Server Views, definitions are truncated to 8000 characters.
- Single-platform license for JSON does not show JSON Instance platform.
- Bound reference values not appearing in Enum in JSON Schema.
- Unique constraint name missing when generating the DDL.
- After upgrading to version 19.1, views are showing invalid.
- SQL Import datatypes not parsed when brackets are in DDL.
- Entity Editor Entity Name field does not allow scrolling to the right.
- Creating a database does...
Released: Nov 16, 2021
Atualizações na 19.1.1
Correções
- Resolved the View Validation Results window scroll issue.
- Resolved an issue with the Macro functions on Model object lists.
- PK constraints now are properly imported from SQL on SQL Server.
- DDL now is generated for sequences without schema names.
- Reverse-engineering columnstore indexes with more than 32 columns completes appropriately.
- Improved Procedures/Triggers syntax handling for SQL Server.
Released: Aug 1, 2021
Atualizações na 19.1
Recursos
- Updated compare/merge script generation to create the foreign key after the parent table.
- Updated the INTERVAL DAY(0) datatype in the live database to no longer be reversed as INTERVAL DAY(11).
- Updated compare/merge to now generate the correct extended alter SQL in specific cases.
- Added the ability to populate the GetFilePath() file name in macros.
- Now retains the Quick Access toolbar and styles are now persistent when a style is chosen.
- Added the ability to specify a backup folder...
Released: Jun 4, 2021
Atualizações na 19.0.0
Recursos
- Added support for Microsoft SQL Server 2019.
- Allows users to log in to Team Server when logging into Repository.
- Allows users to relate Business Terms with ER Objects.
- Added support for the 'where' clause.
- Added support for the ‘Columnstore’ indexes for SQL Server 2012.
- Added support for Spatial Indexes.
- Allows users to define table and index compression.
- Allows users to model temporal tables.
- Added support for extended properties for SQL Server Tables and Columns.
- Allows TLS between...
Released: Nov 6, 2020
Atualizações na 18.5
Recursos
- Added a new ribbon-based user interface for ease of use. Available actions are now located on ribbon bars for:
- Diagram - Includes the functions related to creating and maintaining a data model diagram, such as editing, formatting, and viewing.
- Insert - Includes the functions related to placing graphical objects onto a diagram, divided into Logical, Physical, and Data flow types.
- Model - Includes the functions related to managing the model as a whole, including generating a physical...