Chris,
We have the same APEX workspace/underlying database schema created in each
of our environments. Environments I'll define as a database with the
designation of Development, QA, and Production. Developers only get access
to Development and this is where they do all their work. The DBAs would
migrate the APEX application/database objects to QA for business sign off
and then finally migrate it to Production.
Oracle recommends (but not mandatory) to have your Production APEX
environment created as a run-time version (
https://docs.oracle.com/cd/E59726_01/install.50/e39144/overview.htm#HTMIG29140
).
Another thing to keep in mind is if you refresh your Development
environment with Production. You have to make sure you're not wiping out
the developers work at the workspace and/or schema level. Hopefully they
have that saved to some version control software ahead of time. We refresh
quite often because we are using APEX in our E-Business Suite
environments. I have special scripts to export the APEX applications and
schemas before the refresh then re-import them after the refresh. Once the
environment is available, the developers don't know any different and
continue on their merry way.
Alfredo
On Tue, Jul 26, 2016 at 10:25 AM, Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:
For you guys/gals that are Administering APEX environments, how do you
manage Development/Test/Production copies of APEX projects/workspaces etc?
I'm trying to figure out how I want to architect this setup and I'm just
getting started so I'm looking for suggestions.
I "think" I want a separate environment for Developers to "play in" and an
actual production APEX environment to prevent a muddy environment.
I understand (I think) that I could have both in the same environment - I
could have developers "playing" with new projects in the same APEX
environment where there are live applications but that doesn't seem to make
sense logically. (I understand that the nature of APEX can keep them
separate by utilizing specific workspaces but it seems like I could end up
with a lot of projects that aren't doing anything with only a few "live"
applications.
What are you guys doing with APEX environments in relation to
development/production setups?
Thanks,
Chris
