I'm running separate dev, test, and production environments for an APEX application. Looking for best practices/deployment script templates for maintaining back-end schema objects in sync. I'm guessing such scripts would include the temporary backup of target objects, logging, and error trapping for rollbacks. Hoping for examples of both DDL and DML. Any sources/resources?
I'd like be able to restore objects to their original state following the execution of any script. My available tools are the APEX SQL Workshop and SQL Developer. I'm rather new to Oracle and I'm working remotely, so I don't have a mentor who can easily show me the ropes.
Thanks in advance.
- Tony.