Can Redgate Tool belt be setup to store changes in Schema into Git repository with pipelines?

Alex_Critier

Can Redgate Tool belt be setup to store changes in Schema into Git repository with pipelines?

Jon_Kirkwood

Hi @Alex_Critier,

 

Thank you for reaching out on the Redgate forums regarding your Toolbelt inquiry.

Our SQL Toolbelt bundle contains two products that would be used in this situation.

 

SQL Source Control and SQL Change Automation that are designed specifically for database version control and automation. 

Here's how you can set up a workflow to store database changes in a Git repository with pipelines using these Redgate tools:

 

1. SQL Source Control: SQL Source Control is a tool by Redgate that allows you to link your database to a version control system, such as Git. Here's how you can set up a workflow with SQL Source Control and a CI/CD pipeline:
   a. Link Database to Git:
   
   • Install and configure SQL Source Control.
   • Link your database to a Git repository, such as GitHub, GitLab, or Bitbucket.
   • Commit your database schema to the repository, and it will store changes as SQL scripts.
   • Set up a CI/CD pipeline (e.g., using Jenkins, Azure DevOps, GitLab CI/CD, etc.).
   • Configure your pipeline to pull changes from the Git repository.
   • Automate the deployment process using SQL Source Control's generated migration scripts.
2. SQL Change Automation: SQL Change Automation is another tool by Redgate that extends SQL Source Control by providing more automation capabilities. It enables you to automate database deployments and manage the database development lifecycle more effectively.
   a. Database Project:
   
   • Create a database project using SQL Change Automation, which is essentially a database representation in code.
   • Link your database project to a Git repository.
   • Set up CI builds in your chosen CI/CD platform to build and test the database project.
   • Automatically generate migration scripts from changes made to the database project.
   • Configure CD pipelines to deploy your database changes using the generated migration scripts.

 

These tools do require a SQL Toolbelt license for automation, alternatively our next generation of solution is Flyway. It provides the functionality of Source Control, Change Automation as well as other Redgate tools like Compare. Flyway is being developed as a database agnostic tool, whilst SQL Change Automation & Source Control are primarily SQL Server only.

 

If wanting more information on these three products, we have the following links:

https://www.red-gate.com/products/flyway/

https://www.red-gate.com/products/flyway/resources/#product-learning

https://www.red-gate.com/hub/product-learning/sql-change-automation

https://www.red-gate.com/products/sql-source-control/resources/#product-learning

Hope this assists with your inquiry.