Lançamentos do ER/Studio Data Architect for SQL Server

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

Released: Sep 19, 2020

Atualizações na 18.4

Recursos

  • Added new Datatype Mappings File Merge tool - This utility allows you to merge into the latest ER/Studio version all user-defined logical and physical datatypes and their mappings from previous versions and resolve any duplication.
  • Expands support for logical data types - ER/Studio adds support for the following logical datatypes:
    • ARRAY
    • RANGEINT4
    • RANGEINT8
    • RANGENUMBER
    • RANGETIMESTAMPTZ
    • RANGETIMESTAMP
    • RANGEDATE
    • OBJECT
    • FLOAT4
    • FLOAT8
    • TIMESTAMPTZ
    • TIMESTAMPTZL
    • JSON
  • Adds Spell Check management...

Released: May 22, 2020

Atualizações na 18.3

Recursos

  • Added the ability to send email notifications when an object that a user is following has changed.

Released: Dec 6, 2019

Atualizações na 18.2

Recursos

Addition of several MetaWizard model import bridges:

  • OMG UML 1.x XMI 1.x
  • OMG UML 2.x XMI 2.x
  • Borland Together (via UML 2.x XMI)
  • CA Component Modeler 4.x (via UML 1.x XMI)
  • Microsoft Office Visio UML Class Diagram (via UML 1.x XMI)
  • NoMagic MagicDraw (via UML 2.x XMI)
  • Oracle Data Modeler (ODM) 4.x
  • Tigris ArgoUML (via UML 1.x XMI)

Correções

  • View creation issues.