Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Toad Edge 2.9 - User Guide

Creating Build Steps - Other Systems

In case you are not using Jenkins, you can still take advantage of Toad Edge CI/CD build steps as long as your system is able to run batch files/shell scripts.

This example illustrates how to create a Create Snapshot build step and use it in TeamCity.

To create a new build step in TeamCity using Toad Edge CI/CD Wizard

  1. In Toad Edge, click the CI/CD (Continuous Integration and Delivery) button on main toolbar to open the CI/CD Wizard

  2. Select Create Snapshot from the available builds
  3. Configure the path to toadedge.jar (obtained from here). The exported batch/shell script will use this path to look for the jar file, so enter the path relative to the path of the script (Export Path in the last dialog).
    • We choose to set Export Path to N:\TeamCity\working_directory
    • The toadedge.jar file will be located in N:\TeamCity\working_directory\jars
    • Therefore, the toadedge.jar file path will be .\jars (relative) or N:\TeamCity\working_directory\jars (absolute)
  4. In the next dialog, select the Connection and Database that you would like to take a snapshot of
    • The connection is exported as an XML file. If we choose to place it in a different folder than the exported script, we have to modify the Connection File Name path in the same way as in step 3
  5. You can also change the Output file name and path (relative to the Export Path)
  6. In the final dialog, configure the Export Path first. This is the destination folder for the exported script and other files
  7. Now change the Command File Name if you wish. The suffix of the file name determines whether the file will be a batch file (.bat) or a shell script (.sh)

    • Since we are running TeamCity on Windows, it is better to use batch script format. On Linux, shell script would be a better choice

The rest of the configuration is done in TeamCity. This guide assumes that you have already created a Project and a Build Configuration.

  1. In TeamCity web UI, locate your Project and a Build Configuration to which you would like to add a new build step

  2. Open the Build Configuration and select Build Steps from the left menu
  3. Click the Add build step button
  4. From the Runner type dropdown menu, select Command Line
  5. The fields that you now need to configure are:
    • Working directory (you might need to click Show advanced settings) - this is the directory where TeamCity will look for and run the batch/shell script (in our case, same as Export Path in CI/CD Wizard)
    • Run - select Executable with parameters
    • Command executable - enter the name of the script here (with or without the suffix)

  6. Once you are done with the configuration, Save the changes
  7. Run the Build Configuration to see if everything is configured correctly. If the build step is run successfully, you should see the newly generated snapshot in the script folder

CI/CD Wizard

Continuous Integration and Delivery Wizard

The CI/CD Wizard guides you through the process of creating and customizing various build steps. It saves you the hassle of having to manually write a script with appropriate arguments to use with the Toad Edge® command line interface.

The generated script can be viewed at any time in the wizard by clicking the Command Preview button.

The following table lists all currently available build steps and files/configuration required to export them.

Build Step Requirements Description
Empty database
  • Database connection file (XML)

Runs a query that drops all objects in the selected database

Create snapshot
  • Database connection (XML file)

Stores the structure (not data) of the selected database as a JSON file. The Snapshots can be used as a backup

Create baseline
  • Database connection (XML file)

Stores the structure (not data) of the selected database as a JSON file. This snapshot can be used as a backup or as a baseline for the Compare database with baseline build step

Generate create SQL script

One of the following:

  • Database connection (XML file)
  • Repository (folder structure)
  • Snapshot (JSON file)

Generates a create SQL script from a repository, saved snapshot or a database. The script can be used to recreate the structure of the source (not data)

Generate change SQL script
  • Schema Compare result (folder with JSON files)

Generates a change SQL script to deploy changes to the Schema Compare target based on differences found in the previously run Compare database schemas build step

Compare database schemas
  • Recent Schema Compare
  • Saved Schema Compare (.compare file)

Or two of the following:

  • Database connection (XML file)
  • Repository (folder structure)
  • Snapshot (JSON file)

Compares two different schemas (from databases, repositories or snapshots). The results are stored in a folder that can be used as an input for other build steps

Compare database with baseline

One of the following:

  • Database connection (XML file)
  • Repository (folder structure)
  • Snapshot (JSON file)

And also a baseline snapshot (JSON file)

Compares the given database with the given baseline snapshot. In case any differences are found, an error is raised and the build step will fail

Deploy SQL script
  • Database connection (XML file)
  • Input SQL file

Runs any SQL script on a selected database

Generate HTML comparison report
  • Schema Compare result (folder with JSON files)

Generates an HTML report based on the results of the previously run Compare database schemas build step


Toad Edge Command Line Interface

Toad Edge® command line interface

IMPORTANT: To perform build steps correctly, Toad Edge requires a 64-bit installation of Java Development Kit (JDK), however, 32-bit Java is usually used by default. It is therefore necessary to create a JAVA_HOME system variable pointing at 64-bit JDK directory.

Please do the following steps to perform the configuration:

  1. Right-click This PC and select Properties | Advanced System Settings | Environment Variables
  2. Click New in System Variables
  3. In the Variable Name field, enter JAVA_HOME
  4. In the Variable Value field, enter your JDK installation path, e.g. C:\Progra~1\Java\jdk-11.0.1

NOTE: Toad Edge CLI works for JDK >= 11. The CLI has been tested with JDK 11.

The core Continuous Integration and Delivery (CI/CD) functionality in Toad Edge is provided by its command line interface (CLI). Although the best way to use it is to use the CI/CD Wizard, you can also work with it manually.

To use Toad Edge CLI manually

  1. Download a zip archive containing Toad Edge JAR file and other libraries from here
  2. Extract the archive
  3. Launch the command line utility (Windows) or the terminal (Linux) and navigate to the folder with the JAR file
  4. Execute the JAR file with Java command and additional arguments

Every usable command begins with java --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED -jar toadedge.jar followed by the operation you want to perform and additional arguments.

The available operation arguments correspond to the build steps available in the CI/CD Wizard:

  • -compare
  • -report
  • -sql_change
  • -sql_create
  • -deploy
  • -snapshot
  • -baseline

The operation argument has to be followed by other arguments specifying input, output, settings, etc. To learn which arguments you need to use to perform a specific operation, add the -help argument at the end of your command.

Once you supply all the necessary arguments, you can start performing CI/CD actions without having to launch Toad Edge itself.

Backup and Restore

This section describes the procedures involved with the backup and restore process. Toad Edge gives you the ability to create backups and restoration of your database/schema with the help of a wizard tools as described in the sections below.

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation