Earlier this year I documented how I configured Octopus Deploy to use Red Gate’s SQL CI product to deploy SQL Server databases. Since then Red Gate has released a product that is better suited to the task: SQL Release. The point with SQL Release is that the creation of the upgrade script and other associated deployment resources (more on what…
Monthly Archives: December 2014
How to change the default port in Jenkins
tl;dr Go to C:\Program Files (x86)\Jenkins (I’m using Windows Server 2012 and assuming it’s installed to default location) Open Jenkins.xml Edit the –httpPort argument (you may need to edit default permissions) Restart the Jenkins service Now Jenkins will permanently use the new port There are various other solutions via the command prompt but this one just seems so much simpler and…
Deploying databases using Red Gate’s ‘Migrations v2’ functionality
tl;dr: A solution to deploying database changes that diff tools cannot handle Migrations v2 offers a way to deploy complex changes (e.g. table renames, new NOT NULL columns and data migrations) using Red Gate SQL Compare by allowing the user to add custom scripts, using Red Gate SQL Source Control when needed. These custom deployment scripts are combined with SQL Compare generated…