Product articles
SQL Toolbelt Database Source Control
SQL Source Control v7 Enhancements
Stephanie Herr summarizes what's new in SQL Source Control v7, including support for Git hooks, Git repositories hosted on Azure DevOps, and pre- and post-deployment scripts. Read more
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 moreDatabase Development in Visual Studio using SQL Change Automation: Getting Started
Steve Jones shows how to set up a SQL Change Automation (SCA) project in Visual Studio, and import an existing database. As the team make database changes, either in SSMS or VS, they import them into the SCA project, which saves each change as a migration script that is then committed to source control. Read more
Retrospective Database Source Control with SQL Compare
You've found a database that is not in source control. What do you do? Phil Factor shows how to use SQL Compare to generate all the missing object scripts, in Git, and then keep them up-to-date automatically, in response to any further database changes, during development. Read moreMerging a Conflict with SQL Source Control and Beyond Compare
Tony Davis explains how to resolve simple merge conflicts, such as conflicting changes to the same stored procedure, using SQL Source Control and a merge tool such as Beyond Compare. Read moreSQL Compare Snapshots: a lightweight database version control and rollback mechanism
During the proof-of-concept phase of development work, SQL Compare Snapshots offer an easy way to work out what broke, if a change causes some tests to fail, as well as a simple ‘roll back’ technique to return quickly to the last working copy. Read moreSQL Source Control v6 now supports SQL Server 2017, SQL Graph, and TFS 2018
SQL Source Control v6 offers full support SQL Server 2017, including the ability to version control graph databases. and also adds support for Team Foundation Server 2018. Read moreHow to deploy a database plus static data using SQL Compare and SQL Data Compare
Tony Davis shows how to get a database, plus any static data, into source control, and then uses the "/include:StaticData" switch in the SQL Compare Pro command line, fromPowerShell, to automate the process of creating a new build script. Read moreAutomating database deployments to and from source control using SQL Compare and PowerShell
How to use SQL Compare Pro command line with PowerShell to automate the processes of getting a new database into source control, updating the source with the latest database changes, creating a new build script for a database version, and creating a deployment script to synchronize an existing database with source. Read moreRedgate Hub
-
Product Articles
Tips and how-to guides for Redgate products
-
University
Easy to follow video courses
-
Events
Join us online, or get sponsored
-
Forums
Ask, discuss, and solve questions about Redgate's tools
-
Community
Develop your skills and meet Redgate Advocates and Friends
-
Simple Talk
In-depth articles and opinion from Redgate's technical journal