I have a test environment where we regularly change the active set of server with another non-active set. i.e. Suppose I have 3 roles and 3 servers in Set A, and 3 servers in Set B. I will be swapping the servers from set A to set B and vice versa twice in a week. The application will be pointing first to set A which set A is active and then to Set B when it will be active after swapping. This is a regular process.
What problem I am facing here is with reports. My reports points to all servers in Set A. Now whenever I do swapping, I have to manually update all the data sources from Report Manager Page. This is a hectic task and many times I do forget it. I want to automatize it. Can anyone help me here?