You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
Review databases and individual SQL scripts
Import and export rules
Process unattended via the CLI
Seamlessly integrate into your CI/CD process
Leverage a library of 100+ pre-written rules
Create custom rules with a built in IDE
Write custom rules in C# or VB.NET
Create HTML reports and XML exports
Integrate with SSMS and Visual Studio
Generate SQL to fix violations


Enforce best practices

Process databases and scripts against more than 100 out-of-the-box rules covering best practices, naming conventions, potential configuration and performance problems and more

See next feature

Create and manage rulebases

Create new/different rulebases by exporting and importing. Download updated rulebases directly from our website and import new rules into your existing rulebase

See next feature

Create new rules

Create your own, custom rules using C# or VB.NET. Code rule conditions using auto-complete, syntax highlighting and all the other features you would expect in an integrated IDE

See next feature

Manage rules

Edit, sort, filter, group and view rules within a grid based interface

See next feature

Report and export results

Create XML reports and XML exports. Export all generated Fix SQL snippets into a single script to fix all detected problems

See next feature

Process static scripts

Review and process stand-alone scripts aka static script analysis

See next feature

Customize severity, impact score and failure thresholds

Customize severity level for rules and impact score for severities. Set custom thresholds for build failure

See next feature

Categorize rules

Allocate rules to existing or custom categories i.e. security, performance, naming conventions within an existing rulebase

See next feature

Programmatically construct Fix SQL statements

Enter static Fix SQL into the rule editor, or create it programmatically via the rule condition

See next feature

Write rules down to the statement level

Our API exposes a script parse tree down to the sub-statement level like elements of a Where or Order by clause. This allows rules to be written to govern script level best practices like statement construction, use of triggers and cursors, variable naming and much more

See next feature

Explore rulebases

View, select and run specific rules from various groups using the Rulebase explorer panel

See next feature

View results

See a summary from a processed rulebase including summary and detail information

See next feature

Visual themes

Customize the visual appearance with interface themes. Learn more

See next feature

ApexSQL Enforce 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Enforce features with a brief description

How to enforce best practices rules against your database

This article covers every step of the code reviewing process, from the setup of a rulebase to reading of the results

Customizing rulebase and resultset grids for grouping, filtering, sorting, searching and displaying

This article describes how to group, sort and filter the rules and the results in the ApexSQL Enforce

Rules 101 – getting started with ApexSQL Enforce

This article is a how to guide on getting started with rules in ApexSQL Enforce

How to fail at running rulebases

This article explains the concept of failure in ApexSQL Enforce and why is it important to fail correctly

How to import new rules into an existing rulebase

This article describes the process of creating a custom rulebase by importing new rules into an existing rulebase.

See more
ApexSQL Redgate®
SQL Server version
      SQL Server 2005
      SQL Server 2008 - 2019
SQL Server editions
      Amazon RDS for SQL Server
      Azure SQL Database
      SQL Server Management Studio 2012 - 2014
      SQL Server Management Studio 2016
      SQL Server Management Studio 17 - 18
      Visual Studio
      Merging rulebases (importing, exporting)
      Set thresholds for running process
Data sources
      SQL scripts
Managing rules
      Add rule
      Clone rule
      Delete rule
      Edit rule
Rule categories
      Deprecated features
      Naming conventions
      Multi violation per rule
      Save project as batch
      Command line interface
      GUI themes
      High DPI and 4K resolution support
      Host aware theme adoption
      Microsoft standard iconography, colors and other visual effects

ApexSQL Enforce 2018.05

Redgate® SQL Code Guard

Comparison was conducted on March 28, 2019

Disclaimer: All product and company names are trademarks™ or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliate


I have worked for 18 yrs as a developer and for the past 5 yrs I have been an application manager, never have I seen a prompt response in my career. Worked with tons of products most of them not as good, but kudos to you man, you have got a great product and promising support.

Trenton D Souza

Application Manager

Clinical NetwoRx

Thanks for great products!

John Saunders

Microsoft MVP

Connected System Developer

ApexSQL Enforce is part of the

ApexSQL DevOps toolkit

© 2022 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy