Jenkins : Continuous Integration With Toad Edge Plugin

Plugin Information

View Continuous Integration with Toad Edge on the plugin site for more information.

Compatibility matrix

Plugin version

Toad EdgeTM version
1.01.1.0
1.21.2.0
2.02.0.x, 2.1.x

Introduction

This plugin allows user to automate Database Lifecycle Management tasks from within Jenkins. Following tasks are available:

  1. Compare database schemas - Compare two different schemas (from database, model or snapshot). Based on it you can do in the next steps further actions (like generating report or alter script)
  2. Compare database with baseline - Compare your current schema with baseline. In case the schema is different the build step will fail.
  3. Create baseline - Set the current state of your schema as the baseline to detect any changes that has been made into the schema since now.
  4. Create snapshot - Save your database schema to a file to have the possibility to return to it later.
  5. Deploy SQL script - Execute any arbitrary SQL script on a selected database.
  6. Generate Jenkins HTML comparison report - Generate a HTML report based on a previous schema compare build step. This report is accessible via build detail within build history in Jenkins.
  7. Generate standalone HTML comparison report - Generate a HTML report based on a previous schema compare build step. 
  8. Generate change SQL script - Generate an alter SQL script based on a previous schema compare build step.
  9. Generate create SQL script - Generate a create SQL script from your VCS repository, saved snapshot or database.

Installing

First you need to install the plugin.

  1. Open your Jenkins.
  2. Go to Manage Jenkins > Manage Plugins > Available and search for Continuous Integration with Toad EdgeTM.
  3. Check the Continuous Integration with Toad EdgeTM, and finish installation

In order for plugin to work properly it needs Continuous Integration with Toad Edge CLI libraries. Those are distributed as .zip file. To make it work:

  1. Upload libraries to your jenkins master node
  2. Go to Manage Jenkins -> Configure System and look for Continuous Integration with Toad Edge section
  3. Fill-in path to libraries to "Continuous Integration with Toad EdgeTM libraries .zip file" field
  4. Save

Documentation

Documentation for Continuous Integration with Toad EdgeTM can be found on Quest Software Inc. pages.