I'm looking for a recommendation on how best to separate “development” and "production" environments for APEX applications.
Is it better to have completely separate databases, each with their own instances of Application Express so that the workspace name between the two is the same?
Does it work to have only one database but with two workspaces, one for development and the other for production? Does moving apps between those two workspaces create problems since the workspace name would be different?
What are advantages and disadvantages to either approach?
Are there other approaches that work well, or is there a BEST PRACTICE that should be followed?
Any guidance, advice, or links are greatly appreciated - thank you!