Manage and execute Database scripts in RTC
![](http://jazz.net/_images/myphoto/f273a3f91ae65631f79bbc5089190e40.jpg)
One answer
![](http://jazz.net/_images/myphoto/f273a3f91ae65631f79bbc5089190e40.jpg)
Comments
![](http://jazz.net/_images/myphoto/d0f7b0b7bfc90721959d790b8a9bf79f.jpg)
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.
![](http://jazz.net/_images/myphoto/f273a3f91ae65631f79bbc5089190e40.jpg)
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.
![](http://jazz.net/_images/myphoto/d0f7b0b7bfc90721959d790b8a9bf79f.jpg)
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
![](http://jazz.net/_images/myphoto/f273a3f91ae65631f79bbc5089190e40.jpg)
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?
![](http://jazz.net/_images/myphoto/d0f7b0b7bfc90721959d790b8a9bf79f.jpg)
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)