Toad Data Modeler 6.4 - User Guide

Microsoft SQL Server 2016

External Table support (PolyBase external table that references data stored in Hadoop cluster or Azure blob storage). External Tables can be found in Physical Model Explorer.

Security Policy support (for row-level security). Security Policies can be found in Physical Model Explorer.

New model objects with simplified support:

• Column Encryption Key - currently without any properties, used for Encrypting Columns.
• External Data Source - currently without any properties, used for External Table.
• External File Format - currently without any properties, used for External Table.

IF EXISTS support for DROP commands of certain object types:

• Entity, View, Relation, Trigger (entity/view), Key, Index, Default, Rule, DictType, UDT, Procedure, Function, Aggregate (Functions), Synonym, Assembly, Sequence, FileTable

• To use the clause, enable the Check Object Existence Before Processing Drop Commands option in DDL Script Generation | Detail Settings.

Entity

• Memory Optimized Tables:
  • It is now possible to create the following objects in memory optimized tables:
    • Triggers (Natively Compiled only)
    • Index (Clustered Columnstore only)
    • Foreign Key constraints (between memory optimized Tables)
    • Check constraints
    • Unique constraints

• "Period for System_Time" and "System-Versioned Temporal Table" support for Tables (Attribute Properties | Temporal Properties tab AND Entity Properties | Temporal Table Properties tab)
  
  

Attribute

• Dynamic Data Masking support for Attributes (Attribute Properties | Masking and Encryption tab | Dynamic Data Masking)
• Always Encrypted support for Attributes (Attribute Properties | Masking and Encryption tab | Encrypting Columns)

Function

• New Function types:
  • Natively Compiled Scalar Function
  • Natively Compiled Inline Table-valued Function

• EXECUTE AS CALLER for Natively Compiled Stored Procedure Functions (used by default).

Index

• New parameter - COMPRESSION DELAY for COLUMNSTORE Indexes.
  
  
• Filter predicates (WHERE) can be now used in non-clustered COLUMNSTORE Indexes.
• Non-clustered Indexes can be now created even when CLUSTERED COLUMNSTORE Indexes already exist.

User

• ALLOW_ENCRYPTED_VALUE_MODIFICATIONS = ON | OFF support for Users (in Reverse Engineering).

Misc.

• Support for Stretch Database (REMOTE_DATA_ARCHIVE) in SQL Server 2016
• To create a Table for remote data archive see Entity Properties | Stretch Database Properties

Reverse Engineering

Available Data Providers are:

• Connection via ADO
• Native Connection

Connection via ADO:

Native Connection:

Reverse Engineering Settings

• Check Graph Table Columnsto include graph table columns $node_id", "$edge_id", "$from_id", "$to_id in your RE

Script Generating

Microsoft SQL Server 2017

Entity

• New node and edge (graph) tables are now supported
• Click Add Atribute to add graph table specific attributes. In Attributes, these will be called using $node_id and $edge_id, $from_id, $to_id for node and edge tables respectively

Details

• CREATE EXTERNAL LIBRARY: External libraries are not supported
• CREATE OR ALTER: this clause is now supported for procedures, views, functions, and triggers (with exception for Change Script Generation where only Alter or Drop and Create are used)