Continuous Integration for Database Developers

About a year ago I posted a demo showing how to manage the full development lifecycle of your database code with the help of Developer Cloud Service. Since then, we released new versions of both Developer Cloud Service and JDeveloper that make the experience even smoother and add more features — so I figured I'd record a small, updated demo.

In this demo, I'm starting from an existing project that has a list of tasks being tracked in a development sprint in the new Agile tab in Developer Cloud Service — which gives you a great view of your development effort and progress. 

(If you want to see how you create the initial project and add issues to it check out the previous demo). 

A few new things you'll see in this demo:

• The new Agile/Sprint management dashboard in Developer Cloud Service.
• Task tracking integration in JDeveloper.
• Updating definition of database objects in JDeveloper and generating SQL scripts.
• Branching Git repositories.
• Code review for SQL files.
• Build automation for DB changes with Ant — including deployment to a cloud database.

Note that in this video I'm using a cloud instance of an Oracle database where port 1521 is open for SQLNet communication. The instructions for opening this port for communication on an Oracle Cloud Database are here.

Another approach that you can take is to use scripts that execute commands using SSH on the Database Cloud Service - you can see this approach in action in this video showing Developer Cloud Service managing an Oracle APEX Lifecycle.  

The Ant script used in the sample is:

<?xml version="1.0" encoding="UTF-8" ?>
<project xmlns="antlib:org.apache.tools.ant" default="init">
    <target name="init">
        <tstamp/>
    </target>
    <path id="antclasspath">
        <fileset dir=".">
            <include name="ojdbc7.jar"/>
        </fileset>
    </path>
    <target name="deploy">
    <sql driver="oracle.jdbc.OracleDriver" userid="C##xxxx" password="xxxx"
         url="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:ORCL" src="./database/DATABASE1/dbcreate.sql"
         classpathref="antclasspath" onerror="continue"/>
  </target>
</project>

Note that you need the Oracle JDBC jar file to be accessible from the Ant script - I just included it in my Git repository.

If you like to try this out with your own database development project - get a trial of Oracle Developer Cloud Service here.