We are wanting to source control our Oracle Schema - as we have a number of SQL Server databases on our estate we would like to use a common tool - for the SQL Server databases we use Visual Studio 2010 / dbpro which nicely source controls each object, integrates into our CI environment, and assists build/deploy to UAT and Live.
We would like to do the same for our Oracle databases however, from the tools on offer, they don't seem to be at all close to the functionality VS2010 provides - the VS2010 Toad plugin is no longer supported; we are trialing the ODT (Oracle Data Tools) plugin however I can't seem to locate how I can generate a delta script (compare) of an Oracle database project Vs a target Oracle instance - this seems to be a fairly fundamental requirement
Does anyone have any ideas ? It might mean we may need to combine the source control capabilities of VS2010 with the compare (generate delta scripting) of another tool like SQL Developer. Has anyone gone down this path ?
Found this update in the Oracle forums:
Question:
Hi,
how can i do a schema compare in Oracle Developer Tools for visual studio ? and is it possible to do compare through command line from ODT or by any other way?
Answer:
This is now available in ODT 12.1 or later.
Here is a walkthrough:
http://apex.oracle.com/pls/apex/f?p=44785:24:1995235124222:::24:P24_CONTENT_ID%2CP24_PROD_SECTION_GRP_ID%2CP24_PREV_PAGE:8210%2C%2C24
Edit:
From my brief check, it enables comparison of existing schemas, but not comparison of the project with a database.