An Automation License for continuous integration starts at $595. To purchase, please get in touch.
Automation License for continuous integration
Set up SQL Server continuous integration with the SQL Developer Bundle
Continuous integration for SQL Server
Continuous integration is not just for application developers.
Database code is still code, so the considerable benefits of continuous integration are also available to SQL Server developers.
All you need are the right tools.
Why is continuous integration (CI) best practice for writing code?
Fixing bugs is cheap
Testing changes up-front means you spot and fix errors early on. Problems don't have a chance to leave your development environment, let alone make it into production.
Collaborating on development becomes easy
When your code passes your tests, it joins the trunk and becomes available to the entire development team. There's no code waiting to be shared and no painful merges. Instead, everyone can build on each other's work as soon as possible.
Your code is always working and up-to-date
Only code that successfully passes tests is shared, so you can rely on the trunk working properly. Because code is integrated at once, the trunk always represents the most up-to-date version of the database.
What does continuous integration for databases involve?
Continuous integration for databases involves four processes:
- Ensuring that changes to the development database are in step with changes to your application
- Testing the database creation script
- Testing the database upgrade script
- Testing database code, such as stored procedures, views, and functions
Red Gate tools help with all four.
The tools in the SQL Developer Bundle can be used together with an existing continuous integration system to make your database part of the CI process.
What does the license actually do?
The Automation License lets you run the command line versions of SQL Compare, SQL Data Compare, SQL Packager, SQL Doc, and SQL Data Generator. The sqlCI.exe tool, the TeamCity plugin, and the build scripts are provided free, however, they call the Red Gate tools listed above which require a license.
How do I license it?
It depends on how you're using the integration tools. For more information on using the Automation License, this Support article may help answer your questions
To find out about continuous integration for your database, have a look at our whitepapers below.
Our continuous integration and continuous delivery whitepapers
A look at integrating SQL Server databases into an existing build automation process, and how Red Gate tools can help. Download the whitepaper as a PDF.