Red Gate logo

Automation for your database

Automated comparison, synchronization, and documentation for your SQL Server database – including full continuous integration

Try the SQL Automation Pack free for 14 days

An introduction to SQL Automation Pack

The SQL Automation Pack gives you Red Gate’s full set of CI tools, plus command line versions of the tools in the SQL Developer Bundle and the Deployment Suite for Oracle:

  • SQL Server
     

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

  • Schema Compare for Oracle
  • Data Compare for Oracle
  • Continuous integration tools for SQL Server

  • SQL CI
  • TeamCity plugin for SQL CI
  • Team Foundation Server plugin for SQL CI

Use them to save time and effort by automating common tasks like syncing databases, or to move up to Stage 3 of Database Lifecycle Management – continuous integration.

The SQL Automation Pack also comes with a license to run all these tools on a build server.

$4,995

per build agent

Buy now

Get fast feedback, avoid errors, and speed up releases with full CI

The SQL Automation Pack includes SQL CI, which lets you do continuous integration as part of your Database Lifecycle Management process. With continuous integration in place, you can:

  • Get fast feedback on every database change you make
  • Avoid expensive errors when you deploy your changes
  • Catch bugs before they reach your customers

For full details, visit the SQL CI product pages.

Resources

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.

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)

Webinars

7 Steps to Build a Database Deployment Pipeline with Red Gate and TeamCity

Continuous delivery for databases brings speed, efficiency and predictability to your release cycle, by automating database deployments across a pipeline. Setting-up version control, continuous integration (CI) and automated release management can provide you with a steadier stream of reliable releases.

In this practical demo, Alex Yates, Pre-Sales Engineer at Red Gate, will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. You’ll learn best practices for continuous integration, continuous delivery and automated deployments to set-up your own pipeline.

Watch fullscreen video

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)

"The tools have given us the ability to be a lot more productive, and to save a hell of a lot of time... They allow us to have a huge amount of confidence in this major release."
Neil Jellis - Technical Lead, Tissue Typing Systems

Find out how Tissue Typing Systems came to trust their database deployments after switching to Red Gate’s DLM tools.

Read the case study (PDF)

Further reading

Best practice blog articles and case studies

Walkthroughs and evaluation resources