An Automation License for continuous integration starts at $595. To purchase, please get in touch.
0800 169 7433
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.
With an Automation License, you can run the tools from the SQL Developer Bundle on your build server, bringing your database into your continuous integration process.
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
Continuous integration for databases using Red Gate tools
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.
Automated deployment using Red Gate tools
A look at automating the deployment of applications and databases side-by-side, and how Red Gate tools can be used to manage the process. Download the whitepaper as a PDF.
How do I get started with continuous integration?
We provide free resources to help you connect your database to your CI server or to Team City. If you have any questions, feel free to get in touch with us at sqldev.info@red-gate.com.
