How to make a Custom Rule for a SQL Database
Here is an example for how to make a Custom Rule "Every table name must start with 'tbl'":
-
Script out the database
-
-
Figure: Generate script for the database to a script file
-
Run Code Auditor and go to "Select Job" page
-
-
Figure: Select 'a sample SQL Script project'
-
Select files to scan
-
-
Figure: Select files
-
Adding a new rule
-
-
Figure: Click Add button to create a new rule
-
-
Figure: Enter new rule name
-
-
Figure: Enter rule URL and note
-
-
Figure: Enter File Filter and Search pattern (Regex)
-
Rule Processing
-
-
Figure: Click Start button to start Rule Processing
-
Rule Result
-
-
Figure: Rule Result Page - show you a summary of the rules that passed and failed
-
Rule Report
-
-
Figure: Rule Report - Show you the details of the rules that passed and failed
-
More details and screen shots on Creating New Rule