Oracle Application Express Dev Environment

Question

When developing with application express, I am struggling with how to implement version control and how to have both DEV and PROD versions of an application. How do you publish changes from dev to prod? I know that I can export the entire application and then import into production, but is there a way to just import changes easily?

APEX 3.2 on Oracle 10g

Answer 1

For our Apex Applications* we have adopted the export\import method at the apex application level. Can be bit of an overkill for small changes but it works.

This thread on the Apex OTN forum seems to point to application level exports for version control as well.

*Just to clarify where I say Apex application what I mean is the sql file that Apex produces on an export.