How do I setup a Data Governance Database?

This page covers the specific instructions and commands necessary to create the DGS database on each of the supported Database Servers (currently PostgreSQL and Microsoft SQL Server).

PostgreSQL

1. Obtain the DGS database schema file for PostgreSQL from the public GitHub site.
2. Connect to the PostgreSQL server with an account that has permission to create a schema.

3. Open the database where you want the DGS schema to be created.

   Execute the DGS schema file against the selected database.

   1. This will remove any existing schema named DataGovernanceSystem , create a new schema with that name, and then create the standard data governance tables and functions.

Microsoft SQL Server

1. Obtain the DGS database schema file for MS SQL from the public GitHub site.
2. Connect to the MS SQL server with an account that has permission to create a schema.

3. Open the database where you want the DGS schema to be created.

   Execute the DGS schema file against the database server.

   1. This will remove any existing schema named DataGovernanceSystem , create a new schema with that name, and then create the standard data governance tables and functions.