Product articles
How to build multiple database versions from the same source: pre-deploy migration scripts
The final part of Alex Yates's three-part series tackles the complicated issue of automating deployments when the same table might have a different structure, in different production versions of the database. Read moreEliminating ‘noise’ from database deployment scripts
How to eliminate false positives, and avoid making unintended changes to a database, when comparing the schema of two SQL Server databases. Read moreHow 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 moreDeploying schema changes to multiple databases using the SQL Compare command line
How do you push out the schema changes to ten copies of the database on ten different servers, as part of a deployment? 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 moreComparing SQL Server Databases using DacPacs and SQL Compare
How to compare SQL databases using DACPACs, script out differences and then run a database deployment task to synchronize the schema of the target database. Read moreSQL Deployment Automation using SQL Compare Command Line
SQL Compare provides a command line interface (CLI) for running database schema comparisons and generating a deployment script, as part of a scripted process. I'll demonstrate how to do this with a 1-click process, using a batch (.bat) file. Read moreUsing SQL Compare with In-Memory OLTP tables
SQL Compare can help you compare two databases that have In-Memory objects, the tables, their indexes and any natively-compiled procedures, and generate the appropriate scripts. 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