Hi Marcus
I also work in an environment with 4 instances of webcon
A minor problem is setting the fourth unique environment type, we have 2 times TEST.
The only problem is importing to this environment if the data sources, constants have a different configuration, connection, than the second TEST.
I added copies of the TEMP_WFDataConnections and TEMP_WFEnvironmentGlobalVariable tables.
Which I periodically feed with data if after migration any connections, constants are different for these 2 environments.
During the next migration of processes, the trigger set on the migration history column (which changes after migration) calls a job that overwrites the table with the correct data that I fed earlier.
it works quite well, you have to remember to stick to global constants so as not to overwrite local ones in the process (too much work with this), or instead of constants add business rules, etc. You also have to feed these local tables TEMP_WFDataConnections and TEMP_WFEnvironmentGlobalVariable from time to time if after migration new sources, constants, different in the context of configuration for TEST - TEST are added
Regrds