Webinar Recording: 7 Steps to Build a Database Deployment Pipeline with Red Gate and TeamCity
The recording of our October 2nd webinar with Alex Yates of Red Gate, 7 Steps to Build a Database Deployment Pipeline with Red Gate and TeamCity, is now available on JetBrains YouTube Channel.
In this practical demo, Alex Yates, Pre-Sales Engineer at Red Gate, demonstrates how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy.
Below are select questions and answers from our webinar.
Q: Would you not recommend using RedGate SQL CI Sync to deploy to production database?
A: Many people do use the sqlCI Sync command to make their production deployments. However, this does have certain drawbacks. Since sqlCI sync is designed for automated builds (with no human interaction) it uses the Red Gate SQL Compare engine on the fly to update the target database. For most people, when deploying to production, it is important to review the script before deployment. For this reason we are building SQL Release. SQL Release plugs-into your existing release management tools (such as Octopus Deploy), to provide you with the update scripts, change reports, and review steps you need to make database changes to production efficiently and safely. Learn more about SQL Release.
Q: We use TFS, TeamCity and Octopus Deploy and use them intensively. However we have a Oracle DB we would like to automate – would this be possible with the Red Gate tool suite?
A: The Red Gate SQL Automation Pack includes all the command line tools from both the SQL Server Developer Bundle and the Deployment Suite for Oracle for a TeamCity Build Agent. We have not (yet) built an equivalent to sqlCI.exe or SQL Release that supports Oracle and we do not yet have a special TeamCity plug-in for Oracle DB. (Although we would like to build these tools in the future.) However, you can find instructions here to set up a similar CI process using the command lines for our existing Oracle tools and TeamCity.
Q: Do these plugins handle Red Gate SQL Source Control migrations?
A: Red Gate SQL Source Control has a feature called ‘migration scripts’. This feature allows users to hand craft update scripts in order to get around the universal issues that are found with database diff tools (such as the table re-name problem, or adding a new NOT NULL column). The current version of this feature that comes with SQL Source Control out of the box we call ‘migration scripts v1’. This version of migration scripts is not supported in the SQL Automation Pack and we have no plans to support it in the future. This is for the reason that we are re-writing ‘migration scripts’ because we want to take a fundamentally more reliable and flexible approach. ‘Migration scripts v2’ is still in BETA but migrations v2 scripts are supported in the SQL Automation Pack/TeamCity plug-in.
About the Presenter:
Alex Yates has worked with database change management tools for four years, collaborating closely with users and dev teams along the way. As a pre-sales engineer, he gets to see a huge variety of server and dev environments, and helps folks solve their database development and delivery problems in whatever way works well for them. Ever the sharer, he also blogs about the lessons he learns: http://www.workingwithdevs.com.
Subscribe to Blog updates
Thanks, we've got you!
Webinar: “New UI for Your IDE: A Glimpse Into the Future”
Join us Monday, October 31, at 5:00 pm UTC (check other timezones) for our live webinar, New UI for Your IDE: A Glimpse Into the Future. In this webinar, join our JetBrains Advocates as they share the New UI with you, giving you a glimpse at some of the visual improvements for IntelliJ Platform IDEs.
Software Development the JetBrains Way: Dogfooding and Other Key Principles
JetBrains has turned 20, and over the years, we've honed methods for development that match the style, values, and needs of our company. These processes work so well for us that we want to share them with others. Dogfooding, for example, has always played a central role in the development of our pro…
Join KotlinConf 2018 Online: Major Kotlin Announcements and Online Q&A
You can meet the JetBrains team at many tech events all over the world. But today we're offering something special – the chance to meet the Kotlin team from the comfort of your own home with KotlinConf 2018 Live. We are happy to invite you to our online event. Join the live stream on October 4-5. …
Join the “GitHub and IntelliJ IDEs” Webinar
GitHub helps teams collaborate around code and work together, and JetBrains IDEs help keep GitHub versioning working productively without switching contexts. Our IDEs also put a pretty face on sometimes cryptic Git commands while preserving the power of high-end versioning productivity. GitHub is…