DB Assessor
Best practices evaluation and implementation for Microsoft SQL Server databases.
Select the version that provides you with the functionality you need. The following table shows a feature matrix:
Revision History
- 1.0.0.0 - 29-Jun-2008
- Developers Edition documentation finished
- 0.9.9.0 - 1-Jun-2008
- Created EULA document and placed it in the setup
- Made some minor stored procedure parsing bug fixes
- 0.9.5.0 - 22-May-2008 PRE-RELEASE
- Initial publishing at www.AcuteDevTools.com
- 0.9.0.0 - 2-May-2008 PRE-RELEASE
- Created DBDom
- Created Tests, Issues, and Fixes
- Created initial SQL Server scans
- Created basic reporting
Database Assessment
DB Assessor scans your database, looking for best practices in areas like table design and key references.
It then provides you with a list of concerns that you can filter by severity.
HTML Reporting
Once a list of concerns is generated, you can export the list to a simple HTML document for review.
Knowledge Base Access
Registered members get access to a SQL knowledge base.
Script Generation
Some issues can generate script for you that will fix the issue.
You can save the script and review it before executing it in your database management console of choice.
Configured Scan Scripts
With the SQL strings used for scanning your database placed in configuration, you can change them to add filters
or simply read through them to see exactly what the scans read.
Semi-Automatic Updates
Check for updates and automatically install them on startup .
Rules SDK
Don't see the rule you want/need? Code your own!
Read the provided documentation and use the development library to create your specific rules
and execute them in the Assessment Engine as if they were native.
How it works
| After opening a connection to the database, DB Assessor loads and parses the database schema
and performs several tests on the resulting DOM. |
 |
| |
| Select the issues to fix, and generate the scripts for them. Multiple issues can be fixed at once.
Once the script is generated, it can be previewed and saved for execution against the database. |
 |
Pricing
FREE
TRIAL VERSION
Assess your database and generate reports
ONLY
$45.99
STANDARD VERSION
Generate fixes and deploy change scripts
ONLY
$95.99
Create rules and deploy updates