You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Enforce release notes

Release:

2018.03.0244

Date:

Jul 19, 2018

Fixes:

  • "Do you want to install .NET Framework 4.7.1" message is shown when installing the app via CLI using /VERYSILENT and /SUPPRESSMSGBOXES switches
  • The Rule column filter in the Resultset grid does not show filtered objects
  • "Unexpected error occurred." error is encountered when running rules against a database with the user who only has the db_owner permission
  • The HTML report exporting option settings in the stand-alone application are not remembered
  • All databases from the chosen Server are checked for permissions when rules are run against one database
  • Required permissions are checked for all existing databases on the chosen SQL Server
  • The following rules fail if the condition is met:
    • "Statement without TRY...CATCH"
    • "Use of @, @@, or @@ as Transact-SQL identifiers"
    • "Space separator for table hints"
    • "Schema name not specified"
    • "Missing primary key"
    • "Missing clustered index"

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