Settings and activity
3 results found
-
36 votes
An error occurred while saving the comment -
0 votes
An error occurred while saving the comment 
Neil Anderson
commented
Hi Doug,
I like this idea and removing the error when there is a cycle is definitely something we should sort out. I have a test version of Data Compare available which does not throw that exception if you have enabled the option to "disable constraints". It is located here http://goo.gl/JVJnf
Thanks,
Neil -
12 votes
An error occurred while saving the comment Neil Anderson
commented
Hi Gavin,
We've removed the unnecessary quotes for object identifiers in v3 which is soon to be released. Some of the things you mention can be turned off via the project options, the parallel clause for example.
I'll have a close look at the others and see what we can do.
Thanks,
Neil
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/Database
Deploy the changes to a database:
sco.exe –s Database{WIDGET} –t System/Password@oracle.red-gate.com/ORCL{WIDGET} –deploy
That’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