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