DB Assessor will check several aspects of your database schema and data. Once an assessment is made, you can generate a report of issues for review. You can also pick and choose individual issues for creation of automatically generated fix scripts.
DB Assessor will prove a useful tool for managing your SQL databases.
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.
Requirements:
· NET Framework 3.5
Limitations:
· Script Generation, Configured Scan Scripts, Semi-Automatic Update and Rules SDK not available.