Overview

As a database script developer, once you have reached a stable state with your .sql scripts, you will check them in your company Source Code Management system (SCM) like TFS, SVN, Git Stash, BitBucket, ...

Once those scripts are checked in the SCM, a job to package them and deploy them in the REF Database will be started automatically (CI) or manually.

As part of this job the following actions will happen:

1. Checkout the SQL code from the appropriate branch 
2. Checkout the DaticalDB project from the main branch
3. Run the deployer through the Command Line Interface (CLI) "hammer groovy deployPackager.groovy", this will includes:
   
4. Create an artifact ( comprised of the DaticalDB project directory)
5. After the artifact has been created, the process will be the same in each environment:
   1. download the artifact
   2. run the CLI to do a forecast
   3. run the CLI to execute the deployment itself

SCM

Git

TFS

Build Systems

Jenkins

IBM uBuild

Atlassian Bamboo

ElectricCloud ElectricCommander

Artifact Repositories

IBM CodeStation

JFrog Artifactory

ElectricCloud Artifact Repository

Deployment Systems

IBM UDeploy

ElectricCloud ElectricFlow