[Update Feb 2017 - new SQLcl functionality in Developer Cloud Service makes the "deployment" step even simpler - see this blog entry.]
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'll 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:
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">
<sql driver="oracle.jdbc.OracleDriver" userid="C##xxxx" password="xxxx"
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.