Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Development to Production / Migration questions

User720285-OracleNov 8 2011 — edited Nov 16 2011
I have a few questions that relate to migrations from a development instance to production, and keeping the environments in sync.

BACKGROUND INFO
As a "side" project at my place of employment I have created an APEX app that is being used and has been very well received. Since it went well, they have now asked for a 2nd larger application and have assigned a 2nd person to work with me on this. The other person is gung-ho that we need to develop in a development instance and then migrate to production when we are ready to go live so we have been working this way. At this point, we have 2 totally separate APEX workspaces, lets call them DEV and PROD for now. This sounds great on paper, but I have experienced a few challenges.

MY QUESTIONS
1. Lets say we log into DEV and make a few minor changes to a single page. There does not seem to be a way to migrate just the one single page or its changes into PROD. It seems the only way would be to migrate the entire app over again, which seems silly if we only made 1 or 2 small changes.

2. Assuming the answer to question #1 is NO (in other words every little change requires migrating the entire app), then how can I avoid the URL changing after each migration?

3. It seems when migrating over DB schema objects (tables, views, procedures, etc..) APEX generates a massive script for you broken into ndividual sub-scripts separated by a slash. However, it also seems that you can't simply run the entire massive script at once, but must run each individual sub-script one at a time. Is there a quicker way?

4. Is there an easy way to migrate over any scheduled jobs I created with DBMS_SCHEDULER?

5. At this point, DEV and PROD are rather out of sync, so I would like to essentially start over and erase DEV and then rebuild it by simply making a copy of PROD (if this is possible). In other words I'm looking for any info on how to create a refresh process. Mind you, I don't have actual DBA access (only access is via the APEX web interface) so is there an easy way to clone one APEX workspace into another without DBA privileges?

6. I assume the answer to #5 is NO. Assuming this, is there a quick way to basically erase everything in APEX workspace, and then I can manually start migrating objects from PROD in?

Any tips/suggestions/recommendations are appreciated.

Thank you,

Paul
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2011
Added on Nov 8 2011
7 comments
1,012 views