Redgate Blog

Posts tagged with automated database deployment

10 January 2025

New Redgate Flyway Release – Automate Even More

Read on to learn about how you can automate even more things with Flyway like project setup and state-based deployments. We’ll share how you can get the latest version and things you need to know when upgrading. Read more

automated database deployment

Redgate Flyway

Redgate Flyway Enterprise

Octopus Deploy

4 May 2020

Octopus Deploy

4 May 2020

Pitfalls with SQL rollbacks and automated database deployments

While it’s possible to perform SQL rollbacks to revert database changes, the question is, should you? Rolling back a database change isn’t as straightforward as rolling back a code change. Databases are the lifeblood of applications. An unsuccessful rollback can result in bad or deleted data. This article goes through… Read more

automated database deployment

Octopus Deploy

6 April 2020

Octopus Deploy

6 April 2020

Designing an automated database deployment process: case study

In my previous article, How to design an automated database deployment process, I wrote about the steps companies and organizations should take to introduce automation to their database deployments. In this article, I’m going talk about the challenges I faced when I embarked on my own automation journey. Prior to… Read more

automated database deployment

Octopus Deploy

2 March 2020

Octopus Deploy

2 March 2020

How to design an automated database deployment process

For many companies and organizations, automated database deployments are the final piece of the Continuous Integration / Continuous Delivery puzzle They need to go from deployments that take hours down to minutes. I know from personal experience that it can take many attempts to successfully automate database deployments and the… Read more

automated database deployment

Octopus Deploy

Alex Yates

3 December 2018

Alex Yates

3 December 2018

Database Continuous Integration with the Redgate SQL Toolbelt and Azure DevOps

Alex Yates shows how to set up automated processes for SQL Server database source control, build and continuous integration using Redgate SQL Toolbelt, Git and Azure DevOps Read more

automated database deployment

Phil Factor

16 August 2018

Phil Factor

16 August 2018

Documenting your Database with SQL Change Automation

Phil Factor uses SQL Change Automation and PowerShell to verify that the source code for the current database version builds successfully and, if so, to generate web-based database documentation using SQL Doc. Read more

automated database deployment

PowerShell

Chris Unwin

8 August 2018

Chris Unwin

8 August 2018

Creating Multiple Masked Databases with SQL Provision

Chris Unwin explains how SQL Provision can create copies of multiple databases, each masked consistently, and deliver them as a group. This is useful when, for example, you are working with a Data Warehouse that contains several cross-database relationships. Read more

automated database deployment

PowerShell

Phil Factor

3 August 2018

Phil Factor

3 August 2018

Practical PowerShell Processes with SQL Change Automation

Starting from the object-level source code for a database, Phil Factor shows how SCA can create a NuGet build package, use it to migrate target database to the same version, and publish web-based database documentation, a report of what changed on the target and the results of a static code… Read more

automated database deployment

Nuget

Phil Factor

4 July 2018

Phil Factor

4 July 2018

Deploying Multiple Databases from Source Control using SQL Change Automation

How to automatically build multiple test databases, from source control, and then fill them with standard test data sets, using SQL Change Automation, BCP and some PowerShell magic. Read more

automated database deployment

Source control

Steve Jones

3 July 2018

Steve Jones

3 July 2018

Building Better Test Data with SQL Provision

Steve Jones show how a team might use SQL Provision to build consistent, compliant, useful databases, on demand, for development and test environments. Read more

automated database deployment

database testing

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

Posts tagged with automated database deployment

New Redgate Flyway Release – Automate Even More

Pitfalls with SQL rollbacks and automated database deployments

Designing an automated database deployment process: case study

How to design an automated database deployment process

Database Continuous Integration with the Redgate SQL Toolbelt and Azure DevOps

Documenting your Database with SQL Change Automation

Creating Multiple Masked Databases with SQL Provision

Practical PowerShell Processes with SQL Change Automation

Deploying Multiple Databases from Source Control using SQL Change Automation

Building Better Test Data with SQL Provision

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional