Automated sql code deployment using Github and Jenkins DevOps

Install GitHub

Download Git

Installation Steps

After finish,Please create repository where code will be saved


There is no code now

I am creating sample code in c:\mygitrep directory



We need to again login to git from program and rescan.

Now stage unchanged

Now sign off

Please commit now

Now we will get this screen.

Please create a github repository to store code in central repository online.I login with my user.You can also create your user in github.

Now take the url and put into arbitrary url


Now you can push the code to git hub


Install Jenkins

You can get admin password from below location

Default plugin as well as github integration plugin needs to be installed.

Jenkins is ready with default url localhost:8080


Please provide git local installation file details in below


Please now go to create new job and provide git location

Please enable Poll scm which will poll and check if code is modified


This Build section is very important.You need to put DB tns names and power shell command to run sqlplus

Please create following file under your local repository->.git->hooks.

The content of the file will be as following

Now we need to test if change in code configured in git repository will trigger the Jenkins job

Great.The change in sql code trigger the Jenkins job automatically kick off.


You may view job result fail or successfully

Please check that you have two version of same sql in github repository

3 comments on “Automated sql code deployment using Github and Jenkins DevOps

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>