You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Enforce release notes

Release:

2018.02.0230

Date:

May 17, 2018

Enhancements:

Fixes:

  • The application remains in the Community edition even after it has been activated with the appropriate key
  • The "Object reference not set to an instance of an object" error is encountered when running a set of rules against a database with no relevant objects
  • Running rules is disabled in the Standard edition
  • The "There are no active rules in the current rulebase" error is encountered when running rules from the ApexSQL rulebase via CLI if there are no previously selected rules in the application
  • The application repeatedly asks for the activation key when it is started on an Amazon EC2 instance after the virtual machine resources were deallocated and allocated again
  • The "ApexSQL Enforce is not installed" error is encountered during the ApexSQL CI/CD toolkit Review step execution
  • The installation of a new version does not delete the previous one from the Control panel

Changes:

  • Threshold options are moved to the Threshold tab in the Options dialog
  • The CLI return code for pass is now set to zero when running rules via CLI
  • The CLI return code for failure on processed database is changed from 101 to 102
  • The application now requires Microsoft .NET Framework 4.7.1
  • The Rulebase grid is now grouped by Category column and sort by the Severity column
  • The Reslutset grid is now grouped by the Result column and sort by the Severity column
  • All rules now have the descriptive message for the failure reason
  • Rulebase now can be run unattended on both databases and SQL scripts
  • The Rulebase Object explorer pane is grouped by the Common statements and the Objects

Release:

2018.01.0137

Date:

November 14, 2017

Features:

  • Supports SQL Server 2005 or higher, Azure SQL Database and Amazon RDS for SQL Server
  • Run rules against scripts or databases
  • Write new rules in C# and VB.NET
  • Modify existing rules
  • Code auto-complete in the internal editor
  • Categorize rules
  • Import rules into rulebases
  • Compare two rulebases including individual rules
  • Generate and run Fix SQL scripts
  • Detailed rule execution results summary
  • Command line interface
  • Community, Standard and Professional editions
  • HTML resultset reports
  • XML resultset export
  • GUI themes