Sidd's SQL Solution

In my last blog post , I talked about an effective and easy to use restore script, which can help DBAs in many scenarios wherein one of scenarios I mentioned was migration. Migration in itself is a vague term as it can be used in many different contexts by individuals for e.g. migrating objects from one server to another of same version or migrating objects between servers of different versions etc. In this blog post I intend to cover one such aspect i.e. migration of SSRS reports and objects from one server to another. I’ll try to cover up various scenarios that may arise and what approaches are available to do the same. Problem There are various scenarios that one can identify while thinking of migration of SSRS objects are like migrating objects from one server to another may be due to better hardware or setting up or refreshing non-PROD report server or migrating to another server of higher version or migrating a part or particular folder from PROD to non-PROD servers