Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Command line to deploy Offline Database Project

RRamos84May 16 2015 — edited May 18 2015

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

This post has been answered by thatJeffSmith-Oracle on May 18 2015
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 15 2015
Added on May 16 2015
3 comments
888 views