Redgate Blog

Posts tagged with SQL Change Automation

18 March 2021

Moving from application automation to true DevOps by including the database

This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the… Read more

Database DevOps

SQL Change Automation

SQL Source Control

Kendra Little

7 December 2019

Kendra Little

7 December 2019

Dev team chat: Adding static data to SQL Change Automation in SSMS

A great part of working at Redgate is that I get to know folks in our software development teams. They’re smart, fun people, and I love getting a view into how they build our solutions. This post is the first in a series where I’ll interview members of our Versioning… Read more

SQL Change Automation

Mikiel Agutu

19 January 2018

Mikiel Agutu

19 January 2018

Baselining a SQL Change Automation project from an existing database

This article show how to create a 'baseline' for your Visual Studio SQL Change Automation project, from an existing, target SQL Server database, so that the team can start making changes and easily deploy them to the target database. Read more

Baseline wizard

SQL Change Automation

Tom Austin

19 September 2017

Tom Austin

19 September 2017

How to import an existing database to SQL Change Automation

The Visual Studio extension of SQL Change Automation (SCA) allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with SCA, in Visual Studio, and chere I’m going to show to get up and running when there is… Read more

SQL Change Automation

Alex Yates

21 December 2016

Alex Yates

21 December 2016

Database CI with Redgate SQL Change Automation, PowerShell and Jenkins

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

continuous integration

SQL Change Automation

Dan Nolan

13 October 2016

Dan Nolan

13 October 2016

Solving Visual Studio database delivery problems with SQL Change Automation

For .NET developers working with Visual Studio (VS), the introduction of Database Projects with SQL Server Data Tools (SSDT) brought to VS the ability to manage changes to the database schema and code objects, just like any other type of application code. An added advantage is that the declarative style of… Read more

SQL Change Automation

Kate Duggan

28 July 2016

Kate Duggan

28 July 2016

Database automation made easier

Last week saw the release of DLM Automation – a new improved version of our database automation offering. So what’s changed? DLM Automation combines all the functionality of its predecessors, SQL CI and SQL Release, in one unified tool. This means you now only need to install one product in… Read more

continuous integration

SQL Change Automation

David Atkinson

7 June 2016

David Atkinson

7 June 2016

Is your SQL code covered?

No, it almost certainly isn’t. Besides, how would you know either way? Let me explain. Most modern software development today includes some form of automated testing. While comprehensive unit testing is still sorely lacking in many organizations, it’s often mitigated by other forms of automated testing conducted later on in… Read more

continuous integration

SQL Change Automation

SQLCover

Chris Heppell and Peter Gerrard

19 April 2016

Chris Heppell and Peter Gerrard

19 April 2016

Using database replication with automated deployments

For the SQL Change Automation team, it’s important that we take time out from development, occasionally, to explore some of the issues our customers face when automating database deployment. Following on from previous posts about cross-database and cross-server dependencies and production database drift, this article shares some of our thoughts about how… Read more

automated deployment

SQL Change Automation

Dan Nolan

24 March 2016

Dan Nolan

24 March 2016

From Release Engineer to ReadyRoll founder and Redgate Product Manager

ReadyRoll started as a small side project in late 2010 while I was working in the financial services industry. For many years I had been working as a Release Engineer, handling the deployment of all of the company’s line of business applications. Above all else, putting together the database part… Read more

SQL Change Automation

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 SQL Change Automation

Moving from application automation to true DevOps by including the database

Dev team chat: Adding static data to SQL Change Automation in SSMS

Baselining a SQL Change Automation project from an existing database

How to import an existing database to SQL Change Automation

Database CI with Redgate SQL Change Automation, PowerShell and Jenkins

Solving Visual Studio database delivery problems with SQL Change Automation

Database automation made easier

Is your SQL code covered?

Using database replication with automated deployments

From Release Engineer to ReadyRoll founder and Redgate Product Manager

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional