Redgate Blog

Posts tagged with SQL Source Control

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

Roseanna Mumby

10 February 2021

Roseanna Mumby

10 February 2021

Customer tips for improving productivity with Redgate products

We recently invited our customers to share their top tips for improving productivity in the first Redgate Tool Tips Swap. This post outlines their hints for using Redgate products to boost productivity and includes relevant training resources to further your learning. SQL Prompt Share formatting settings across your team to… Read more

1 August 2020

1 August 2020

An introduction to SQL Source Control

Updated August 2020 In our series of blog posts about Version Control and the Database, we’ve explored the history of version control, why databases have some unique requirements, and why it’s important to include them in your VCS. In this concluding post, I focus on Redgate SQL Source Control and… Read more

SQL Source Control

Bob Walker

26 September 2016

Bob Walker

26 September 2016

Versioning an existing database using SQL Source Control

How to bring an existing database under Git version control. Read more

SQL Source Control

Kate Duggan

2 June 2016

Kate Duggan

2 June 2016

Teamwork is the key to developing SQL Source Control as well as using it

The long-awaited release of SQL Server Management Studio (SSMS) 2016 is approaching, bringing with it a more modern look and feel, more features, and more advantages for users. At Redgate, we’ve been working closely with Microsoft to make sure the latest version of SQL Source Control supports SSMS 2016 from launch… Read more

SQL Source Control

Matthew Flatt

27 July 2015

Matthew Flatt

27 July 2015

Source controlling your database permissions

How to use a combination of database roles, along with rules, filters and post deployment scripts in SQL Source Control, to add the required users to the correct role, for each database. Read more

22 July 2015

22 July 2015

The key to avoiding database version control problems

It’s a familiar story. Two developers are working on a database, they’re using version control, and there’s a problem. The bigger problem is, they don’t even know they have a problem. As far as they’re concerned, they’re doing everything right. They’ve been using version control, so they can deploy the… Read more

30 June 2015

30 June 2015

Sometimes the tool just fits – using SQL Change Automation and Octopus Deploy for Data Change Control

From a business risk perspective, data change can be just as significant as code or schema change. Sometimes even more so; an incorrect static (or reference, or master) data change can drive your software’s behaviour more dangerously askew than pretty much any bug can. Imagine treating a retail customer for an investment… Read more

automated deployment

SQL Change Automation

SQL Source Control

Alex Yates

12 June 2015

Alex Yates

12 June 2015

Source controlling database users

Where developers have their own databases, you need to ensure the user accounts are configured identically across all development and test server, or you'll inevitably hear the phrase “…but it works on my machine”. Alex Yates describes, strategically, how this might work. Read more

26 March 2015

26 March 2015