Thank you for answering.

Can this be done using linked servers within one SQL Server? Eg. Server linked to itself.

Currently we have one production SQL Server. Production databases and control database...