Schema Detective is an innovative tool for finding sensitive data and referential relations within the database. Simple to use, yet powerful, it enables the detection of data across the entire database instance (server), utilizing various search patterns. In addition, it allows the identification of application referential relations – even in the lack of database foreign-keys.
Features of Schema Detective
- Finds data across the entire instance (server) in minutes.
- Handles databases and tables of any size.
- Can search inside large text fields, e.g. CLOB, varchar(max).
- Utilizes both wildcard and regular-expressions search patterns.
- Allows re-use of your favorite detection rules through a detection dictionary.
- Detects referential relations defined only in the application.
- Displays data’s referential relations defined in the database.
- Supports both Oracle and SQL Server