You can migrate the upgraded rules from one region to the other like you were trying to do.
Instead of using db copy of the rules schema to the higher environment you could use the migrate script. You can essentially migrate the upgraded rules to your new rules schema in higher environment and also setup the connections between the new rules schema and the data schema in the higher environment.
Then you need to do the data schema upgrade step which will involve generating and applying the ddl changes needed for the data schema and upgrading the data schema.
There should be an appendix in the deployment guide that discusses this type of an upgrade.
Thanks Celeste. for your response. So when you say migrate rules schema from one region to another, you mean run the migrate script ? So since this will be 2 different DBs we will need Ids which has access to both these DBs? Since rules are upgraded, why cant a simple schema copy work?
Yes, the deployment guide have instructions to perform upgrade with 2 databases, I think you are referring that. Does that work for different environment?
And for QA, running data only upgrade on data schema gave lot of missing table and missing column errors. We had to recreate the tables and add columns to run the data only upgrade.