A data catalog for SQL Server

Redgate's working on a data catalog solution to enable PII data stored in SQL Server to be classified according to its sensitivity, and for this information to be automatically retrieved and reported on for compliance purposes.

A data catalog acts as a central reference guide for content stored in schemas across the estate. Database teams can better understand the source data and implement processes for its ongoing protection. When a report's needed, or in the event of an audit, relevant information can be identified and retrieved quickly.

Join the program

What we're working on

We’re exploring levels of automation for classifying columns and keeping this information up to date.

Identifying sensitive data for classification

We’re exploring levels of automation for classifying columns and keeping this information up to date.

We’re making it easy for you to navigate your SQL Estate and retrieve information on data classification.

Inventory management

We’re making it easy for you to navigate your SQL Estate and retrieve information on data classification.

We’ve integrated with SQL Provision to help protect sensitive information when supplying data to dev and test environments.

SQL Provision integration

We’ve integrated with SQL Provision to help protect sensitive information when supplying data to dev and test environments.

Latest release

Version 1.3.26/1.3.27 Released: March 21st, 2019

Features

  • Added the ability to download a CSV file of all columns and tags in a database.
  • Extended columns' data type by including max length, precision and scale, e.g. data type is now "nvarchar(20)" instead of "nvarchar" and "numeric(12, 2)" instead of "numeric".
  • It is now possible to add tags to the built-in Microsoft categories, 'Information type' and 'Sensitivity label'.

Improvements

  • The instance and database lists will now not refresh every time they are visited; it must be refreshed manually instead.
  • Improved performance of fetching columns on columns page.

See full release notes

What's next

What we're currently working on:

In development

  • Reporting
  • SQL Server authentication

Researching

  • Improved authentication.
  • Reporting (export of classification information).

Taking part in our early access program

With your help, we aim to solve the challenge of maintaining up-to-date classifications of sensitive data (including PII) stored in SQL Server for reporting and compliance purposes.

We’d like to work closely with you to:

Understand how you’re discovering and classifying data across your SQL Server estate and maintaining this information

Create an opportunity for you to work with our developers, provide feedback on new software releases, and influence our roadmap

Join the program

Get the EAP build