We would like to introduce Wordpress into our cloud environment. We have 3 tiers of development severs and the production tier. Our environment is as follows: Dev dev.mysite.com, Test test.mysite.com, Stage stage.mysite.com, Prod mysite.com
We need a clean way to migrate the site through each environment without having to use an update query or script such as https://interconnectit.com/products/search-and-replace-for-wordpress-databases/. Particularly in the stage to production migration phase, where the code is signed off and frozen. Running such a query after code freeze is against company policy.
Is there a way to set the site URL to mysite.com and dynamically prep-end the appropriate sub-domain based on the server environment?