Static Data with Multiple Database Tenants
The loan origination system my team and I are responsible for have 20 tables marked as static data in Redgate's SQL Source Control. One example of static data is a tile type. The
Database Life cycle Management
A collection of 8 posts
Using SQL Source Control to Filter Out Unwanted Items
Everything written on this site is how to get a database change automatically pushed up through the environments. But that was for the entire database. There are some parts of the database where
Rollbacks with Automated Database Deployments
Rolling back a database deployment is one the most complicated topics with Automated Database Deployments. The code is rather easy to rollback, just deploy the previous version of the code package and call
How Redgate Helped Define Our Process
Without the help of Redgate, Farm Credit Services of America's automated database deployment process would not be where it is today. I'm not just talking about their tooling. Their employees have been an
Using Gitflow and Redgate DLM Automation for Continuous Delivery
One of the key reasons to use Redgate's Tooling is to deliver value faster to the business. In order to do that, it is important to have a branching policy in place. This
Scenarios not supported by Redgate DLM Automation Suite
Redgate has built a fantastic Database Lifecycle Management (DLM) suite to help with automated database deployments. Their tools cover 95% of the scenarios most people will encounter day in and day out. But.