Red Gate logo

Continuous integration and automation for your database

Set up database continuous integration, automation, and schema monitoring.

An introduction to SQL Automation Pack

The SQL Automation Pack provides the command line versions of the tools in the SQL Developer Bundle and the Deployment Suite for Oracle.

You can use them to build automated processes for databases such as continuous integration, schema monitoring and release management.

It includes the command line versions of:

  • SQL Compare
  • SQL Data Compare
  • SQL Packager
  • SQL Doc
  • SQL Data Generator
  • Schema Compare for Oracle
  • Data Compare for Oracle

The sqlCI.exe tool, the TeamCity plugin, and the build scripts for MSBuild and NAnt are also included for free.

Download 14-day free trial

$4,995

per build agent

Buy now

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 a license of the SQL Automation Pack, you can run tools from the SQL Developer Bundle on your build server, bringing your database into your continuous integration process.

Three reasons why Continuous Integration (CI) is 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:

  1. Ensuring that changes to the development database are in step with changes to your application
  2. Testing the database creation script
  3. Testing the database upgrade script
  4. 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.

Resources

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.

Read the whitepaper (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.

Read the whitepaper (PDF)

Case studies

How we learned to stop worrying and love continuous integration

Dave and Annette talk about their development environment and how to use Red Gate tools together with TeamCity continuous integration as an approach to running database projects.

Read the case study (PDF)

Frequently asked questions

At the moment, the SQL Automation Pack is particularly for people who have their own continuous integration systems in place and use the SQL Developer Bundle.

If you don't have the SQL Developer Bundle, you can try it out for free, or get in touch with us at sales@red-gate.com to discuss how Red Gate can help bring continuous integration to your business.

What is the SQL Automation Pack?

The SQL Automation Pack allows you to use Red Gate tools as part of an automated process installed on a server, virtual machine, or build agent.

Do I need a license of the SQL Automation Pack?

If you are using the command line tools from any of the products in the SQL Developer Bundle on a build server, you will need the SQL Automation Pack

How many will I need?

You need one license for every concurrent Red Gate process you run on your server. If you have a single build instance that handles tasks, you only need one license. If you have more, running multiple tasks simultaneously, you need a license for each instance. In Team City, these instances are referred to as build agents.

I already have a SQL Developer Bundle license - doesn't that cover me?

The SQL Developer Bundle and its constituent tools are licensed per-user, to be installed on an individual's PC or laptop for their own use. The automation of the tools as part of a server installation is not covered by your SQL Developer Bundle's per-user licensing.

Do I need the SQL Automation Pack if I'm using the command line tools on my desktop machine?

If you are using the command lines for SQL Developer Bundle tools on your own PC, rather than configuring a build server or build agents to benefit your team, you do not need the SQL Automation Pack. This is already covered under your existing per-user license.

Do I need to own a SQL Developer Bundle license to use the SQL Automation Pack?

The SQL Automation Pack contains standalone command line tools for use in automated processes. For developers to have the best experience, we strongly recommend they also use the SQL Developer Bundle or the Deployment Suite for Oracle so that they have the full versions of these tools for their own use.

The SQL Automation Pack command line tools are designed to be used alongside the GUI tools in the full bundles. Many command line features are reliant on features in the corresponding GUI tools which are included in the SQL Developer Bundle or the Deployment Suite for Oracle. For more details, please contact sales.

What does a SQL Automation Pack License cover

A licence of the SQL Automation Pack allows you to use any of the following products in an automated process in one automated process:

  • SQL Compare
  • SQL Data Compare
  • SQL Packager
  • SQL Doc
  • SQL Data Generator
  • Schema Compare for Oracle
  • Data Compare for Oracle
  • sqlCI.exe
  • The TeamCity plugin
  • Build scripts for MSBuild and NAnt

How do I license it?

It depends on exactly how you're using the integration tools. For more information on licensing the SQL Automation Pack, please refer to the full product documentation.

Further reading

Best practice blog articles and case studies

Walkthroughs and evaluation resources