Product articles SQL Toolbelt Database Source Control
How to build multiple database versions from the same source: post-deploy scripts
In Part 2 of his series, Alex Yates shows how to use a combination of post-deployment scripts to handle cases where a code object exists in multiple production instances, but in different states. Read more
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 moreHow to build multiple database versions from the same source: object filters
How to use filters in SQL Compare to avoid deploying objects that exist only in the source to databases where they may not be required or appropriate. Read more
How to version control a database using GitHub and SQL Source Control
This article explains some simple steps to create a GitHub database repository and then version control your SQL Server database, for team development work, using SQL Source Control. Read moreVersioning an existing database using SQL Source Control
How to bring an existing database under Git version control. Read moreHow to create a directory of object-level scripts using SQL Compare
How to create a directory of object-level scripts from an existing database using SQL Compare GUI or command line. Read moreSource 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 moreSource 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 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