3 Replies Latest reply on May 18, 2015 1:36 PM by thatJeffSmith-Oracle

    Command line to deploy Offline Database Project

    RRamos84
    RRamos84 May 16, 2015 5:45 PM

      Is there a command line tool out there that will allow me to deploy the database objects I defined in an Offline Database project into a target database?

       

      I want to Continuous Integrate an Oracle DB so I'll need to:

       

      • Compare a target DB with DB objects defined in a Offline Database project
      • Generate a DIFF script from that comparison
      • Execute the DIFF script on the target DB

       

      My goal is to automate those steps via some kind of command line tool.

      No data will be involved. Just DB Objects like procedures, tables (structure only), types, etc.

       

      On the past (2011) they said it was not possible (https://community.oracle.com/message/9840162)

       

      If it still not possible, is there another way to continuous integrate Oracle DB from a pre-defined model? Something like DACPAC to MSSQL, but for Oracle DB ?

       

      Thanks

      Rodrigo