ER/Studio Data Architect for SQL Server 新版本发表

Released: Dec 17, 2025

20.9.1 中的更新

特性

  • Added JSON/DDL to the Table API.
  • Added Relationship Information to the Table API.
  • Added Index Information to the Table API.
  • Added Platform Field to the Model API.
  • Created a new sample macro to bulk import from PowerDesigner.
  • Created proper alter script for dimensional tables.
  • Restore proxy details automatically in the Configurator after upgrading.
  • Updated Compare/Merge functionality to allow more than 1004 characters in the report.
  • Updated the Default Users group to have the No Access role by...

Released: Oct 29, 2025

20.9 中的更新

特性

  • Reverse engineer and model embedded JSON data in standard RDBMS platforms.
    • This feature allows you to take advantage of the flexibility of JSON while also providing improved data documentation and governance.
    • You can map the fields in the embedded JSON to Business Terms and populate the data catalog.

Released: Jul 9, 2025

20.8 中的更新

特性

  • Introduced the new AI Data Modeling Assistant feature, allowing you to create a logical data model using a block of text. This feature is available by clicking Generate Using AI when creating a new file or by clicking the AI Model Builder button in the Tools ribbon bar. The AI Model Builder dialog allows you to type prompts for the tool to create a new model. Click Surprise Me to include an example prompt so that you can get an idea of what information and format helps the AI build a good...

Released: Mar 10, 2025

20.6 中的更新

特性

  • Data Vault Tools
    • New workflow macros generate Data Vault assets from model objects
      • Intelligent Hub Creation from Business Models.
      • Effortless Link & Satellite Generation.
      • Eliminating Source System-Driven Data Vaults.
      • Automated Data Lineage & Model Synchronization.
  • Data Platform Support
    • Enables clients to design and document databases using the latest platform features
      • MS SQL Server 2022 Support - Verified for reverse engineering, SQL imports, DDL generation, and ALTER script creation...

Released: Oct 26, 2024

20.3.1 中的更新

特性

  • You can now resize the Entity Name text box in the Entity/Table Editor.
  • Users can now access the Where tab from the Popout Attribute editor.

修补程序

  • Prevented the Diagram UI from freezing after multiple actions.
  • Resolved a missing bitmap error for Business Data Objects.
  • Resolved an issue with the Extended Properties API for Attributes in a macro.
  • Resolved an issue resulting from canceling within the Domain Editor.
  • Resolved an issue causing a crash when opening a file saved in ERDA 20.x while...

Released: Aug 6, 2024

20.3 中的更新

特性

  • Added support for Git - This release allows you to deploy a Devops process by integrating Data Architect with your Git repository. This feature allows you to commit CREATE DDL to your Git repository as well as use the Compare/Merge functionality to compare models with previous versions of that CREATE DDL in your Git repository. You can get started in setting up your Git integration by clicking the Git Options button in the Tools menu. You must be in the Physical Model view for this option to...

Released: Jun 8, 2024

20.2 中的更新

特性

  • Added support for Bloom filter indexes.
  • Updated the Data Catalog Tree to show Fields instead of Objects for the tree nodes.

修补程序

  • Resolved an issue causing users to receive user interface errors when attempting to use Chinese characters.
  • Resolved a Compare and Merge issue causing complicated Drop/Create TABLE statements to result when adding a column to the end of a Table using SQL Server.
  • Resolved an issue causing ERDA to fail when reverse engineering Pivot views.
  • Resolved an issue causing...

Released: Mar 19, 2024

20.1 中的更新

特性

  • You can now allow user-defined names for the History Table.

Released: Nov 21, 2023

20.0 中的更新

特性

  • 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

19.3.5 中的更新

特性

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