Hello. and good morning. I might be asking something which is more a infrastructure decision as opposed to sql server. currently in our company , when we upload a new version ( C# + SQL) - we brings many workers to check the production.
But I said to them why not duplicate/clone IIS + SQL server a month before version upload so QA can test a "cloned-going-to-be-production" environemnt ?
with C# there is no problem. I can just copy the code to the server. But the problem is that throughout this month - the real production's db got new data becuase of the actual company's work. So my questio…