For those who read this,thankyou for sharing in me cursing an application team.
The situation we have a system that keeps tracks of a lot of machines,how they perform,oil checks ect...
The data is being collected in a series of databases called CDC_Country on a server cluster called the Central Landing Zone or CLZ for short.
The CLZ also contains databases for all applications,these only have views on the CDC tables.
A simple system makes it so that once a day the content of the views is copied over to tables on 2 server clusters which are called 24 & 14 (1 is a server cluster where the application devs work on,the other is the test enviroment)
It takes 5-6 hours to copy this over,now they want that the data available twice per day (so it needs to be updated twice per day),both copies must remain available to the users of the 24 & 14 but by default their only allowed to see the lastest data.
So the following is being proposed: instead of pumping over the data,but up snapshot database's on the CLZ (1 for the morning update,1 for the evening) & replace the tables on the 24 & 14 with views to the CLZ
Now when I was told the marvellous concept 2 ideas came to mind
1)Views can't work with a dynamic source
So I'm at a point where I'm getting a little stir crazy about what to do and if it's even possible and what would the potential solution be.
I thank you in reading this crazied situation (Not to mention that 2 days before the normal go-live of the project this bomb shell was dropped upon us)