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