SchemaSmith Enterprise Documentation

Feature List

Enterprise features unlock a world of possibilities.

Development Cycle

Overview

  • No limits on seats.
  • No limits on servers.
  • No limits on databases being managed.
  • Priority support and enhancement requests.

DataTongs

Supports exporting scripts and/or JSON content. The content files can be used with either Data Delivery or as file tokens for custom data-delivery scripts.

SchemaTongs

SchemaQuench

  • Configurable Script Folders, including multiple new Quench slots, are supported at the Template and Product levels.
  • Optional deployment of tables and table components.
  • Script Tokens drastically expanded and available everywhere. New file and query token types added plus several special system-provided tokens are available.
  • Custom Table Properties for the tables and their components. These custom properties become available in your scripts via new script tokens.
  • Ability to customize table drop behavior.
  • Support for high availability SQL implementations, allowing you to define secondary servers for applying scripts such as jobs or server configurations. You can also define templates to update databases which are not part of the Availability Group across both primary and secondary servers if needed.
  • Faster updating with threading support for multiple tables and/or secondary servers.
  • Index Only template support.
  • Data Delivery

SchemaHammer

  • Only available in the Enterprise Edition.
  • Intuitive JSON Product and Template definition editing facilitates the creation and management of reusable schema components.
  • Intuitive JSON Table definition editing to more easily modify Table structures using a familiar tree view interface.
  • Table and column rename support.
  • SQL Syntax Highlighting enhances readability for column defaults, expressions, and SQL fragments, and provides an in-tool SQL Editor for all your object and migration scripts.
  • Script preview lets you see the SQL script with the tokens replaced in a syntax-highlighting window.
  • Live object application lets you apply changes to objects against a test server in real time during editing.
  • Advanced search capabilities to quickly locate and navigate to schema elements either by name or content search.
  • Manage your Script Tokens at the Product and Template levels, including search and the ability to jump to the token from within a script editor.
  • A Configurable Menu System allowing you to integrate your favorite source control tools, difference editors, and more.
  • Define Configurable Script Folders at the Product and Template levels and see their contents in the tree.
  • Extensible table editors that can be extended and customized for editing your Custom Table Properties.

Product Options

Product level options include:

  • Configurable product level script folders
  • New before and after quench slots
  • Server to Quench options

Template Options

Template level options include:

  • Template level script tokens
  • Configurable template level script folders with new quench slots
  • Server to Quench options
  • Index Only Table Quenches

Table Options

  • Custom Property Support
  • Optional Update Fill Factor support extended down to the table level
  • Should Apply for optional delivery
  • Data Delivery

Column Options

  • Custom Property Support
  • Encryption Support
  • Should Apply for optional column delivery
  • Default, CheckExpression, ComputedExpression and ShouldApplyExpression properties can access Script Tokens and special tokens for the custom properties on the current column or table

Index Options

  • Custom Property Support
  • Optional Update Fill Factor support extended down to the specific index level
  • Should Apply for optional index delivery
  • FilterExpression and ShouldApplyExpression properties can access Script Tokens and special tokens for the custom properties on the current index or table

XML Index Options

  • Custom Property Support
  • Should Apply for optional XML index delivery
  • ShouldApplyExpression property can access Script Tokens and special tokens for the custom properties on the current index or table

Foreign Key Options

  • Custom Property Support
  • Should Apply for optional foreign key delivery
  • ShouldApplyExpression property can access Script Tokens and special tokens for the custom properties on the current key or table

Check Constraint Options

  • Custom Property Support
  • Should Apply for optional constraint delivery
  • CheckExpression and ShouldApplyExpression properties can access Script Tokens and special tokens for the custom properties on the current constraint or table

Statistic Options

  • Custom Property Support
  • Should Apply for optional statistic delivery
  • FilterExpression and ShouldApplyExpression properties can access Script Tokens and special tokens for the custom properties on the current constraint or table

Full Text Index Options

  • Custom Property Support
  • Should Apply for optional index delivery
  • ShouldApplyExpression property can access Script Tokens and special tokens for the custom properties on the current index or table

Additional Resources