Where to install Redgate Change Control

Redgate Change Control only needs to be installed on developer workstations. It is not necessary to install the tool on any agents used for CI/CD automation. 

Requirements

Redgate Change Control is currently available to be installed on Windows, with the following requirements:

1. .Net Core Runtime – available at https://dotnet.microsoft.com/download 
2. A Development Database that you want to make and capture changes to. These changes are captured in a schema model.
3. A Shadow Database, which is a separate database or schema to run the project's migration scripts against.  The schema model is compared to the Shadow Database when you go to the Generate migrations tab to understand any changes made in development that haven’t been imported into the project migrations yet. 
   1. In the Shadow Database, the user will need permission to create schemas.  If this is not possible, then the schema(s) that you are tracking changes to in the development database needs to exist on the shadow database.  Make sure the schema name in the shadow database has the same casing as the schema name in the development database.
   2. Learn more about the Shadow Database (or Shadow Schema).

Permissions needed

Redgate Change Control uses our comparison technology behind the scenes to understand the differences.  Please review the permissions needed for Oracle or for SQL Server.