Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Manage and execute Database scripts in RTC

Hi,

I'm using RTC 4.0.4 to do some builds/deployments, but some of them require to execute DDL scripts, is it possible to do this Database integration with RTC?

Thanks

0 votes



One answer

Permanent link
anyone has any ideas for this? please :(

0 votes

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)

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 82

Question asked: Mar 27 '15, 7:59 a.m.

Question was seen: 3,697 times

Last updated: Mar 30 '15, 1:32 p.m.

Confirmation Cancel Confirm