Am currently writing a little system to support the place I work. Having looked at dozens of apps, none of them was anything like what we needed so we decided to "roll our own". So, I'm planning on having two Oracle Apex setups - a dev/test environment and the live environment. I'm planning on logging all changes so I know what has changed cumulatively. For SQL Objects, I just need to script the necessary changes in SQL Explorer and do them manually. That's not a problem, but what's the easiest way of getting changes to Apex Objects from one system to another? By changes I'm talking about new and changed Apex Objects - pages, LOVs etc etc on an ad-hoc basis. I know there's a component export which dumps things into a SQL script but reviewing the script, it looks like it hard-codes some values which concerns me greatly. like application ID and so on. I'm hoping that Apex will be smart enough to import the script and add the objects to my App..
Thoughts? Experiences?
Cheers
Mark W