Manage and execute Database scripts in RTC
One answer
Comments
sure.. what kind of integration do you want? you can run the DB DDL tool from a batch file or ant script.
when I use mysql and have RTC build on a linux server, its pretty easy.
Hi Sam,
Thanks for the reply, so there's no built-in solution for Oracle databases right? Integration would be execute the DDL scripts on a Oracle database.
correct.. JBE runs one command.. YOU have to build what you need into that one command.
you could also use Jenkins as your build tool, and it runs a 'job'.
you can use the Jenkins plugins to construct a similar set of 'steps' , but fundamentally the same.
jenkins also can provide parallelization
Hi Sam,
Thanks again for the reply, unfortunately, we cannot use Jenkins or any other OpenSource tool, we would need to build and execute this ddl file through RTC + Windows machine.
Would be possible?
sure.. I assume you use some script to execute the build.. you would add a step to that to do the database work. (call a sub script for example)