ApexSQL Enforce

ApexSQL Enforce is a best practices enforcement tool for SQL Server database objects and scripts. It comes with an integrated editor featuring code auto-complete for writing custom rules and has more than 100 out of the box rules covering SQL best practices, naming conventions, potential configurations and more:

• Enforce best practices

• Review databases and individual SQL scripts

• Create and manage rulebases

• Leverage a library of 100+ pre-written rules

• Create custom rules with a built in IDE

• Write custom rules in C# or VB.NET

• Import and export rules

• Allocate rules to existing or custom categories

• Process unattended via the CLI

• Seamlessly integrate into your CI/CD process

• Integrate with SQL Server Management Studio and Visual Studio

• Create HTML reports and XML exports

• Customize severity, impact score and failure thresholds

• Generate SQL to fix violations

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

See also

• ApexSQL Enforce product page

• FAQs

• Knowledgebase

• Solutions

• System requirements

• (Video) An introduction to ApexSQL Enforce

ApexSQL has more SQL add-ins for Visual Studio to improve SQL developer productivity