Redgate SQL CI Jenkins Plugin

Introduction

The Redgate SQL CI Bamboo Plugin is an open-source Jenkins plugin for using Redgate SQL CI from within Jenkins. Four tasks are available:

1. Build your database from a Redgate SQL Source Control source folder to a nuget package.
2. Test your database by running the tSQLt tests in the package.
3. Sync your database to another CI database.
4. Publish your database to a NuGet feed.

Installing

If you just want to use the plugin, follow these instructions:

1. Contact [email protected] for the latest plugin file.
2. Stop Jenkins.
3. Copy redgatesqlci.hpi to C:\Jenkins\war\WEB-INF\plugins
4. Start Jenkins.

How to build/debug the plugin.

A basic tutorial for developing plugins is at https://wiki.jenkins-ci.org/display/JENKINS/Plugin+tutorial.

Simply:

1. Clone this repository.
2. Install Maven.
3. Open a command prompt at the repository root directory. Then run:
   • set MAVEN_OPTS=-Xdebug -Xrunjdwp:transport=dt_socket,server=y,address=8000,suspend=n
   • mvn hpi:run A development copy of Jenkins starts-up with the Redgate SQL CI plugin loaded.

JetBrains IntelliJ IDEA is a good environment for developing and debugging Jenkins plugins. There is a free community edition.

Help!

Email us at [email protected] for assistance with building or using this plugin.

"I've got an idea for an improvement"

Great! Code it up and submit a pull request. If it looks good, we'll merge it in.

Alternatively, email us at [email protected]. We're always keen to hear your ideas and how you're using our tools.