Quest Software ApexSQL Enforce 2019.03.0299

Introduction to Quest Software ApexSQL Enforce 2019.03.0299

Overview

Quest Software ApexSQL Enforce is a best practices enforcement tool for SQL Server database objects and scripts. It helps in reviewing, detecting, and fixing issues related to database best practices. The software comes with an integrated editor that features code auto-complete for writing custom rules. It also offers a library of over 100 out-of-the-box rules covering SQL best practices, naming conventions, potential configurations, and more.

Features

• Review databases and individual SQL scripts.
• Process unattended via the CLI.
• Leverage a library of 100+ pre-written rules.
• Write custom rules in C# or VB.NET.
• Code rules in an integrated IDE.
• Import and export rules.
• Seamlessly integrate into your CI/CD process.
• Create custom rules with a built-in IDE.
• Create HTML reports and XML exports.
• Generate SQL to fix violations.
• Enforce Best Practices
• Process databases and scripts against more than 100 out-of-the-box rules.

Use Cases

• Enforcing best practices in SQL Server databases.
• Detecting and fixing issues related to naming conventions and potential configurations.
• Automating the review process of databases and SQL scripts.

Technical Details and System Requirements

• Supported OS: Windows 11, Windows 10, Windows 8.1, Windows 7
• RAM (Memory): 2 GB RAM (4 GB recommended)
• Free Hard Disk Space: 200 MB or more