Maven plugin
With a maven plugin developers could easily automate deploys. The plugin should be configureable, but include the possibilites of first pulling from a developer database into svn. Then pushing the changes from svn (including other changes registered in SVN) towards a deploy test database.
-
AdminNeil Anderson (Admin, Redgate) commented
Hi Lasse,
Thanks for the suggestion. For the moment you can do continuous integration with any continuous integration system by running the Schema Compare for Oracle command line on your build server. I believe the Maven command line plugin is called Exec Maven.
Here is an example of deploying some changes from source control to a database:
Checkout the folder from svn:
svn co https://code.red-gate.com/svn/Users/Neil.Anderson/DatabaseDeploy the changes to a database:
sco.exe –s Database{WIDGET} –t System/Password@oracle.red-gate.com/ORCL{WIDGET} –deployThat’s it! You can then check that the database and the script folder are the same, this command should return 0 if there are no differences:
sco.exe –s Database{WIDGET} –t System/Password@oracle.red-gate.com/ORCL{WIDGET}So using the command line you should be able to add a build task that deploys the database continuously when the source control repository changes.
There is more information about the command line here:
http://www.red-gate.com/products/oracle-development/schema-compare-for-oracle/cmd-line-help -
David J. M. Karlsen commented
Providing APIs would also do it, so we could roll our own integration (maven plugin, or whatever other tool).