Get the ApexSQL newsletter

You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Join 120,000+ subscribers

Solutions Products Downloads Prices Support

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

ApexSQL Compare and Sync 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

Database administration
Automate critical tasks for database administration

Database development
Integrate database changes and automate deployments

Solution center

SQL code smells

Improve SQL code smells with best coding practices reviews and enforcement

ApexSQL Enforce

Features Resources Gallery Content Compare

Free trial

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

Features

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

Resources and support

Content

FAQs

(45)

Knowledgebase

(9)

News

(18)

Release notes

Requirements

Solutions

(2)

Videos

(1)

View, add and update rules for SQL code smell and SQL coding best practices

Editing the customizable conditions in SQL code smell and SQL coding rules

Importing SQL code smell and SQL coding rules from another rulebase

Review the results of a SQL code smell and SQL coding best practices review

Reviewing the results of a processed rulebase from a SQL code smell and SQL coding best practices review

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.

	ApexSQL	Redgate^®
SQL Server version
SQL Server 2005
SQL Server 2008 - 2019
SQL Server editions
Express
Standard
Enterprise
Cloud
Amazon RDS for SQL Server
Azure SQL Database
Integration
SQL Server Management Studio 2012 - 2014
SQL Server Management Studio 2016
SQL Server Management Studio 17 - 18
Visual Studio
Configuration
Merging rulebases (importing, exporting)
Set thresholds for running process
Data sources
Databases
SQL scripts
Managing rules
Add rule
Clone rule
Delete rule
Edit rule
Reporting
XML
FixSQL
HTML
Rule categories
Code
Deprecated features
Design
Maintenance
Naming conventions
Performance
Query
Security
Other
Multi violation per rule
Save project as batch
Interface
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 3.1.2.84

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

Testimonials

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

Learn more

Get the ApexSQL newsletter

You'll receive

Database administrationAutomate critical tasks for database administration

Database developmentIntegrate database changes and automate deployments

SQL code smells

Features

Enforce best practices

Create and manage rulebases

Create new rules

Manage rules

Report and export results

Process static scripts

Customize severity, impact score and failure thresholds

Categorize rules

Programmatically construct Fix SQL statements

Write rules down to the statement level

Explore rulebases

View results

Visual themes

Resources and support

Content

FAQs

(45)

Knowledgebase

(9)

News

(18)

Release notes

Requirements

Solutions

(2)

Videos

(1)

ApexSQL Enforce 2018 – Screen shot tour

How to enforce best practices rules against your database

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

Rules 101 – getting started with ApexSQL Enforce

How to fail at running rulebases

How to import new rules into an existing rulebase

Testimonials

ApexSQL DevOps toolkit

Database administration
Automate critical tasks for database administration

Database development
Integrate database changes and automate deployments